problem when linking an Access DB to SQL Server with bigint dataty

  • Thread starter Thread starter jurgm
  • Start date Start date
J

jurgm

I want to create an Access FE for some PowerUsers that need to run ad-hop
queries against a SQL Server DB. However due to the fact that some tables in
SQL Server use a bigint datatype on their primary key field, all tables that
have a bigint field show #Deleted in all fields for all records, however
recordcount is accurate for all tables.
Is there a way for Access to display tables with a bigint datatype field?
 
jurgm said:
I want to create an Access FE for some PowerUsers that need to run
ad-hop queries against a SQL Server DB. However due to the fact that
some tables in SQL Server use a bigint datatype on their primary key
field, all tables that have a bigint field show #Deleted in all
fields for all records, however recordcount is accurate for all
tables.
Is there a way for Access to display tables with a bigint datatype
field?

1) Use passthrough queries instead of table links (not so good for ad-hoc
querying)

2) Create a view on the server that casts the BigInt to a string or some
other type that Access gets along with better. Use the view for your link
instead of the table.
 
Thanks for your response Rick. I thought it would be something like this, but
the DB is a third party product, and we're not supposed to create additional
Objects in there.
I might create an additional DB as a layer between the Source DB and the
Endusers and create the necessary views in there.
 
Back
Top