DSN

E

Ezekiël

Hello,

Could somebody tell me where i should use the ado connection? Should i put
it in each form or do i need a module to use it.

I really need a good explaination on this.
 
M

Michel Walsh

Hi,


You don't need to do anything with it. Access opens one for you,
CurrentProject.Connection, use it if it is required for you to use it.


Hoping it may help,
Vanderghast, Access MVP
 
E

Ezekiël

And in a mdb file?

Michel Walsh said:
Hi,


You don't need to do anything with it. Access opens one for you,
CurrentProject.Connection, use it if it is required for you to use it.


Hoping it may help,
Vanderghast, Access MVP
Click to expand...
 
M

Michel Walsh

Hi,

Same thing, if you use Access 2000 or later. CurrentProject.Connection
is available, for ADO, in addition to CurrentDb (for DAO). Forms are based
on DAO, for a mdb, and the default recordset open, with the form, is
Me.RecordsetClone, a DAO recordset, so you generally have no need for an ADO
connection at that stage.


Hoping it may help,
Vanderghast, Access MVP
 

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

MS Exchange PTR 0
Resctricting editing rights, but allowing those who cant edit, to still copy the slides 0
Table Security in Access 2013 1
Setting a default zoom in Infopath 0
Can't send emails on new PC 1
A couple questions BEFORE using Office 365 0
Excel does not accept text format! 0
Incorporating the User Profile location into a document template path 1

Top