Use string value for database location - VBA

W

wolfbrain

I posted earlier, but I think I may have been too obtuse.

I have a string value:

Dim DBLocation As String

Then I have a database connection which I want to use the DBLocation
for the DQB.

DBQ=DBLocation

I can't seem to get it to work....

THanks,
Brian
 
D

Dave Peterson

Check your earlier post.

I posted earlier, but I think I may have been too obtuse.

I have a string value:

Dim DBLocation As String

Then I have a database connection which I want to use the DBLocation
for the DQB.

DBQ=DBLocation

I can't seem to get it to work....

THanks,
Brian
Click to expand...
 

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

VBA to ask for file location and use to open DB 4
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
VBA - exporting serial letters to single documents 0
Problem with IF condition 0
Noob question on how to use an insert query in a command button 1
Drop down list control value in vba 2
ADO Open command fails on multiple SQL functions 1
Calculate the median value before a specified list 0

Top