OPS!!!! concatenate string connection with var

[sal21]

my open connection string:

Code: Select all

.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
              "Data Source=C:\REPORT_L0928\" & MIO_DB & "_TEST.mdb;Persist Security Info=False"

i need to join MIO_DB var (is dimensioned As String)...

in this case have error:-)

[HansV]

If the value of MIO_DB is for example "Sal21", the data source would be

C:\REPORT_L0928\Sal21_TEST.mdb

Is that what you want?
What is the value of MIO_DB when the error occurs?

[sal21]

If the value of MIO_DB is for example "Sal21", the data source would be

C:\REPORT_L0928\Sal21_TEST.mdb

Is that what you want?
What is the value of MIO_DB when the error occurs?

wow!!!! TKS

[HansV]

So - has your problem been solved? And if so, how?