ADO connection

  • Thread starter Thread starter Atif
  • Start date Start date
A

Atif

why i am receiving this error "user defined type-notdefined" on "Dim cn As
ADODB.Connection".

i am using access 2007
 
Atif said:
why i am receiving this error "user defined type-notdefined" on "Dim cn As
ADODB.Connection".

i am using access 2007
Click to expand...


Check your references and make sure you have a reference set to Microsoft
ActiveX Data Objects 2.x Library.
 
To go with what Dirk said, Access 2007 has DAO set as the default now and not
ADO, so if you want to use ADO code you will need to set the reference for
each new database you create in 2007. Just something to remember.
--
Bob Larson
Access World Forums Administrator

Tutorials at http://www.btabdevelopment.com

__________________________________
 

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

ADO Access For Value List Error 4
Error 3029 When Trying to Create Workspace 1
ADO connection problem 9
Can't Update Database 4
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Dynamic ADO Field Names 2
ADO - Retrieve record with InStr criteria 4
Exporting from Excel to Access 2

Back
Top