Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bare necessities for connecting to MS Access 2000

Status
Not open for further replies.

BigTeeJay

Technical User
Jun 13, 2001
106
0
0
US
Greetings all,
I trying to write a program, and I want to check that I
can access a Access 2K based .mdb file prior to trying to
access it (so my program doesnt crash).

What should I check for? I know I can check the registry
for Access 9.0, or check the access file for v9.x+. But
I also need JET 4.0+. Can I access the file in VB 6 even
if MS Access isnt installed on the PC? (via JET, etc?)
Or does Access v2000 have to be installed (so that you
can use it's driver). I would find it hard to believe that
you had to have Access installed in order to access the
data (if so, why bother writing a VB app?).

So, I guess... to boil my question down. Is there a way
to connect to a MS Access 2000 file using VB 6, without
having Access installed? And if so, what would be the
best way to check for it?

Regards,
Travis Johnson
 
Using the package development wizard, you will be given the option of creating the dependant files necessary for you application to run.

This involves outside components not be a part of your application but may be necessary to run with your application such as ms chart or other components.

You can contact MS for licensing these products and installing them with your application.

I have run into this and decided that a stand alone app was necessary.
 
So to make sure I understand you correctly its not as
simple as making sure that they have ADO 4.0 installed
(and then they wouldnt need Access, all I am doing
is simple queries like, select * from table, nothing
real fancy).
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top