Myke Myers
mmmtbig at bellsouth.net
Wed Nov 5 16:05:41 CST 2003
Charlotte No, users can't get to anything but forms and reports. But there are some guys in the IT dept who may have enough knowledge to be dangerous. I'll look into the vbe6.dll / Access 2002 issue. Thanks, Myke The Better Information Group -----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:48 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Primary Keys GONE! Are your users allowed access to the tables themselves? The only time I've seen anything like that was as part of the weirdness that goes with the vbe6.dll problem when a 2002 app is installed on the machine running O2k and O2k is less than SR-3. Charlotte Foust -----Original Message----- From: Myke Myers [mailto:mmmtbig at bellsouth.net] Sent: Wednesday, November 05, 2003 1:28 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Primary Keys GONE! 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 _______________________________________________ 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