Software

Ask something
Discussion Locked

Access 2000 (3027) unable to update

0 helpful
4 replies

by inquisitive

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

When attempting to transfer data into a table using Visual Basic Transfer. We can delete the contents of the table from within the VBA Script. When we get to the Transfer command we get the 3027 error. can't update. database or object is read only.We used to be able to perform this import from 4 different PC's. We are now down to only 1 PC, an NT workstation that is able to perform this function. It doesn't matter who is logged in. We are running a NT network, database is on Server.
We can access the database table and enter data into the table manually but not through Visual Basic. Any clues!!??

4 replies

by otl

Sounds like only the NT workstation has admin ADD capabilities for that table, this is set within Access -> tools -> security -> users and group permissions and set on a file by file basis.

by inquisitive

Sorry for the delay, but that was the first thing i tried. but thank you for you attempt to help.

This discussion is closed to new replies.