hi,
The FE is preserved, because it's an mde file, instead of a usual mdb.
I used to have the record locking checked and still didn't worked.
Someone in the Microsoft access forum, suggested that I have it unchecked.
The form that we use to input data, comes from a query that is "updatable" and the query is consisted of tables.
Do you suggest to make the form to be able to add only and not edit any record?
When the mde (FE) file opens, a hidden dummy form also opens in order to have a consistent connection to the BE. And yes the form is locked and hidden.
Main Topics
Browse All Topics





by: LPurvisPosted on 2005-10-25 at 15:42:54ID: 15158651
Have you also confirmed that these settings are preserved when the FE comes over to the users machines?
Why don't you want record level locking set on?
That's a good thing :-)
Have you tried limiting the recordset you form a persistant connection to the database with?
Rather than a full table - try a query (a form based on that query) that returns one record.
And make that recordset read only too - for the hell of it?
;-)
Not saying this will magically fix your setup - but it can't hurt.