How To Get Full Permission:Add, Delete, Update, Edit In The SQL Server Database

Jul 26, 2007

I wrote the following statements to update a SQL server database:

Dim MyDb As Database
Dim MyRs As Recordset

Set MyDb = DBEngine.Workspaces(0).OpenDatabase("AMD", dbDriverPrompt, False, "ODBC;DATABASE=AMD;DSN=Remote")

Set MyRs = MyDb.OpenRecordset("SELECT AllAttendanceEvents.* FROM AllAttendanceEvents ORDER BY AllAttendanceEvents.EntryTime DESC")


While Not MyRs.EOF
MyVal = MyRs!EntryTime
Debug.Print MyVal
MyRs!Ix = 50099

When it execute the red line statement, it generates the error:Cannot update. Database or object is read-only.

This error is generated isnpite that I already checked the boxes: SELECT, INSERT, UPDATE, DELETE in the Permissions page of the tables?

Please advise.

View Replies


Add, Edit, Delete Fields In Access Database Via ASP

Apr 13, 2007

I have recently gotten a handle on ASP and found it to be a very powerful tool.

I am wondering if there is a way to design a page where I can list my database tables, and by using a command, I can use asp to do the following.

1. Add or delete table
2. Add, delete, or update fields within the tables

for instance: rename a field 'PersonName' to 'MyName' without change the original values in the field 'PersonName'

I have searched all over the net and could not find information on this subject.

Thanks in advance.

View 3 Replies View Related

Modules & VBA :: Update Data In A Bunch Of Tables Of SQL Server Database

Apr 25, 2014

I need to update data in a bunch of tables of a sql server database. The database has 300 tables which I have linked via odbc. I'm hoping there is a simple way, using vba, to loop through my linked sql server tables and determine which of them are views as opposed to tables.

View 1 Replies View Related

You Do Not Have Permission To Enter This Database

Oct 5, 2005

I get the above message when I try to open a database created by someone that no longer works here. I tried to create a new version of the workgroup information file and assume the permissions of the administrator, but I still cannot access the database. Any leads?


View 5 Replies View Related

General :: No Permission To Open Database Object Error

Jan 20, 2015

I have a 2003 .mdb file and the associated Workgroup Information File which normally resides on a network in a folder V:V-Base-DatabaseDATA. I have the Workgroup Information File.

The database is unsupported and we need to migrate the data to a new web based database.

When I try to open the database with the shift key down I get the following message :

You do not have the necessary permission to use the V:V-Base-DatabaseDATAV-Basebe.mdb object.

What is the best way to access the data and do I need to do this on the server instead of a local drive off site?

View 1 Replies View Related

General :: Saving Data - Update Or Cancel Update Without AddNew Or Edit

Apr 13, 2013

My membership database has worked fine until recently. Now I cannot save inserted data. On attempted saving "Update or CancelUpdate without AddNew or Edit" appears.

The problem. relates to 2 tables Member and Addresses. PK in the parent table Member is ID. In the Addresses Table the FK is ID. There is a One to One relation between the tables and Referential Integrity is set. I know 1 to 1 is not good but it worked fine in this small database.

Browsing the all of the existing records is fine.

View 9 Replies View Related

General :: Delete File From FTP Server

Nov 2, 2014

I need deleting a file from a ftp server. I have the code for uploading but I can't seem to figure out how to delete a file. This is the FTP module I'm using


Public Sub UploadFileToFTPServer()
On Error GoTo ErrHandler
Dim lngRet As Long
Dim abytData() As Long
Dim lngBytesWritten As Long

[Code] ....

And this is the code for uploading i use in the form when i click a button

Dim objFTP As FTP
Const conTARGET = "ftpserver"
Set objFTP = New FTP
With objFTP

[Code] ....

All that works like a charm.

Code to delete a file from the ftp server, i'm kind of stuck.

View 3 Replies View Related

Modules & VBA :: How To Delete File On Http Server

Sep 13, 2013

This is a follow-on to my post here: [URL]....

How can I change the code to delete the file if it exists?

View 1 Replies View Related

Forms :: Add / Edit And Delete Records From A Table Based On Combo

Dec 12, 2013

I have a form to add, edit, and delete Records from a table. I am using the following VBA

Private Sub cmdEdit_Click()
If Not (Me.frmlEmpDetailsSub.Form.Recordset.EOF And Me.frmlEmpDetailsSub.Form.Recordset.BOF) Then
With Me.frmlEmpDetailsSub.Form.Recordset
Me.txtAddEditname = .Fields("Name")
Me.cboRoster = .Fields("Roster")
Me.cboPermFctn = .Fields("PermFctn")
End With
End If
End Sub

