cssnc
asked on
Access 97 export data
Hi,
I have table with 108000 records (Visit Table) . When I try to export to any format listed as option I am getting this error message : " The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time".
I moved database locally on my computer and opened it as a single user and even as with "exclusive" access but with the same results. We can see the records and even "select query" will work but if I try to use "make table query " I am getting the same message and one other telling that records are deleted which is not true.
Interesting thing is that even old backups will behave on the same way and on different computers through the network or with old backups locally as single users. Everything started with the first day of the New Year 2014! I tried to convert it to Access 2003 but I got message that Visual Basic for Applications project in the database is corrupt.
I really need the data from database. Please help!
I have table with 108000 records (Visit Table) . When I try to export to any format listed as option I am getting this error message : " The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time".
I moved database locally on my computer and opened it as a single user and even as with "exclusive" access but with the same results. We can see the records and even "select query" will work but if I try to use "make table query " I am getting the same message and one other telling that records are deleted which is not true.
Interesting thing is that even old backups will behave on the same way and on different computers through the network or with old backups locally as single users. Everything started with the first day of the New Year 2014! I tried to convert it to Access 2003 but I got message that Visual Basic for Applications project in the database is corrupt.
I really need the data from database. Please help!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Alex Nolan makes some database utilities including MDBPlus.exe . http://www.alexnolan.net/software/mdb_viewer_plus.htm
ASKER
I attached dbf table and tried to append record from original corrupted table and got error message and "Paste errors" table which contained all records which were in original table!
Before that I tried append and make table queries without success but for some reason this method "accidentally " worked. Your suggestion of "linked table" worked!
Thank you.
Before that I tried append and make table queries without success but for some reason this method "accidentally " worked. Your suggestion of "linked table" worked!
Thank you.
We are here to help!
1) Try creating a blank Access DB.
2) Import all objects from the corrupt db into the new db using the File ---> Import option.
ET