Open connection code problem

I am upgrading an Access 98 to Access 2007 and having problems with "open connection" code. The old code is
'Open connection
set ConnObj = server.CreateObject("ADODB.Connection")
ConnObj.Open "datatronics"
set RstObj = server.CreateObject("ADODB.Recordset")
RstObj.Open "Select distinct(icat) from items order by icat", ConnObj

'get catagory information
catagory = request("cat")
	

I need help with the Access 2007 on this site and how to change the old version code
Standard security
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
Persist Security Info=False;

Jim

0 answers