|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
November 25th, 2003, 03:16 PM
|
|||
|
|||
|
Access won't connect
I'm tring to connect to an Access DB with this code:
Code:
'Open database connection
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
connstr="DSN=manual_info"
objConn.Open(connstr)
but i get this error Code:
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [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. /index.asp, line 19 The database is not already opened. What does this mean? EDIT: if i add on error resume next, it just hangs. Last edited by gsfgf : November 25th, 2003 at 03:25 PM.
|
|
#2
November 25th, 2003, 08:37 PM
|
|||
|
|||
|
When you Know that everyone is out of the computer see if there is still a DatabaseFile.ldb in existence. If it is Delete it.
If that doesn't work, make a test copy and try connecting to the test copy. S-
|
|
#3
November 26th, 2003, 03:41 PM
|
||||
|
||||
|
Hi,
Try it with DAO. It should work in shared mode too. --------------------------------------- Dim wsp As Workspace Dim db As DAO.Database Set wsp = CreateWorkspace("", "admin", "", dbUseJet) Set db = wsp.OpenDatabase("database_path_and_file", False, False) --------------------------------------- For more, check out 'DAO' and 'CreateWorkspace' topics in Help. I hope this helps you. BRegs, TBÁrpi
|
|
| Viewing: ASP Free Forums > Database > Microsoft Access Help > Access won't connect |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
