Converting from access 2002 to access 97
This may be a little crazy.
I know very litle about databases but am very comfortable with vb6.
Since VB6 is becoming passe the only books on vb6 and databases were written ten years ago and the code samples used access 97.
There are several database programs with the vb6 code in these books that were written in access 97 that meets my needs. I don't want to become a database expert but I can slog through the code to make minor changes.
I have access 2002 on my computer.
Each time I try to open the databases in access 2002 that came with these vb6 program an error message appears telling me that this database cannot be opened by access 2002 and must be converted.
When I try to use the new access 2002 database in the vb6 program an error message appears saying "unrecognized database format".
This database applications are for a desktop and simple "enter the telephone number and get the customer data" with some none primary attached tables.+++++++++++++++++++++++++++++++++++++++++++++
My mind says that the easiest way out of this is to install access 97 on my computer.
1. Can a vb6 program written for access 97 be "easily" converted to use with access 2002 if I stuck with access 2002?
2. Can I have a problem with both access programs on my computer?
3. Can I disable access 2002 temporarily so only access 97 works?
4. Can I add/delete fields in the access 97 database with access 97?
5. Am I crazy to go back to access 97?
Thank you very much for your help?
A much simpler solution is to install the latest Service Pack for Visual Studio: http://msdn.microsoft.com/en-us/vstudio/aa718360
See this article for more information: http://support.microsoft.com/kb/238401
Please post questions to the forums, where others may benefit.
I do not offer free assistance by e-mail. Thank you!
By Farli in forum VB Classic
Last Post: 07-02-2002, 08:00 PM
By Seth Grossman [MSFT] in forum vb.announcements
Last Post: 03-13-2002, 08:32 PM
By MacDeath in forum VB Classic
Last Post: 02-14-2001, 06:44 AM
By John Simmons in forum Enterprise
Last Post: 02-09-2001, 01:42 PM
By Veronica in forum Database
Last Post: 05-17-2000, 09:16 AM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL