I am an amateur programmer that helps build some solutions for my company.
I have an application that I did not originally create, but I have done a lot of modification. I think it was originally built VB 2005 and converted to VB 2010 where I have done most of my modification. It ran fine for people in when they had 32 bit systems, but they now cannot run it on 64 bit systems. This applications finds information in text files and moves it into an Access database.
I have a sister application that I built in VB 2010 that does not have this problem. It builds the tables that the first application writes to.
So - question 1 is: Is there a simple solution to getting the application to run on 64 bit systems?
I figured I would just copy the code and build a new version in VB 2010, but some ADODB connections / recordsets get errors (blue underlines) when I do this. The application I built from scratch uses OLEDB connections. I get the errors on:
Dim con As New ADODB.Connection,
Dim rstInput As ADODB.Recordset
So my second question is:
Why do I get an error on this when it works in another application, and what is the difference between ADODB and OLEDB?
Any help you can offer is greatly appreciated!