ODBC for Access over Network
Is it possible to create an ODBC datasource for an Access database on another machine *without* mapping a drive?
Who knows why the dialog is so burdensome, but just try entering the UNC in the "Database Name" Editbox. i.e. \\SERVER\Share\folder.
Yeah, I get the same restricted BrowseForFolder problem with creating a backup of my MS SQL Server database.
I've used UNC style references to linked .mdb files/tables since version 2. No problems here.
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.
Fog Creek Home