Connection problems

[michael.ball4]

Hi there,

I've been working with VB6 for a few years and am used to programming around
access through VB. I've since tried to use VBA through Access and have
found that there are a few problems. There seems to be a different object
model construct between versions ie. Access 97, 2000, 2002. This looks as
if it will cause major problems if I want to move my project from one Access
version to another. Even a higher one. I see there is an
Access.Codeproject.Connection but I can't seem to find the same thing with
Access 2000. I suppose the question really is this:

I'm trying to recode a project I started in Access 2002 in Access 2000. The
object models are different! Where can I find a similar property (to use
with ADO) to Access.Codeproject.Connection.

 

[Pieter Wijnen]

No such thing (no native SQL db in Access 2000 <", you can however query
(the hidden table) MSysObjects to find the link to the attached tables
HTH

Pieter

 

[Perry]

I'm trying to recode a project I started in Access 2002 in Access 2000.
The

object models are different! Where can I find a similar property (to use
with ADO) to Access.Codeproject.Connection.

CurrentProject.Connection

Can you rephrase your question?
What do want to achieve ?

Krgrds,
Perry