need permission to view its data

[sajinb]

i have MDB file in a sepearte machine, i am accesing that MDB file from my machine through java program it gives no problem

Connection con = DriverManager.getConnection( "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=\\\\***.***.***.***/c$/Program Files/DownloadEngine/Database/SmartAMS.mdb;PWD=datt");
but when i host my program in another machine..it doesnot work from there it gives yu need permission to view its data....
what can be the problem..please help...

[Stewart Ross]

Hi. I think the error message is telling you directly what the problem is; you are trying to access the hard drive of a networked PC for which you don't have access rights at the alternative PC you are using. Although you must have set up the PC concerned to have a shared drive, you clearly do not have full access to that shared drive on the alternative PC. You could verify this by trying to connect to the PC hard drive directly from Windows.

Why not place the shared DB on a network server or other shared area (either a physical drive, or a mapped logical drive)? You could then use a standard URL that does not involve accessing a hard drive using the C$ peer-access notation, and be able to grant and control access rights to user groups. You would have much more flexible control than using direct peer access to the hard drive of another PC.

-Stewart