Visual Basic 6.0 and Access 2003 question.

January 26, 2005 11:49 AM

Visual Basic 6.0 and Access 2003 question.....(more inside)

Visual Basic 6.0's integrated Visual Data manager saves all db's in access 97 format. When I need to build a relationship between two databases created with the visual data manager, I have to convert the db to access 2004 format and then back again so I can manipulate the db through the visual data manager. I've looked all over MS's website and can't find any update that adresses this. Is there anyway i can avoid constantly converting the db's?

posted by ttrendel to Computers & Internet (3 answers total)

Looks like you're not getting any answers even though this has been up for 2 hours. Please forgive me for providing the dreaded "but have you tried Y?" answer, but is there any possibility of switching to SQL Server or some other ODBC database?
posted by matildaben at 1:54 PM on January 26, 2005

This may wind up exposing my ignorance, but:
1. Is everything on the same machine?
2. Would upgrading the MDAC (Microsoft data access controller) maybe alleviate this issue?
posted by yerfatma at 4:38 PM on January 26, 2005

I don't know beans about Visual Data Manager, but you may be able to use Microsoft SQL Server Desktop Engine.
There are license restrictions. read them before you try any redistribution.
...Maybe MySQL?
posted by nj_subgenius at 5:26 PM on January 26, 2005