connect to vb database with access

[mharness]

Hello and help!!

I'm meeting with a client tomorrow about possibly developing an access or
apsx app from an existing visual basic database application (done in-house,
developer baled out and left them holding the bag). Trouble is I don't know
the first thing about how to look at or connect to their data.

Can I connect to their app with an Access ODBC or adp or if not how else can
I get into the backend to see their raw data and ultimately export it to
Access or SQL?

Many thanks,

Mike

 

[John Nurick]

There's an excellent chance that the VB app is using ODBC to connect to
the back end database - and a good chance that the database engine is
Jet or maybe a flavour of SQL server.