Permission errors running ASPs on Access db on network

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to link my FP2000 web site to an Access db on a network drive. Additionally, my Access db has tables linked to our accounting system (i.e. MAS90). FP2000 successfully validates the connection to the Access db. However, I get the following two errors went I run ASP queries: (1) Database Results Error [Microsoft][ODBC Microsoft Access Driver] 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 (2) Database Results Error Description: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file 'E:\Databases\Master.mdb'. It is already opened exclusively by another user, or you need permission to view its data. Number: -2147467259 (0x80004005) Source: Microsoft OLE DB Provider for ODBC Drivers. The first error is caused just by quering (via ASP) the Access db using internal tables. The second error is caused by querying (via ASP) the Access db with linked tables. I've tried changing my security on my Temp folder (per MS knowledgebase article), however, I still have the same problem. Please advise. Thanks! Bo
 
I think I know the answer. If I link to another database...does that database need to be on a db or web server? I think I'm linking to db's that are only on a file servers. Please confirm if I need for the source databases to be on a db/web server. Thanks, Bob.
 
Hi Bob,
the database doesn't need to reside on a web server - a file server is fine.
But you'll need to sync the i_usr passwords on the 2 machines - this article
should help you out
http://www.aspfaq.com/show.asp?id=2168

Jon
Microsoft MVP - FP

Bob Stenz said:
I think I know the answer. If I link to another database...does that
Click to expand...
database need to be on a db or web server? I think I'm linking to db's that
are only on a file servers. Please confirm if I need for the source
databases to be on a db/web server. Thanks, Bob
 
Back
Top