Database 'File open error'

Results 1 to 2 of 2

Thread: Database 'File open error'

  1. #1
    Join Date
    Dec 1969

    Default Database 'File open error'

    Greetings,<BR><BR>I HAVE A PROBLEM.<BR><BR>This is the code that I use to open an Access database. I have used it in other .ASP files and it works fine.<BR><BR> <BR>Dim DataPreCompute, SlctUser, SQL <BR>Dim DataPreCompute1, SlctUser1, SQL1 <BR><BR>Set DataPreCompute = Server.CreateObject("ADODB.Connection")<BR>DataPre Compute.Open "DBQ=" & Server.Mappath("Budget.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};" <BR>Set SlctUser = Server.CreateObject("ADODB.Recordset") <BR>SQL = "SELECT * FROM ClientPieChoice"<BR>SlctUser.Open SQL, DataPreCompute, 3, 3, 1<BR><BR>Set DataPreCompute1 = Server.CreateObject("ADODB.Connection")<BR>DataPre Compute1.Open "DBQ=" & Server.Mappath("Budget.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};" <BR>Set SlctUser1 = Server.CreateObject("ADODB.Recordset") <BR>SQL1 = "SELECT * FROM ClientPieBestSelect" <BR>SlctUser1.Open SQL1, DataPreCompute1, 3, 3, 1<BR><BR><BR>When the code operates I receive the below message.<BR><BR>[Microsoft][ODBC Microsoft Access Driver] Could not use &#039;(unknown)&#039;; file already in use. <BR><BR>I am stumpted.<BR><BR>The error specifically occurres on the life<BR><BR>DataPreCompute1.Open "DBQ=" & Server.Mappath("Budget.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};" <BR><BR><BR>Please Help...<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Database 'File open error'

    If you have it open locally, it is locked...<BR>;en-us;Q306518<BR><BR>make sure no one can open up the database locally.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts