CONNECTING AN ACCESS DATABASE (HELP!!!)

[DALHART DOBBS]

WHEN I AM WORKING IN VISUAL BASIC AND ATTEMPT TO USE THE
DATA CONTOL FEATURE IN THE PROPERTIES WINDOW I:
CONNECT: ACCESS
DATABASENAME: (NAME OF DATABASE)
RECORDSOURCE: UNRECOGNIZED DATABASE FORMATT (ERROR
MESSAGE)COMES UP!!!
WHY CAN'T I CONNECT WITH THE DATABASE????
I AM USING ACCESS 2000/XP AND VISUAL BASIC 6.0
THANKS
(e-mail address removed)

 

[John Vinson]

WHEN I AM WORKING IN VISUAL BASIC AND ATTEMPT TO USE THE
DATA CONTOL FEATURE IN THE PROPERTIES WINDOW I:
CONNECT: ACCESS
DATABASENAME: (NAME OF DATABASE)
RECORDSOURCE: UNRECOGNIZED DATABASE FORMATT (ERROR
MESSAGE)COMES UP!!!
WHY CAN'T I CONNECT WITH THE DATABASE????
I AM USING ACCESS 2000/XP AND VISUAL BASIC 6.0
THANKS
(e-mail address removed)

Please DON'T SHOUT AT US. Writing in all caps makes your message hard
to read and is considered very impolite.

This error message will arise if you are using a version of JET older
than the version used by Access to create the database, or if the
database is corrupted. Can you open the database in Access? Does it
say 2000 format or 2002 format? What version of Jet are you
referencing in your VB project?

 

[dalhart dobbs]

-----Original Message-----


Please DON'T SHOUT AT US. Writing in all caps makes your message hard
to read and is considered very impolite.

This error message will arise if you are using a version of JET older
than the version used by Access to create the database, or if the
database is corrupted. Can you open the database in Access? Does it
say 2000 format or 2002 format? What version of Jet are you
referencing in your VB project?


.
sorry about the "shouting"

I am using Access 2000 how do I found out the version
of "jet", and by the way what is "jet"?
Thanks

 

[John Vinson]

I am using Access 2000 how do I found out the version
of "jet", and by the way what is "jet"?

Jet is the "database engine" for Access .mdb databases. It's
msjetXX.dll, probably in Windows/System or /System32 folders; I have
MSJET35.DLL and MSJET40.DLL, Jet 3.5 and 4.0. You should be able to
check the References in your VB project, and compare them to those in
Access - to check refs in Access, open the VBA editor by typing Ctrl-G
and selecting Tools... References from the menu.