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

[Mike]

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

 

[John Vinson]

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

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]

 

[Nick Coe \(UK\)]

Further to John's answer it would be a good idea to also
disambiguate your Dim statement thus:-

Dim db as DAO.Database

And any recordsets you declare also using the DAO library:-

Dim rst as DAO.Recordset

--
Nick Coe (UK)
http://www.alphacos.co.uk/ AccHelp + pAnimal
http://www.pjandcoe.co.uk/ Online Store
http://www.mrcomputersltd.com/ Repairs Upgrades

In Mike typed:

 

[Mike]

Thanks, John
It worked, I appreciate the help.............Mike

 

[Mike]

Thanks, Nick!
Both of the posts together seems to have cured the ills with it..........Mike