Data Saved After Links Lost

[TomHW]

One of the users on my system ran into a problem where she was disconnected from the network while working in the database and yet Access allowed her to continuously enter new information.

The system is set up with a back-end on a server with a front-end that is copied to any machine it is used on. It is not replicated.

There is no problem in that after she quit and started up again the information was not still there, meaning that she was not seeing information that no one else would, but there was a problem in that if she hadn't noticed that her connection to the network had been severed she may have never noticed that the information was not entered.

Can anyone tell me why access would allow connecting to tables and saving to those tables even though the link no longer exists? All data entry pages are unbound. Access creates a connection to load default values and then again when the user attempts to save the record.

Thanks,

Tom

 

[Trendsetter]

The only time that the connection would be tested would be when the code to save was triggered - with unbound forms the data input is stored in memory until the code sends it back to the server. Depending upon the type of form and the data being inputted, it is possible that this could go on for quite some time.

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[TomHW]

My unbound form collects all of the information every time the user clicks "Save," opens a connection to the database, and stores the information before clearing the fields and allowing another entry.

I can't figure out how this is occuring when there is no connection to the database. Especially since the user is able to leave the form, open another form which displays all entries, and see all of the recent entries they just added (which means the form had to query the database and those new entries had to be there).

All connections are opened only long enough to save the data and then are explicitly closed.