Security Problem in Access

[braemoor]

I have an MS Access problem which I am hoping someone can help me with.

I have developed an application using MS Access which includes some table house-keeping functions, and distributed this onto a network running Windows XP. The database is held on a data server machine. The database needs to run from two terminals. The users are logged on automatically when their machines boot up.

No matter which machine I distribute the application from, one particular machine always reports an error when I try to add a customer from a form:

The command or action "Save Record" isn't available now

There are no problems with the other forms.

The machine does have write access to the table (we've tried). The form in question accesses the table directly rather than a query. Only one user is using the database.

I have not implemented any security within the database.

Any suggestions?

John

 

[wardster]

Hi - does your application have a Front End / Back End structure?
could it be the default record locking setting on the problematic machine?

just a few thoughts

Ian

 

[braemoor]

Nothing so sophisticated! Thanks for your suggestions, though.

I have discovered that the "good" machine is running MS 2002, and the one with the problem is running MS 2000, so I'm going to investigate that angle.

 

[The_Doc_Man]

The issue might be a missing reference. It is hard to say for sure.

The error message indicates that you have a form trying to save to a record that is write-locked / open for update OR that it is a record that cannot be updated because the underlying recordset is not updatable.

This very well could be an issue with your registry settings, though you say you have not implemented security.

When the problem is isolated to a single machine and the DB is not being shared, you are probably running into a pesky little version change between two versions of .DLL file between AC2k and AC2k2.