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
edit delete
are you sure?
asked unknown

1 answer

First of all thank you so much for this share. I'm so involved to read varieties of articles. It looks as if something distinctive and useful to recognize extra approximately this particular subject matter. And additionally, have the habit to bookmark the ones content material if it's far without a doubt properly and that I may have the tendency to read it again. Click Here, For More Educational Stuff at https://www.6dollaressay.com

enter image description here

0
edit delete
are you sure?
answered Jam Martin

Post an answer but please login first

Post Answer
  1. Please login to post answer

Similar Questions

Tagsfor this question

Forumall questions