If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
unable to enter data in Access 2007 database on network
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 -- pete leblanc |
#2
|
|||
|
|||
unable to enter data in Access 2007 database on network
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" wrote: 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 -- pete leblanc |
#3
|
|||
|
|||
unable to enter data in Access 2007 database on network
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 "Jacqueline" wrote: 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" wrote: 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 -- pete leblanc |
Thread Tools | |
Display Modes | |
|
|