Dirty Form

[JimS]

My user (Access '97) in a multiuser front-end back-end linked-tables database
gets a message that a form has been modified and saved since he loaded (and
presumably must have changed) the form. It's a simple form. The only thing I
can see is that each user clicks on the A->Z sort button on entering the form
because until they do that, they have no data in the form (why?).

Can I lock the form so it can't be changed except the sort order, and then
can't be saved?

Remember, I'm not talking about the data, but the form itself...

Thanx!

 

[Albert D. Kallal]

do you distribute a mde to EACH COMPUTER??

Try using a mde for the front end. It is assumed that this mde is
placed/installed on each computer.

 

[JimS]

Sorry, I mis-spoke. Both the front end and the back end are mdb's. It uses
linked tables. The back end is tables only...the front end has NO tables,
only links. Both are on the same mapped (novell) drive.

 

[John Vinson]

Sorry, I mis-spoke. Both the front end and the back end are mdb's. It uses
linked tables. The back end is tables only...the front end has NO tables,
only links. Both are on the same mapped (novell) drive.

Albert is quite correct. Having all users share the same frontend is
EVEN WORSE than not splitting the database AT ALL.

Each user should have *their own separate copy* of the frontend
database (it can be on their own computer or it can be in a private
directory on the Novell server).

John W. Vinson[MVP]

 

[JimS]

Well, shiver me timbers. Now that I think it through, of course you're right.
Makes perfect sense. I'll implement that. Thanks.