ituser2008
MIS
I have a database with some forms that was created by former employee and i am experiencing a problem. Whenever someone closed the database abnormally, it will create a seperate database file in the directory for ex, db1, and if 2nd person doesn't close the database by clicking on the close command button, it will create db2 and etc.. I am not sure what are all those files, but it appeared it is duplicating the database. When I open the original database, some of the data that have been entered by other users got lost. I can't track where the records went. Everything is tied to an ID (auto number field), when user# 1 said he enter this informatin with ID 10, but if i looked up the record in the database for ID 10, it actually has somebody's else's name. It is a shared database and used by a group of people to input information into the database. With this problem happping, i don't even know how to fix this or prevent this from happening again or what caused this to happen. Does anybody know anthing?? Any help will be greatly appreciated.
thanks
thanks