MDB read-only

[Frink]

Hallo,

I'm a bit stuck here. I have an mdb file which I have recently converted to Access 2000 format (from Access 2.0!), using Access 2003.
The problem is that I can't edit the data in the forms.
It's on my C drive, with Everyone having full permissions on the file and it's parent folder.
The file is not Read-Only, and the forms have allow edits, and it's a Dynaset recordset. The tables are all within the mdb. What can the problem be?

Sometimes it gives a warning that the db is read-only on startup, sometimes it doesn't.
Sometimes it gives an error on GoToRecord <new>, other times it doesn't, but always I can't edit the data in the form.
I can write to the underlying query, and create new records in table view.

Am I going mad?


- Frink

 

[Zion7]

Not sure but,
From tools => options, how is the Dbase recording locking?
Is it in shared or exclusive mode?

 

[Frink]

Hallo,

Cheers for that. It's Shared, and everything else on that page looks ok.
I am ashamed to say that I have found some code which sets up locking according to username. D'Oh!

Not sure that it explains all the problems, but I can work on it now,

- Frink