Instead of referring to the Subform to load the data i would like to refer to a combobox:


Its not an issue but This Combobox contains 5 columns...

View 2 Replies View Related

General :: Update Or Cancel Update Without Add New Or Edit

Nov 3, 2013

I get an error "update or cancel update without add new or edit" which seems to point to this code.I am using MS Access 2010.


Private Sub Form_BeforeUpdate(Cancel As Integer)
'Store when record was last modified and by who.
'Initially stores when the record was entered.
If Me.NewRecord = True Then Exit Sub 'Exit if new record
Me.DateLastModified.Value = Now()
Me.LastModifiedBy.Value = getUser()
End Sub

View 2 Replies View Related

Open Database Without Opening Full Program

Feb 18, 2008

Im trying to open my database switchboard without having the whole Access program open. Is there a way to have only the database open without the whole program?

View 13 Replies View Related

General :: Creating A Database Full Of Contacts

Jan 2, 2014

I'm creating a database full of contacts. I have a contacts table with detailed info on each contact and I also have a company table with details on each company - all companies attached to a contact are in the company table plus a few others. I'd like to be able to pull up a company profile and see all the contacts we have associated with that company displayed in a list.

View 1 Replies View Related

Update Or CancelUpdate Without AddNew Or Edit

Jun 7, 2005

I have a form from a query.
In this form i have a Combo Box and a Text Box.

What i want to do is select a value from in the Combo Box and get the corresponding value in the Text Box

(Combo Box) (Text Box)
BillNumber CustomerName

I have tried to put an Event Procedure on the AfterUpdate (or OnChange) of the Combo Box, and i wrote in it:

Private Sub COFNumber_Change()
' Find the record that matches the control.
Dim rs As Object
If Me![BillNumber] <> Null And Me![BillNumber] <> " " Then:
Set rs = Me.Recordset.Clone:
rs.FindFirst "[Bill Table_CustomerName] = '" & Me![BillNumber] & "'":
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

I try the form, and i get the following message:

"Update or CancelUpdate without AddNew or Edit"

I dont know what this means, and i dont know how to get it working.
Anyone has an idea?

Thanks in advance.

View 6 Replies View Related

Disable Input Controls Until Edit/update

Jul 27, 2006

Hi all,

I have a form that displays fields from two tables. I have set the properties of Allow Edit, Allow Additions, Allow Update, Data Entry to NO. However I want to allow users to be able to add new, edit/update and delete records from the form by clicking on respective command buttons.

the problem is that the code that I am using is giving me errors that says that I "You cannot go to the specified field" I need help on proper VB code to use that will allow me to enable input and update on the records in the table.

Private Sub cmdAdd_Click()

Me.Location_ID.Locked = False
Me.Location_Parent.Locked = False
Me.Zone.Locked = False
Me.Description.Locked = False
Me.Child12.Locked = False

DoCmd.GoToRecord , , acNewRec

End Sub

Dont know if that makes any sense, but I want to add a new record and i get errors

Neeeeeed some help ASAP....

View 5 Replies View Related

Forms :: OLE Server Error From List Box Update

Jun 2, 2014

I have a form which uses a list box to select which record to display. The code is all generated by Access during form design. It is a method I have used numerous times inthe past in various database without problem (even in the current database I am developing).But for some reason on this one form I get the following error;-

"The expression After Update you entered as the property setting produced the ollowing error; A problem occurred while database was communication with OLE Server or Active X Control".

View 2 Replies View Related

Wierd Prob: Cannot Update SQL Server Text-fields For Some Records, But Can For Others

Feb 22, 2005


I have a very strange problem:

I have a table linked to an SQL Server table in my MS Access 2000 Application containing 5 text-fields (SQL Server Type, in Access seen as MEMO-fields) and several other fields (in total about 140 fields). Updating any field works fine except for some records. In those records I can only edit the non-text-fields in my application. When I try to edit one of the text-fields I get a error message telling me that another user has edited the record and i have to discard my changes.

The strange thing is that this problem only crops up for some records. (1 in a 100 or so) All other records work fine.

Does anyone know what happens here? And how this can be fixed?


View 3 Replies View Related

Edit Database From Web Browser

Feb 8, 2006

I would like to edit a MS Database structure from a Web Browser using ASP. What I mean is I would like to be able to add more columns to a database table or delete or rename...Not the data that is already in the columns... Is this possible? If so can some one please point me in the right direction. I've searched these forums and have not been able to find the answer.

View 2 Replies View Related

Edit Reports While Others Are In Database

Sep 15, 2011

