Connecting to Access 2k ??

[WhiteZiggy]

I have a question I hope someone can help me with..

I have a VB app that uses dao to open a database (Access). It opens 97 fine, "DAO.OpenDatabase(JobDBPath)", but I get the "unrecognized DB format" when I try to open 2000. Anyone know why this is? Is the only solution to switch to ADO? I would prefer not to have rewrite too much code for an app that runs fine otherwise and has been in use for a while.

Any suggestions are appreciated...

Thanks,
WZ

 

[CCLINT]

Nah, Just change your references from DAO 3.51 to DAO 3.6.
(You may need to update to VB6 SP5 first)

 

[WhiteZiggy]

DOH!!!

Thanks,

WZ