Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / December 2003

Tip: Looking for answers? Try searching our database.

Records not being saved

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kelly - 30 Dec 2003 19:11 GMT
Are there any circumstances under which data that is
entered manually into a table is not saved? I have a
power user that spent serveral hours entering data into a
table. She opened the database the next day, and all the
information she entered was gone. The "Date Modified" on
the MDB file was an old one, before the day all the data
was entered.

I checked the obvious, whether it was entered into the
wrong database, or wrong table. I don't think the
database was overwritten. The user didn't notice anything
out of the ordinary, no error messages.

I haven't been able to duplicate the problem, and I have
since "Compacted and Repaired" the database.

Can a database get corrupted such that the data entered
is not saved, and no error message is displayed?
Allen Browne - 31 Dec 2003 03:17 GMT
If the date of the MDB file was an old one, she has either opened a
different copy of the database (e.g. opening it from another folder or
drive), or else her network administrator has restored an old copy.

Access always changes the file date whenever you open the file - even if you
don't make any changes.

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Are there any circumstances under which data that is
> entered manually into a table is not saved? I have a
[quoted text clipped - 14 lines]
> Can a database get corrupted such that the data entered
> is not saved, and no error message is displayed?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.