derekburleigh
New member
- Local time
- Today, 17:12
- Joined
- May 16, 2011
- Messages
- 14
Hi All,
I have just done a compact and repair on my Access database. Afterwards one of the tables has lost a lot of data (but only one????).
Spookily the table now has exactly 20000 records in it, which makes me think this is some kind of limit, except that I don´t think there are table limits in Access and I have other tables in the database with more than this number of records that are still ok.
Questions:
Is there any way of recovering the data after a compact & repair?
Any ideas why the compact repair would have deleted these records? (It hasn´t happenned with previous compact repairs)
I don´t have a recent backup of the database, but that´s a different problem!!
I have just done a compact and repair on my Access database. Afterwards one of the tables has lost a lot of data (but only one????).
Spookily the table now has exactly 20000 records in it, which makes me think this is some kind of limit, except that I don´t think there are table limits in Access and I have other tables in the database with more than this number of records that are still ok.
Questions:
Is there any way of recovering the data after a compact & repair?
Any ideas why the compact repair would have deleted these records? (It hasn´t happenned with previous compact repairs)
I don´t have a recent backup of the database, but that´s a different problem!!