Code: Select all
.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=C:\REPORT_L0928\" & MIO_DB & "_TEST.mdb;Persist Security Info=False"
in this case have error:-)
Code: Select all
.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=C:\REPORT_L0928\" & MIO_DB & "_TEST.mdb;Persist Security Info=False"
wow!!!! TKSHansV wrote: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?