MDE Question

[moemoe]

Hello,

Can someone please provide some sample code to access the underlying tables in an access database when writing code in say the FORM_LOAD sub? Is it just a matter of providing different connection parameters in the connection string?

Cheers

[Ecniv]

Hello,

Can someone please provide some sample code to access the underlying tables in an access database when writing code in say the FORM_LOAD sub? Is it just a matter of providing different connection parameters in the connection string?

Cheers

What has this got to do with MDE ?? Oh wait is that MS Development Environment? not MDE as in Access Executable database ??

Why would you need to have connection strings if you are in access? It has them already - currentProject.connection
Code would be something like:

Dim adoRS as ADODB.Recordset

adoRS.Open "Sql statement",currentproject.connection,3,3,1 '(dynamic, optimistic, adcmdtext)

if not adoRS.Eof then
'...
end if