Access 2002 to Access 97 conversion in VB6
Access 2002 to Access 97 conversion in VB6
(OP)
Hello!
Certain program generates a database in Access 2002 format, but Visual Basic 6 only can recognice Access 97 format. (as I know)
Can anyone tell me if there is a code to transform the database without using sendkeys?
Thanks a lot.
Certain program generates a database in Access 2002 format, but Visual Basic 6 only can recognice Access 97 format. (as I know)
Can anyone tell me if there is a code to transform the database without using sendkeys?
Thanks a lot.





RE: Access 2002 to Access 97 conversion in VB6
VB6 has several data access technologies. DAO is the oldest of these. DAO cannot recognize MSAccess formats beyond Access97. But there is another technology called ADO that can recognize Access2000. I'm not sure about Access2002, but possibly it can handle that also. If you make an ODBC data source out of your Access file, than you can work with any version of Access from VB6.
Best regards.
Yeasir Rahul
Principal,
VoltSmith Technologies
Industrial Control and Automation
Email: rahul@voltsmith.com
Web : www.voltsmith.com
RE: Access 2002 to Access 97 conversion in VB6
Here is a link (but I'm not sure this is the latest)
http://msdn.microsoft.com/vstudio/downloads/updates/sp/...
RE: Access 2002 to Access 97 conversion in VB6
RE: Access 2002 to Access 97 conversion in VB6
Can you post the code that you're using? And please indicate which ADO references you've included in the VB project.
RE: Access 2002 to Access 97 conversion in VB6
Connect: Access
Default type: 2 Use jet
----------------------------
' An extract of the code is
Data1.DatabaseName = "Here is the name"
Data1.RecordsetType = 0
Data1.RecordSource = "Coordinate Systems"
' here are some other lines
' and then the code follows
data1.refresh
' and rise the next error
ERROR 3343. The format of the database is not recognized.
RE: Access 2002 to Access 97 conversion in VB6
From Project->Components menu select "Microsoft ADO Data Control 6.0" and the ADODC control will be added in your toolbox window.
Regards
Yeasir Rahul
Principal, VoltSmith Technologies
www.voltsmith.com
RE: Access 2002 to Access 97 conversion in VB6
So, the use of ADO its a little bit difficult in thids case.
Help?
RE: Access 2002 to Access 97 conversion in VB6
Good Luck
johnwm