running visual basic project using access 2003

[Guest]

When I try to run a visual basic 6.0 project using an access 2003 database, I
get an error that says "Unrecognized database format". How can get access
2003 and visual base 6.0 to work together?

 

[Brian]

When I try to run a visual basic 6.0 project using an access 2003 database, I
get an error that says "Unrecognized database format". How can get access
2003 and visual base 6.0 to work together?

That'll be because a VB6 project is not an Access database. It all depends
on what you mean by "work together", but if you want to develop a VB6
project then you need to use VB6. Access can't open a VB6 project any more
than VB6 can open an Access database.

 

[Guest]

That'll be because a VB6 project is not an Access database. It all depends
on what you mean by "work together", but if you want to develop a VB6
project then you need to use VB6. Access can't open a VB6 project any more
than VB6 can open an Access database.

I am trying to use database designed in access 2003 for a visual basic 6.0
project. That is when I get the above mentioned error.

 

[Brendan Reynolds]

VB6 pre-dates the release of Access 2000, the first version of Access to use
version 4 of the Jet database engine, and there were some features of VB6
that would not work correctly with Jet 4 without the installation of a VB6
service pack. I *think* those issues mostly involved the VB6 data source
control and wizards, I don't remember any particular issues with connecting
to a Jet 4 MDB programmatically. But my memory of these issues is a bit hazy
now - you might get a more detailed response in a VB newsgroup.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Brian]

I am trying to use database designed in access 2003 for a visual basic 6.0
project. That is when I get the above mentioned error.

The message "unrecognized database format" is what you get when you try to
use Access to open a file which is not an Access database file. Access can
ONLY open Access database or project files e.g. mdb or adp. Access CANNOT
open ANY Visual Basic 6 file.

You CAN program a VB6 application (developed using VB6) to read and write
data to and from an Access database using, for example, DAO. VB code can
often be copied from a VB6 project and made to work in an Access database.
You can develop components of various kinds in VB6 and reference them in an
Access database.

What is it you are trying to do?

 

[Guest]

I am trying to use a database created using access 2003 in a visual basic 6.0
project. Do I need to do anything with the database in access before I try
to use it in vb6?

 

[Douglas J. Steele]

Depends on what you're trying to do with VB. If you're trying to use data
controls, make sure you have SP5 installed for VB6. If you're using DAO,
make sure you have a reference to DAO 3.6 (the default, I believe, will be
DAO 3.5x, which will not be able to communicate with Access 2000 or newer),
If you're using ADO, make sure you have an appropriate connection string.