From Access97 to Access2000
-
Hi all, "I have inherited" from a my colleague a VisualBasic6 application that uses an Access97 database with Jet(I suppose). In the code I found hte following string "Provider=MSDataShape.1;Persist Security Info=False;Connect Timeout=15;Data Source=" & JCR_DB & ";Data Provider=MICROSOFT.JET.OLEDB.4.0" Now I would to use Access2000 but, when I try to connect it I receive an message error: "incompatible format"... I think that I have to change the Project->References using a new OCX (?!) but how? Anyone could help me? Excuse me if I have described the problem in little detailed way but I don't know VB programming. ...and sorry for my english! Ciao!
-
Hi all, "I have inherited" from a my colleague a VisualBasic6 application that uses an Access97 database with Jet(I suppose). In the code I found hte following string "Provider=MSDataShape.1;Persist Security Info=False;Connect Timeout=15;Data Source=" & JCR_DB & ";Data Provider=MICROSOFT.JET.OLEDB.4.0" Now I would to use Access2000 but, when I try to connect it I receive an message error: "incompatible format"... I think that I have to change the Project->References using a new OCX (?!) but how? Anyone could help me? Excuse me if I have described the problem in little detailed way but I don't know VB programming. ...and sorry for my english! Ciao!
This web site has a vary good listing of all the ADO connection strings. http://www.able-consulting.com/ADO\_Conn.htm To make a reference to a different version of Ado goto project -> references, and they are called microsoft activex data objects. To download the lastest version of ADO, you will have to do this for each computer if it's not already installed.. http://www.microsoft.com/data/ Good luck