Linking To Tables on SQL Server

[Guest]

I am using ODBC to link to tables on an SQL server. I am not able to link to
all tables - I receive an "invalid argument" error message. The tables I am
able to link to show "#deleted" in each field. I tried using "Alt F9 to
refresh the data, but this did not work. The only way I can see the data is
to import the tables. However, one table alone has over 2 million records!!
Is there another application other than Access I should be using to access
this data?

 

[Rick Brandt]

I am using ODBC to link to tables on an SQL server. I am not able to
link to all tables - I receive an "invalid argument" error message.
The tables I am able to link to show "#deleted" in each field. I
tried using "Alt F9 to refresh the data, but this did not work. The
only way I can see the data is to import the tables. However, one
table alone has over 2 million records!! Is there another application
other than Access I should be using to access this data?

The #Deleted usually means that the primary keys on the server consist of
DataTypes that Access doesn't have native equivelants for. BigInt for
example will do this. Sometimes adding a Timestamp field to the server
table will solve that. (sometimes not).

The invalid argument could be caused by field names that are legal in SQL
Server, but which are not legal in Access. Those containing a DOT for
example.

Try creating passthrough queries for those tables instead of linked tables.
Those will be read only, but they usually tolerate such things better than
links do.

 

[IRS Intern]

CORRECTION!

Use Access Data Projects and you won't have to put up with this crap

MDB is dead and it has been for a decade

 

[IRS Intern]

And Rick-- if you're going to be helpful; be frank

DO NOT USE WIERD CHARACTERS IN FIELD NAMES OR TABLE NAMES, KID