>>>>>will this work? if so, how? i can't get my program to recognize an access 7.0 database. we have to use the 16-bit system for now (clients are slow to upgrade)
>
>>>ok. what we have so far is that you can't use the jet engine directly, because vb uses a different driver based on development in 16 or 32 bit environment. what we're going to try is accessing the mdb (no pun intended) through odbc. will let you know what happens.
>>
>>trying access7.0 through odbc hangs system. who knew?
>
Hey, I just thought of something! Though I've never used OLE and can't advise on it,
but I know for a fact, that both VB and Access still extensively support DDE. Can you
try (I mean do you still have time to try) to set up Access as a DDE server and then
poke it for all the data you need from it? And if you're familiar with OLE or its modern
buzz-word-equivalent ActiveX, then that might be the way to go!?