Fog Creek Software
Discussion Board




ODBC for Access over Network

Is it possible to create an ODBC datasource for an Access database on another machine *without* mapping a drive?

In going through the ODBC set-up dialog I don't see any choice for other than finding the .mdb on a mapped drive.

Any suggestions on c# connecting to Access on another server would be appreciated.

steved
Thursday, January 22, 2004

Who knows why the dialog is so burdensome, but just try entering the UNC in the "Database Name" Editbox. i.e. \\SERVER\Share\folder.

Dennis Forbes
Thursday, January 22, 2004

Yeah, I get the same restricted BrowseForFolder problem with creating a backup of my MS SQL Server database.

Sathyaish Chakravarthy
Thursday, January 22, 2004

I've used UNC style references to linked .mdb files/tables since version 2. No problems here.

Sgt. Sausage
Thursday, January 22, 2004

Its easier if you have a directory above (or the one its in) the database shared but any UNC that has the right permissions should be fine.

Simon Lucy
Friday, January 23, 2004

*  Recent Topics

*  Fog Creek Home