this recordset is not updatable

[Aaron]

Hello,

I've set up a very simple data entry database and have
split it front end/back end. I distributed runtimes to 3
other computers. However, when I open the forms on the
computers, it tells me the recordset is not updatable. I
feel like I have tried everything, and seems all
parameters are set up correctly. I have had this problem
for about a month now and have gotten nowhere. Are there
any folks possibly interested in taking a look if I were
to email a zip file? Also, it seems occasionally I get
an error "Could not lock file". not sure if the 2 go
hand in hand.

Thank you much,
Aaron

 

[John Vinson]

Hello,

I've set up a very simple data entry database and have
split it front end/back end. I distributed runtimes to 3
other computers. However, when I open the forms on the
computers, it tells me the recordset is not updatable. I
feel like I have tried everything, and seems all
parameters are set up correctly. I have had this problem
for about a month now and have gotten nowhere. Are there
any folks possibly interested in taking a look if I were
to email a zip file? Also, it seems occasionally I get
an error "Could not lock file". not sure if the 2 go
hand in hand.

Thank you much,
Aaron

A couple of things to check:

- Both .mdb files must be read/write (copying a file to CD marks it
read-only) and, more subtly, the user must have
read/write/create/delete privileges in the folder containing the
backend .mdb file.

- Doublecheck the JET versions on the machines that work and the
machines that don't. This may be a version incompatibility. Find
msjet40.dll (or the version you're using) in Windows\System or
Windows\System32 and check its version number - they should be the
same (up to date, in other words).