petelb said:
I have an Access 2007 database on one PC on a network.
If I open the database from a second PC on the network, it is made Read-Only
and I cannot enter or update data.
If I create a database on the second PC that has Linked Tables to the first
database, I get the error ‘Recordset not Updatable’ when I try to enter or
update.
I’m not sure if this is a network thing or an Access problem.
Any advice would be appreciated
Access manages (I want to use the word "access" here!) interaction with
its data files by one or more users by creating a "lock" file in the
folder which contains the main data file. So, if your database is
called mydata.mdb, you should see a file appear called mydata.ldb appear
when the database is opened. Multiple users cause Access to make
multiple changes within that lock file to track who's doing what.
First, you should make sure that the remote user has permission to
create a file in the relevant folder. Unless you're within an Active
Directory domain, that usually means matching usernames and passwords on
both machines, and appropriate permissions on the folder. Browse over
the network to that folder and see if you can create a new text file
there. No? There's your problem.
Secondly, multi-user interaction with Access databases only works
reliably and without significant risk of corruption if you have your
database "split". Look up Split in help, and use the simple wizard to
do just that. Learn about the "Linked Table Manager" at the same time,
so you'll know what to do if things get moved. In short, you have the
back-end (containing only tables) on one machine and front-end(s) (which
need not be identical) on other machines (can include the host of the
back-end).
I'd suggest creating a copy of the database to experiment with, then
creating a new database on the second machine. Link to just one table.
Can you add a record? The answer should point you in the right direction.
Phil, London
