Problem using linked tables instead of ADP -- sql server msde

sql server msde : Problem using linked tables instead of ADP

Mark
5/24/2005 12:00:00 AM

Hi

I know I probably shouldn't be doing this but...

I have a table on an MSDE database that has a bigInt for the primary key. If
I try to link to this table from Access (XP) using an ODBC connection the
table links ok. The first time I opened the table it was ok. Since then the
primary key data type is interpretted as text and all the records (though
still there) have "#deleted" in each column of every row? I have tried
relinking the table and still get he same problem.

Any ideas whats going on?

Thanks in advance

Mark

Mark
5/25/2005 12:00:00 AM

Hi Monte

[quoted text, click to view]

As far as I know, yes? I wasn't prompted to select a primary key and looking
at the table design from within access shows the primary key present but as
text instead of number.

Cheers

Mark

Mark
5/25/2005 12:00:00 AM

[quoted text, click to view]

Monte

Scary stuff hey :o{

I'm not going to worry about it too much as I was just playing to see the
difference in performance etc. Would still be interested to know why, may
have another look later...

Cheers

Mark

Monte
5/25/2005 7:35:23 AM

Have you linked the table such that Access recognizes the primary key?

[quoted text, click to view]

Monte
5/25/2005 11:33:39 AM

I have also seen this problem occur when I have "bit" type fields in the SQL
table, and don't have a default value (say zero) and allow nulls checked.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server msde

home · blog · groups

Questions? Comments? Contact the dn