ADO Local

[VBAhole22]

Is it possible to use ADO on a normal db that is running within Access? I know ADO is good for working with SQL Server data and I would like to use it more. I'm designing a db for a server but I don't have the server yet.
How can I open a connection on a local Access db?

 

[RichMorrison]

Yes you can use ADO on local/network Access databases.

But.....most folks just use the older DAO.

Go to some sites for Web developers and you will find lots of examples of ADO connection to MS Access data bases.

www.4guysfromrolla.com is a good start.

RichM

 

[VBAhole22]

Uh-huh

Thanks for the tip Rich. That site is pretty neat. They have lotsa examples for using ASP to connect to Access db's using ADO. But I'm still unclear as to how to just do it in access. I keep getting errors that my connection string is bogus. I guess I just assumed that since I was running the same db that I want to query I wouldn't have to add things like datasource and password?

 

[Travis]

In access 2K use the CurrentProject.Connection as your Connection.

Dim CNN as ADODB.CONNECTION
Set CNN=CurrentProject.Connection