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.
If your child databases are on different computers/locations you will need the correct permissions to access that data. The local ASPNET user will not be sufficient and it doesn't matter that you are just connecting to the parent database in asp.net
You may need to use identity impersonate to access the data.
soflahe
Member
5 Points
1 Post
OleDbDataAdapter and Linked Access Datrabase Tables
Aug 22, 2006 12:36 PM|LINK
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.
cashmore
Contributor
2941 Points
552 Posts
Re: OleDbDataAdapter and Linked Access Datrabase Tables
Aug 23, 2006 11:25 PM|LINK
You may need to use identity impersonate to access the data.
Tim