
How to use remote database by ODBC?
Hi,
I use ODBC to map my database on the other machine to drive "F".
So, the database file is mapped to "F:\jane\test_user.MDB".
I put the following lines on my VB code:
Set OldWs = DBEngine.Workspaces(0)
Set OldDb = OldWs.OpenDatabase("F:\jane\test_user.MDB")
However, it gives me error indicates that "Database cannot be opened".
Do you know the reason?
Jane