VB6 with Access XP

[Electromechanical30]

Hello -

I am trying to create a basic user interface using Visual Basic 6. I would like to use (keep) the original .mdb as my data store. The problem that I have is the Data Form Wizard in VB will not accept (recognize) the .mdb...

Is this due to the original database tables being created with Access XP?? (Am I living in the Stone Age here using VB6?)

Any pointers are appreciated!!

Thanks in advance!

 

[IRstuff]

You should post this type of question on Tek-Tips.com

TTFN

FAQ731-376

 

[xwb]

Which VB6 service pack do you have? This problem should have been fixed in SP4. To be safe, just download SP6 from MS.

http://msdn2.microsoft.com/en-us/vstudio/Aa718364.aspx

The root cause is that Access 97 is JetEngine 3.x while Access XP is JetEngine 4.x. SP4 fixes that problem.

 

[Electromechanical30]

xwb-

Loaded SP6, works like a charm!!

Thanks!