[AccessD] Linking Tables from MS SQL using ODBC

Jim Lawrence accessd at shaw.ca
Mon Dec 27 22:08:00 CST 2004


Hi All

Never having used an ODBC connection, to MS SQL, since pre 1997, I am having
some issues when linking the tables, to Access. The tables link OK but each
table is prefixed with the owner code, in this case DBO. Example table
'test' becomes 'dbo_test'. Is this normal? Did I miss some flag? 

Any help would be greatly appreciated as the prospect of manually renaming
250 odd tables does not excite.

MTIA
Jim 




More information about the AccessD mailing list