Usage of Bigint in SQLSERvER with ACCESS frontend

[Guest]

I have an Access frontend connected to a SQLServer2000 database. I can display the tables of this database except the tables that have a field of datatype bigint. All the records in this tabel show #deleted

Is there a way to solve this problem

Ronald van der Geest

 

[Duane Hookom]

Is the bigint field the primary key on the table? If so, you might see if
you can identify another field or fields that are unique so that you can use
a data definition query to create another "pseudo" primary/unique key on the
table.

--
Duane Hookom
MS Access MVP

I have an Access frontend connected to a SQLServer2000 database. I can

display the tables of this database except the tables that have a field of
datatype bigint. All the records in this tabel show #deleted.

 

[Guest]

hello Duane

I have found the problem it is described in the following article

ACC2000: Linked SQL Server Table That Uses BigInt Data Type as Primary Key
Displays #Deleted
http://support.microsoft.com/default.aspx?scid=kb;en-us;321901

Guess what the microsoft solution is: change the data type......

The sqlserver database is developed by a third party. We will contact them in order to see it's possible to change the tables

Thanks for your reply

Ronald van der Gees

 

[Duane Hookom]

That's how I generally solve the problem. I just thought there might be an
alternative with a datadefinition query.

--
Duane Hookom
MS Access MVP

hello Duane,

I have found the problem it is described in the following article:

ACC2000: Linked SQL Server Table That Uses BigInt Data Type as Primary Key
Displays #Deleted
http://support.microsoft.com/default.aspx?scid=kb;en-us;321901

Guess what the microsoft solution is: change the data type.......

The sqlserver database is developed by a third party. We will contact them

in order to see it's possible to change the tables.