Dim tDef As tabledef

  • Thread starter Thread starter Jim Bunton
  • Start date Start date
J

Jim Bunton

Dim tDef As tabledef
gives error on compile "User-Defined Type not Defined"

but this type is included in the help files

Why is this please
 
TableDef is an object in the DAO library. ACCESS 2000 and 2002 do not have a
reference set to this library by default; ACCESS 97 and 2003 do.

While in VBE, click Tools | References -- set a reference to the DAO
library.

Then, I recommend you fully qualify the reference in your Dim statement just
so that it's clear:

Dim tDef As DAO.TableDef
 
Hi,

Put the reference in your project to MS DAO (or ADO) object.

Regards,

Nikolay
 
Thanks Ken works fine

Jim B

Ken Snell said:
TableDef is an object in the DAO library. ACCESS 2000 and 2002 do not have a
reference set to this library by default; ACCESS 97 and 2003 do.

While in VBE, click Tools | References -- set a reference to the DAO
library.

Then, I recommend you fully qualify the reference in your Dim statement just
so that it's clear:

Dim tDef As DAO.TableDef
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dim tDef as tabledef 1
Linking from code 3
Create linked table in unsecured mdb with secured mdb. 1
Setting Up DAO connection to Excel 97 speedsheet 7
problem attaching ODBC tables with Oracle 9 driver 2
modify field type of existing field in table 1
Programmatically Adding Counter Field to Table Using DAO 1
Update value of a field 2

Back
Top