unable to enter data into Access 2007 database on network

[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

 

[Jeff Boyce]

Pete

Have the network gurus confirm that the PCs/users have read/write
permissions to the network folder in which the backend is stored.

But I'm a little confused ... do you have a split database? That is, a
"front-end" on your PC, pointing at (i.e., linked to) tables in another file
on your network?

If so, where does the "new db on a second PC" come into play? Are you
pointing at the network (i.e., the back-end) to link, or at the front-end on
your PC?

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Arvin Meyer [MVP]]

Make sure that the database is opened with shared permissions.

Also it is important that you split the database into a front-end with all
the code, running from each user's workstation, linked to a back-end running
on the server. Failure to do so, will create an atmosphere where corruption
may make your database totally unusuable.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access