unable to enter data in Access 2007 database on network

  • Thread starter Thread starter petelb
  • Start date Start date
P

petelb

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 2007 will allow you to split the database. What this does is keeps the
tables (or back end) on the server and you place the front end on your
desktop. This will allow multipal users at the same time.

The best thing for you to do is type in Split a Database in the help search
box. This will give you all the detail. Follow the directions carfully,
including making a backup copy of your database (very important in case
something goes wrong)

Hope this helps your problem.
Jacqueline
 
petelb,

Jacqueline, is quite correct about the idea of splitting a database,
especialy where there are going to be multiple users. However, this may be a
problem where you need to make a change in the way your database is being
opened by Access. Check your setting by clicking on the big round button and
look for the Access Options. I do not have 2007 available at the moment but
there is an option for then "default open mode". Make sure this is set to
"Shared". If it is set to "Exclusive" then that has been your problem.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm
 
Back
Top