SQL Server Linked Table

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
Back
Top