I have a split database on my home computer that is accessed only by me. I'm using Access 2007 under Windows 10. The database was split because it had become too large (over 2GB). The forms and reports have been recompiled and the data compacted and repaired. Initially, following the split, everything appeared to be working as it should. At the current time, however, there are two problems that have appeared that I suspect are related but do not understand.
The database is semi-automatically updated when I import (on a daily basis) an Excel spreadsheet. Everything appears to be importing successfully. I then manually copy an image from the web and add it to the appropriate record. This process has worked for years, and did so even after the database was split. However, now, when I try to move off of the record after pasting the image I get the following error message: "Cannot open database. It may not be a database that your application recognizes or the file may be corrupt" If I delete the image from the record I can successfully move to the next record. I can change and/or add text to the other fields in the record with no trouble.
The other problem which I suspect is related occurs when I run one query in preparation for generating a report and I get the following error message: "The Microsoft Access database engine has stopped the process because you and another user are attempting to change the same record at the same time." As I said earlier, I'm the only person who has access. I have accessed the database remotely using Logmein on occasion.
Any help would be greatly appreciated.