Re: Error accessing MS Access database with Linked Tables on files
- From: "Peter Johnson" <peternjohnson@xxxxxxxxx>
- Date: 21 Apr 2006 16:10:15 -0700
The other method of connecting to this datasource would be to create a
system odbc connection.
You can do this through the Data sources (odbc) tool.
To get to this you go to the control panel on the server, then to the
administrative tools, then the datasources wizard is located within.
Once you have setup your odbc connection you just modify the connection
string for the database in your web config.
This is also called a DSN for the connection string see
http://www.connectionstrings.com
Also within access if you link tables you should use this method, this
way it doesn't matter if the database resides locally, or on a server,
your always pointed at the database correctly.
One other thing that this will allow you to acheive is that when you
set up the DSN you can instantly test it, so if you don't have enough
permissions / can't see the database then you see immediatly instead of
having to write code to check for permissions based errors etc.
.
- References:
- Re: Error accessing MS Access database with Linked Tables on fileshare
- From: Paul Clement
- Re: Error accessing MS Access database with Linked Tables on files
- From: Pål Eilertsen
- Re: Error accessing MS Access database with Linked Tables on files
- From: Paul Clement
- Re: Error accessing MS Access database with Linked Tables on fileshare
- Prev by Date: is this a bad idea?
- Next by Date: Re: A problem with the datagrid
- Previous by thread: Re: Error accessing MS Access database with Linked Tables on files
- Next by thread: Re: Error accessing MS Access database with Linked Tables on files
- Index(es):
Relevant Pages
|
