ACCESS FEED: Re: [MS_AccessPros] Database error

Rabu, 16 Juli 2014

Re: [MS_AccessPros] Database error

Bill-

It sounds like the index for ConCusID is corrupted. In the back end, copy the table to the clipboard and paste as a new table. See if the new table has the same problem. If not, then delete the old table and rename the new one. You'll probably also have to rebuild any relationships.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Jul 16, 2014, at 12:56 PM, 'Bill Singer' Bill.Singer@at-group.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

More information on this error. My customer contact table had 3700 records.

When I sort the table by the ID number it still shows 3700 records. When I sort by name I get 3700 records. When I sort by the "ConCusID" which is the child field that connects to the CustomeID number in the customer table the sort only shows 320 records. I scroll down and only 320 show. When I change my sort, I get back to 3700. When I try to filter my contact records for any contacts for Customer ID 331, I get that same database error listed below.

It does not help either when I bang my head against the desk.

Any thought on reasons or fixes?

Thanks,

Bill

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, July 16, 2014 11:35 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Database error

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

__._,_.___

Posted by: John Viescas <johnv@msn.com>

Reply via web post

•

Reply to sender

•

Reply to group