ADODB and Access 97 Problem
Posted on 2004-10-21
Using VB6. Developed a simple prg for use at my office. Overcame a setup problem (thanks guys), but now have a different problem.
My machine at home has XP Pro and MSOffice 2003. So my dbconnection is to a MSAccess 2003 db. At the office I have Windows ME and Windows 98, both with Office 97. Compiled and loaded, the prg works perfectly at home. I converted the db to Access 97, recompiled and packaged. Took it to the office. It loaded ok and went through its steps, but now it does not load the data to the tables in the Access 97 db. Is there a problem in using ADO with 97? All code remains the same as at home, but Access 97 did notify me that changes were made to the code for the db.
What do I need to do???....jb