Prefix dbo_

[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.

 

[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.

 

[Sergio]

Thanx Ken, it worked!

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