I am writting and hoping that someone can help, I've been getting invalid bookmark errors on an access 97 db running on nt4/sp6 for the past 2 weeks, A compact and repair will actually corrupt the whole database so it cant even be opened. The corrupted records would be one or two records from 1000 and they are showing their values as #Error. If i make the db work by going to backups and importing objects one by one then a few days later after 2 particular users have accessed the same record , we get the invalid bookmark error again. I have checked the db and there are no linked tables in it. I am using a delphi front end to access the information.
Any suggestions would be greatly appreciated