connection string

  • Thread starter Thread starter Chris Nebinger
  • Start date Start date
C

Chris Nebinger

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 said:
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 .
 
The default property of the Connection object is the
ConnectionString. So, I just use the
CurrentProject.Connection.

Debug.Print CurrentProject.Connection



Chris Nebinger
 
Back
Top