Newbie to programming

[Guest]

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)

 

[Arvin Meyer [MVP]]

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)

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

 

[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.

 

[Guest]

So you're saying I shouldn't be having this problem?

 

[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.

 

[Arvin Meyer [MVP]]

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.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Arvin Meyer [MVP]]

So you're saying I shouldn't be having this problem?

Also, if you are using ADO you may be able to use your forms in Access 2003
if you upgrade to MDAC 2.8.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Thank you. I'll try that.

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.

 

[Larry Linson]

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.

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