 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / February 2006data missing
The staff use MS Access 2000 and XP Home edition The databases are shared over a Windows 2003 server. Each database is from 6 to 11 MBs. Just in the last several months a strange thing is happing. Staff will enter a date in a date field and several days later they notice the date is gone. They might enter a date on several records and a couple of days later all dates they entered on that day are gone. Any ideas ???????????? In order of likelihood from past experience. 1. They never actually put the data in there in the first place. 2. Someone deleted or changed the data. 3. The data is there but can't be found by the forms, reports, and queries as they are now written. 4. The database is written badly with something like unbound forms not saving the data. 5. Users are working in different database files. 6. Actual database corruption; however, you should be seeing other problems. 7. Someone is replacing the database from backup files.  SignatureJerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. > The staff use MS Access 2000 and XP Home edition > The databases are shared over a Windows 2003 server. [quoted text clipped - 4 lines] > and a couple of days later all dates they entered on that day are gone. > Any ideas ???????????? thanks for you help > In order of likelihood from past experience. > [quoted text clipped - 23 lines] >> and a couple of days later all dates they entered on that day are gone. >> Any ideas ???????????? Hello You say >Each database is from 6 to 11 MBs. If you have many databases I suspect there is confusion and your users are inputting to different databases to each other and possible opening different databases each time. So data looks like its missing but is infact on another database. Question Can you simplify things by just having one system consisting of a single back end database storing ALL data and individual front ends on each users machine. This is the standard approach for multiuser systems Ian www.iddsoftware.co.uk > The staff use MS Access 2000 and XP Home edition > The databases are shared over a Windows 2003 server. [quoted text clipped - 4 lines] > and a couple of days later all dates they entered on that day are gone. > Any ideas ???????????? Yes awhile back I had one back end and the front end on the individual computers. But now we have several offices so I had to put them together. We have been using the MS Access 2000 for several years and never had that problem. The only thing that has changed is several of our staff now use Dell XP Home Edition computers and I set them up as limited users. > Hello > You say [quoted text clipped - 23 lines] >> and a couple of days later all dates they entered on that day are gone. >> Any ideas ???????????? > Yes awhile back I had one back end and the front end on the individual > computers. > But now we have several offices so I had to put them together. Do you now only have one database that all users are using? If so the other thing that could be causing problems may be the system dates on each computer. Access uses the system date as the current date so if there are any calculations using dates etc this could be creating invalid dates which may result in them not being stored. Check the system dates to make sure they are set to the current date and time > We have been using the MS Access 2000 for several years and never had that > problem. Then it must have resulted from a change you made to your database(s) recently. Retrace your steps undoing each one, one at a time until the problem goes away. You should then be able to work out what caused it. > The only thing that has changed is several of our staff now use Dell XP Home > Edition computers and I set them up as limited users. temporarily disconnect them and put in the old pcs if possible to see if the problem goes away. If it does then you can be certain that the XP home edition is the problem (or the hardware - but i cant see how). You will then have to investigate further to see if others have had similar problems with this combination (I havent heard of anything myself) Ian > > Hello > > You say [quoted text clipped - 23 lines] > >> and a couple of days later all dates they entered on that day are gone. > >> Any ideas ???????????? Thank Ian >> Yes awhile back I had one back end and the front end on the individual >> computers. [quoted text clipped - 66 lines] >> >> gone. >> >> Any ideas ???????????? |
Reply to this Message |
 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.