I recently updated to Access 2013 from Access 2007.On the FE Database I have a main form (Customers) with a subform (Customer Contacts). The forms are linked by the parent/child association via the ID number on the Customer form.
As I input work through the Customers all the contacts change just like they are supposed to… except I have one or two records that for some reason do not work. When I go to customer 270 I am getting all the customer contacts for customer 270, but when I go to customer 331 I get the contacts for 3482. When I go to customer 3482 the contacts for 3482 show up.
When I go to contact 330 and go forward one record to 331 (which is the problem record) I get this message. “Cannot open database”. It may not be a database that your application recogonizes, or the file may be corrupt.
I did a compact repair on the front end and that did not change anything. I tried a back up older database and that did not change anything. I am guessing it is in the back end. The back up and repair did change anything except I got a lot of records with ########### in them. I do not know what that means.
Any thoughts on why I would have problems with just one record (Customer with ID number 331)?
Any thoughts on what I should do?
Could this be caused by a person editing a record and then going home at night before the record is saved?
Thanks,
Bill
MN
Posted by: "Bill Singer" <Bill.Singer@at-group.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar