ODBC dBase error

[MikeT]

I've created an ASP page to search multiple databases, even if the user is currently logged into their database. This has been setup successfully in 4 offices. Now we are trying to set it up in another office, but if the user is logged in, I get this message when I try to setup the System DSN: "The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data." This message box is titled "ODBC dBase Driver Login Failed" I have the latest MDAC, and setup everything the same as the other offices.

 

[pd123]

What type of database is the DSN connecting to?

 

[MikeT]

Actually; I decided to bypass the DSN connection with the following string":

Driver={Microsoft dBASE Driver(*.dbf)};
DriverID=277;Dbq=c:\mydb;

then I can access the db with:

SELECT * FROM mydb.dbf

But ONLY if no one else is in it. None of the other locations where I set this up do this. I think its within the driver itself, but I have installed MDAC 2.7. I'm thinkng about looking for a way to unstall my current MDAC, and re-install 2.7. Who knows....

 

[MikeT]

im sorry; i didn't answer your question!

It is an ACT 4.o dbf file.