Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ACCESS2000 Connection Question

Status
Not open for further replies.

m3hosting

MIS
May 10, 2001
8
US
I am using Visual InterDev and Access97/access2000. I have the following database connection I add to all .asp pages via an include. I want to switch to 2000 and have problem with connection.

<%Dim objConn 'declare your variable to hold your connection
Set objConn = Server.CreateObject(&quot;ADODB.Connection&quot;)
objConn.ConnectionString=&quot;DRIVER={Microsoft Access Driver (*.mdb)};&quot; & &quot;DBQ=F:\ Support.mdb&quot;
objConn.open
%>


This works great for ACCESS97. Can anyone let me know how to create the same type of DSNless connection and be able to connect to an ACCESS2000 database.

Thanks in advance

Mark
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top