networking Help!

[mapat]

hello,

how is it that I make a table "updatable". That's the error ACCESS 2007 gives me when running the runtime version (front end) on a computer. The program has to update the tables on the back end which are on a different computer (on the same network).

Also, I just saw a thread with some code included to open the database, and then to close it. Do I need any connection code in ACCESS for this case?

This is my configuration:

- Main Machine (which has an shared external hard drive E: where the back
end file resides)

- Other Machines (they contain the front end file which is supposed to be
linked to hard drive E on Main machine)

Everything is shared and the path to link the front and back ends is working well.

 

[GohDiamond]

A table is updateable by definition if you have permission to open the database and there is no other security measure that limits access to objects in that database. Have you established User-Level Security? if so then you will have to set permissions for users to allow them to edit the objects. If you haven't set User Level Security then everyone that opens a shared database will have ADMIN level permisison which will let them edit anything, unless the edit requires exclusive access (such as changing a form or a report).

First do the basics in the BE: Check your settings in the Tools menu Options... ADVANCED tab. Set Default open mode SHARED; Default record locking NO LOCKS; Open databases using record-level locking CHECKED;Enable DDE Refresh CHECKED;

Let us know what you find.

Goh

 

[Rabbie]

Do the FE machines all see Drive E on the BE machine as Drive E?. If not you will have to use linked table manager to set up the connections.

Also make sure that all users have read/write permission to Drive E

Its not just Access security, Windows security also has to let them have access to the BE database