Linked Tables in MSaccess via ODBC - SQL server

D

Dirk Fastré

Hi,

I'm running Access2002 under WindowsXP and have an
application with linked tables to an SQL server. The
application was converted out of Access97 without any
problems, whereby the linked tables in Access2002 can be
opened. However, when linking a new table out of the same
SQL database, I get the following error:

"Some strange characters and then the text: is not a
valid name. Make sure that it does not include invalid
characters or punctuation and that it is not too long. "

Ofcourse the SQL tables do appear as dbo.tblTest.

If I use Access97, I can link to this table without any
problem. Via the standard conversion, I can save a test
file in Access2002 with the linked table. HOWEVER, I
cannot import this table in my application.

Any help is more than welcome ...
Thanks
Dirk
 
J

Joe Fallon

Need more specific info.
What is the name of the table?
What are your exact linking steps?
Do you have an ODBC DSN?
Which driver are you using?
 

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

Why won't Access assign a Primary Key ID to my linked SQL Table? 2
replacing a link to a SQL Server table with VBA 0
query links to SQL server and mdb table 1
Linked SQL Tables don't report Cascading Updates and Deletes 2
Migration to SQL Server 3
linking to SQL Server db table 6
Re-Seed in SQL Server 11
Use of Linked tables via ODBC to SQL server over wi-fi 3

Top