Two Windows 2000 servers. One Access MDB file. I can map a drive or use a UNC to get to the MDB. Setup the DSN on one server that points over network to other server's MDB file. DSN creates no problem...but cannot use the connection. An 'S1000' error is presented which in some areas I have found state a permissions problem. Both boxes on same network and both logged in as Administartor. I can SEE the file and cut/copy/paste/move/delete, etc so why can't I SEE the data with an ODBC connection????
Very frustrating....
Very frustrating....