setting a database variable

[karen scheu via AccessMonster.com]

I am trying to relink tables through code and I am getting the following
error:
user defined type not defined on the following lines

Private Function ReconnectTables() As Boolean
On Error Resume Next
Dim dbs As DAO.Database
Dim tdf As DAO.TableDef

Please advise. I am very new to access basic coding and am probably
missing something very basic. Please advise.

 

[David Lloyd]

Karen:

You may want to check the References under the Tools menu to see if you have
a reference to the DAO object library.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


in message I am trying to relink tables through code and I am getting the following
error:
user defined type not defined on the following lines

Private Function ReconnectTables() As Boolean
On Error Resume Next
Dim dbs As DAO.Database
Dim tdf As DAO.TableDef

Please advise. I am very new to access basic coding and am probably
missing something very basic. Please advise.

 

[karen scheu via AccessMonster.com]

Thanks for the response. I checked the references and I only had checked
the following:
Visual BAsic for Applications
Microsoft Access 11.0 Object Library

There are a lot of options listed. How do I know what references I will
need? At least I will check Microsoft DAO 3.6 Object Library, but how do I
determine what else may I need?

Thanks,
Karen