SQL Server Linked Table

G

Guest

When I link to a SQL Server table in Access, the field format changes from
bigint in SQL Server to text in Access. I know that the number is to big to
be an integer in access. Is there a way to force the field to be linked as a
double?
 
J

Joe Fallon

You do not mention which versions of each program you are using.
There is probably an incompatibility due to one being created before the
other.
This may be fixed for newer versions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problem when linking an Access DB to SQL Server with bigint dataty 2
Append data to linked SQL Server 2008 table 0
Access stripping decimal places in query 1
Sql Server linked table and NULL bit fields 2
Conneting to SQL server, Need advice 3
Linked tables to SQL 1
When i write in a linked table does it overwrite in the source tab 1
Move Access Table to SQL Server 1

Top