Re: 3197 record deleted error

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
Date: Fri, 28 Oct 2005 08:06:25 -0600

Make sure you have a primary key or unique identifier
defined for your tables you are linking. Make sure the
primary key or unique identifier is not an approximate data
type (e.g. float). Try putting on timestamp data type column
on the tables you are linking.

-Sue

On 28 Oct 2005 00:25:17 -0700, "merco"
<d.mercanti@xxxxxxxxx> wrote:

>well, if i use only mdb tables this error doesn't occour.
>So i suppose it's an odbc problem

.

References:
- 3197 record deleted error
  - From: merco
- Re: 3197 record deleted error
  - From: Sue Hoegemeier
- Re: 3197 record deleted error
  - From: merco

Prev by Date: Re: 3197 record deleted error
Next by Date: Re: Windows 2003 System DSN not found (but User DSN works)
Previous by thread: Re: 3197 record deleted error
Next by thread: Re: Windows 2003 System DSN not found (but User DSN works)
Index(es):
- Date
- Thread

Relevant Pages

Re: many to many problem
... DivisionID completes the compound primary key and acts as ... a single division of a single company -or- multiple divisions of a single ... > l beginning with Starting Out and Database Design 101. ... tblLinkCompanyContacts is a ManyToMany linking table Can I create ...
(microsoft.public.access.tablesdbdesign)
Re: many to many problem: John Vinson and Lynn Trapp - help?
... DivisionID completes the compound primary key and acts as ... > a single division of a single company -or- multiple divisions of a single ... >> l beginning with Starting Out and Database Design 101. ... > tblLinkCompanyContacts is a ManyToMany linking table Can I create ...
(microsoft.public.access.tablesdbdesign)
Re: DB structure question
... > Don't forget to set the primary key. ... unique_ID_book (linked to primary key in books table) ... and each is assigned a unique identifier, ... then I insert into the reviews table, the unique identifier for the user, ...
(microsoft.public.inetserver.asp.db)
Re: Many to Many Relationships
... >> linking tables work with the combined primary codes. ... >tblJobs, would have JID (primary key), JName, etc, etc. ... >> up with Quotes and Jobs. ...
(microsoft.public.access.tablesdbdesign)
Re: Primary key ContactID not migrating to subforms
... > question about linking tables. ... > consists only of the two FK fields, ... always use a single-field Autonumber primary key in every table. ... > missing a linking table between the Estimate and the Materials tables. ...
(microsoft.public.access.tablesdbdesign)