Make local ADO connection with Data source being current databsa

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gert - 16 Jul 2008 15:57 GMT

Hi,
I am using Access and want to make a ADODB connection, but I do not
want to type a path for the Data source -
Instead I just want to refer to "Current Database" ... not "Data
Source = C:\Name.mdb
Is this possible?

Reply to this Message

William Vaughn (MVP) - 16 Jul 2008 17:58 GMT

IIRC this is an Access feature, not supported from VB or by ADO (COM-based).
I would build up the ConnectionString using the current path.

> Hi,
> I am using Access and want to make a ADODB connection, but I do not
> want to type a path for the Data source -
> Instead I just want to refer to "Current Database" ... not "Data
> Source = C:\Name.mdb
> Is this possible?

Signature

__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________

Reply to this Message

VB Forum / Database Access / July 2008

Make local ADO connection with Data source being current databsa