connecting a database

[zoglchaim770]

I am a begginer
I connected microsoft access datebase like this:
1. used "odbs", system DSN

2.

dim objconn
set objconn=server.CreateObject ("ADODB.connection&quot
objconn.ConnectionString = &quot;<name>&quot;
objconn.open

and I get this error
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.
/school.asp, line 12(In objconn.ConnectionString = &quot;<name>&quot;!)
I don't undestand. My datebase is not in use, it's closed
Does it make a differeents, what kind of format do you use for access datebase 2000 format, 2002 format

 

[TonyU]

This may provide you with some answers:

http://aspfaq.com/show.asp?id=2009

There's never time to do it right, but there's always time to do it over!