CurrentProject.Connection is the connection string you
need.


Chris Nebinger


>-----Original Message-----
>i usually use ADO in my visual basic when i make a
program with a database in access. the problem now is:
>
>i am now programming in access without using VB that is
purely ACCESS. what connectionString should i used? im
gonna use it for my module.
>
>.
>

"Chris Nebinger" <(E-Mail Removed)> wrote in message
news:1e06a01c4547b$f337af80$(E-Mail Removed)
> CurrentProject.Connection is the connection string you
> need.

Unless I'm confused, CurrentProject.Connection actually returns the
Connection *object*, not the connection string itself. Usually, that's
what you want anyway. If you really want the connection string, you
would get CurrentProject.Connection.ConnectionString .

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

The default property of the Connection object is the
ConnectionString. So, I just use the
CurrentProject.Connection.

Debug.Print CurrentProject.Connection



Chris Nebinger


>-----Original Message-----
>"Chris Nebinger" <(E-Mail Removed)>
wrote in message
>news:1e06a01c4547b$f337af80$(E-Mail Removed)
>> CurrentProject.Connection is the connection string you
>> need.
>
>Unless I'm confused, CurrentProject.Connection actually
returns the
>Connection *object*, not the connection string itself.
Usually, that's
>what you want anyway. If you really want the connection
string, you
>would get CurrentProject.Connection.ConnectionString .
>
>--
>Dirk Goldgar, MS Access MVP
>www.datagnostics.com
>
>(please reply to the newsgroup)
>
>
>.
>