Re: Problems using MyODBC, Access2k on linked tables

[Patrick Sherrill]

Are you able to save the record every time you make a change to any field
but the return_url?

I use auto_increment and a timestamp in every table I create.  This ensures
a unique record everytime.

Pat...

----- Original Message -----
From: Boget, Chris <chris@stripped>
To: 'Patrick Sherrill' <patrick@stripped>; <myodbc@stripped>
Sent: Wednesday, March 08, 2000 11:20 AM
Subject: RE: Problems using MyODBC, Access2k on linked tables


> > Please ensure your table has a TIMESTAMP(14) and a unique key
> > in the schema.
> > This should correct the problem.
> > I hope this helps.
>
> Is this the only solution?  My table does have a unique key, and
> including a timestamp field for just me for just this problem is
> impractical for the database and for our usage.
> Also, I've done a bit of further testing and found that often, it
> is just one single field that is the cause of my problem.  Take this
> example:
>
> FieldName: menu_name
> Size: 50
> Indexed: Yes (Dupes ok)
> Required: Yes
> Allowed Zero Length: yes
>
> valid_users
> 255
> no
> yes
> yes
>
> return_url
> 255
> no
> yes
> yes
>
> menu_num
> {Long Integer}
> Yes (No Duplicates)
> yes
> DecimalPlaces: auto
>
> I can query in all the fields but 'return_url' and modify
> any of them.  As soon as I query in the 'return_url'
> field, I can't modify anything.
>
> Why is that?
>
> Chris
>