Prefix dbo_

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You need to set a reference to the DAO library in your database file. Those
objects are members of the DAO library.
 
Back
Top