Prefix dbo_

S

Sergio

Hi there,

I need to link my tables from SQL Server to an Access mdb without the prefix
"dbo_".

I read a message posted by Joe Fallon. This message contains code for
delete all linked ODBC table names in an mdb (DeleteODBCTableNames) and for
re-create links to SQL Server (LinkSQLServerTables).

Excuse my ignorance, but when I adapt your code to an Access module, when I
compile, i get error messages telling me that the "Database", "TableDef",
TableDefs" datatypes are not defined.

Am I missing something? How do I define them?

Thanks in advance.
 
K

Ken Snell [MVP]

You need to set a reference to the DAO library in your database file. Those
objects are members of the DAO library.
 
Top