Newbie to programming

B

Bryan

Ok, so why can't VB 6.0 access data from an Access 2003 database? I should be
using Jet 4.0, right? (The form worked when I used Access 2000)
 
A

Arvin Meyer [MVP]

Bryan said:
Ok, so why can't VB 6.0 access data from an Access 2003 database? I should be
using Jet 4.0, right? (The form worked when I used Access 2000)
Click to expand...

The structure of Jet files (MDBs) changed from Access 2000 to 2002. 2002 and
2003 are the same. All of those versions will read files stored in the
Access 2000 version.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
V

Van T. Dinh

Access 2003 and Access 2000 defaults to the same JET 4.

In addition, if you use VB, you are not using Access 2003 or Access 2000
file-format at all. You are using only the JET component of the database
file which is the same.
 
G

G. Vaught

You may need to install a different MDAC version such as 2.1 to 2.8 for VB 6
to 'talk' to Access 2003. Also remember you should use ADO and not DAO.
 
B

Bryan

Thank you. I'll try that.

G. Vaught said:
You may need to install a different MDAC version such as 2.1 to 2.8 for VB 6
to 'talk' to Access 2003. Also remember you should use ADO and not DAO.
Click to expand...
 
L

Larry Linson

Arvin Meyer said:
If the file structure is in Access 2000, you shouldn't be having the
problem. Obviously, VB6 won't be able to read file structures that were
developed after its release.
Click to expand...

Access 2002 and Access 2003 both use Jet 4.0, just like Access 2000. The
_Access_ part of later MDBs has some changes, but the tables and data ought
to be OK. If you link the proper DAO or ADO library, I'd think it could
work.

Larry
 
Top