How do I "Dim db As Database" using a Access App linked to SQL db

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

Guest

I'm trying to build an unbound MSAccess form to append records to a linked
SQL data table. when I try to set/define the variable using "Dim db As
Database" I get type not found error when I compile the code. Any clues for
me.......TKS....mw
 
I'm trying to build an unbound MSAccess form to append records to a linked
SQL data table. when I try to set/define the variable using "Dim db As
Database" I get type not found error when I compile the code. Any clues for
me.......TKS....mw
Click to expand...

In the VBA editor, select Tools... References. Make sure that
Microsoft DAO x.xx Object Library (highest version) is checked. With
A2000, VBA defaults to selecting the ActiveX Data Objects (ADOX)
library instead.

John W. Vinson[MVP]
 
Thanks, Nick!
Both of the posts together seems to have cured the ills with it..........Mike
 
Back
Top