S
soflahe
I am attempting to to use Microsoft Visual Basic .NET to connect to a
Microsoft Access database in order to retrieve data. I have achieved this by
using an OleDbDataAdapter.
I am now trying to do the same with a database (parent database) that has
tables linked to tables of different databases (child databases).
I can connect to the partent database and everything looks as though it is
running fine (I can preview the data in the Data Adapter Preview window) but
when I run the code I get an error that tells me that the path to one of the
linked (child databases) is invalid (see error message below).
I assumed that you only need one connection to the parent database in order
to allow Access manage the data but perhaps this is incorrect.
If anyone could point me in the right direction I would really appreciate it.
'FIlePathandName.mdb' is not a valid path. Make sure that the path name is
spelled correctly and that you are connected to the server on which the file
resides.
Microsoft Access database in order to retrieve data. I have achieved this by
using an OleDbDataAdapter.
I am now trying to do the same with a database (parent database) that has
tables linked to tables of different databases (child databases).
I can connect to the partent database and everything looks as though it is
running fine (I can preview the data in the Data Adapter Preview window) but
when I run the code I get an error that tells me that the path to one of the
linked (child databases) is invalid (see error message below).
I assumed that you only need one connection to the parent database in order
to allow Access manage the data but perhaps this is incorrect.
If anyone could point me in the right direction I would really appreciate it.
'FIlePathandName.mdb' is not a valid path. Make sure that the path name is
spelled correctly and that you are connected to the server on which the file
resides.