Myke Myers
mmmtbig at bellsouth.net
Wed Nov 5 15:27:40 CST 2003
The field no longer is designated as a primary key. (In design view the key icon beside the field name is gone.) Myke The Better Information Group 770 928-7276 mailto: mmm at tbig.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Wednesday, November 05, 2003 4:08 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Primary Keys GONE! Explain what you mean by "lost their primary key". Do you mean there is no longer an identified primary key or the primary key field is null or what? What are you seeing instead of what you expected? Charlotte Foust -----Original Message----- From: Myke Myers [mailto:mmmtbig at bellsouth.net] Sent: Wednesday, November 05, 2003 1:01 PM To: accessd at databaseadvisors.com Subject: [AccessD] Primary Keys GONE! One of my clients is corrupting an Access 2000 backend database about once a month. When I get the data file, I find several tables have lost their primary key. The primary key for each table is an autonumber long increment. Anyone have any suggestions? Myke The Better Information Group _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com