I am used to old Access 97 where I could edit a report while others are in it. I created an Access 2007 db and it does not let me edit unless I have exclusive rights to the file. Is there a way to turn that functionality on?(editing reports/queries/ while others are in the database. ?

View 6 Replies View Related

Moving Database To Another Server

Dec 3, 2006


I have created a few split multiuser databases in Access 97 that my company has used over the past few years. Currently, we are trying to move everything to a new network server. When I did a simple copy and paste on Friday moving everything to the other server it seemed to work fine. Until I tried to open any of the databases. I kept getting the message that they all were read only.

Do I need to bring the database back together before transferring it? I also plan on converting the databases to Access 2003. What precautions should I take in doing this?

Thanks for any and all information you can pass along.


View 1 Replies View Related

Split Database W/be On A Server

Nov 20, 2007


I am new to split database format... If I put the backend on say windows server 2000 or 2003 in a folder, is there anything else I need to do? Any setting on the server?? Or do I need a specific type of server os ie sql server etc?


View 14 Replies View Related

Sharing A Database Without A Server

Jun 12, 2012

At work a few of us all need to access the database to edit/update etc and at the moment only one of us can use it at once.We are getting a server in the near future so we will all be able to access it at the same time but I was wondering if there is an alternative way to do this in the meantime? I have been looking at "shared folders" but am unsure if they are suitable or how they work.

View 4 Replies View Related

When Opening A Database I Can Only View & Edit The Form...

Jul 9, 2007


When I attempt to open any of my Access databases I am presented only with the form that has been selected as the 'startup' option. Furthermore, it seems to be impossible to switch to 'design' view and my only options on the toolbar are File, Edit, Insert, Records, Windows, Help. As far as I can tell, none of these enable me to select the options required to give me my entire database back.

I am something of an Access novice, so if the above problem seems familiar to anyone i'd be grateful for the solution! The help option within MS Access hasn't been particularly useful.

Many thanks,


View 3 Replies View Related

Remote Access To Database On Server

Sep 23, 2005

I have an Access database on my server. My client does not like the idea of having to download the db, make changes, then upload it back. In the past, he has dealt with SQL databases, where you can create an access data project, that will give you a desktop shortcut straight to the database. I was wondering if there was any way to do something similar with an Access database. There is FTP setup for the site and all required permissions are setup. Is there any way to create a desktop shortcut, so he can edit the database in real-time, without having to download and upload? Thanks for any help.

View 3 Replies View Related

Placing An Access Database On The Web/server

Jul 17, 2006

I have a database with a couple of search forms to use for my company. My boss wants me to place this on the intranet so anyone can use it not only those with MS Access, which many people do not have on their computers. Please let me know if there is a way to do this and still make it interactive by means of searching. Thanks


View 1 Replies View Related

Split Database Back End On FTP Or Web Server

Jul 12, 2007

Hi, I am not sure where to put this thread hopefully someone here can help me.

I have spent a good deal of time developing a very effective access database for a client. It is split into a front end and back end and connected using the Linked Table Manager when necessary.

The front end is quite loaded with queries, reports, forms, macros etc and the back end simply has the tables.

The front end is about 15 mb and the back about 8 mb.

Current set up is a small workgroup network with about 4 -5 consecutive users at any one given time.

I am looking for some advice on how to set up or facilitate getting the backend on the internet so anyone with a front end can access it outside of the LAN.

Today I set up an account with WebDrive which can connect to and assign a drive letter on your pc to any FTP, HTTP site.

I made the connection with WebDrive and using the linked table manager successfully linked the tables on my local machine to the back end on the FTP server - and actually ran the database at a pretty good rate.

I noticed however that it was downloading the backend to my local pc and once I closed the (a) form it was uploading the data back to the server? Very slow and often threw errors.

This of course is not what I wanted. Has anyone heard of doing this? Any work arounds or setting params would be greatly appreciated.

I have been told to create the DB in ASP but I do not have any idea on how to do that whatsoever...

Any advice or insight would be awesome!


Fen How

View 1 Replies View Related

Server Dumped...Database Locked...What To Do?

Feb 8, 2007

I log into my server via remote connection from 3000 miles away. My database resides there.

If for what ever reason, I dump locally - the server does not recognize that I dumped - and thus keeps me logged in.

When I log back in, it logs me in as a second instance.

Here is the problem:

I was in access changing a form when I was dumped. (power went out). Now the server thinks I am still connected working on it. How do I shut down the service that has the DB locked - and delete the record-locking file that resides in the directory beside the database. (this record-locking file is the file that access creates whenever you start editing your database forms..etc...). I can't just delete that file - as access tells the server that it is still in use.

I am almost sure a reboot would rectify this issue - is there ANOTHER way to do this? (what is the service that is running that can be forced down?)

Thanks in advance,

Belchlord - way down South.

View 1 Replies View Related

Copyrights 2005-15, All rights reserved