Call Database in ADO For Table Linking

[amywolfie]

Hi all:

I am using Access 2002, and of course, when I copied the solution from
the Solutions.mdb to link tables at startup, I got an area using the
code supplied.

I have since tried a variety of other calls, to no avail.
Below is sample code.

Could someone provide:
1) Correct code
2) Type library I need to be connected to.

I would like to use ADO rather than DAO.

Thanks!

amy
===
Dim db As ado.Database
Dim rst As ado.Recordset

Set rst = CurrentDb

' Open linked table to see if connection information is correct.
On Error Resume Next
Set rst = dbs.OpenRecordset("Fees_be")

[Allen Browne]

Database is a DAO object.
CurrentDb is supplied by DAO.
TableDef is a DAO object, and so on.

Why would you want to use ADO and the associated problems and
inconsistencies of the ADOX library versions, when DAO is the native Access
library?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"amywolfie" <am*******@verizon.net> wrote in message
news:33**************************@posting.google.c om...

I am using Access 2002, and of course, when I copied the solution from
the Solutions.mdb to link tables at startup, I got an area using the
code supplied.

I have since tried a variety of other calls, to no avail.
Below is sample code.

Could someone provide:
1) Correct code
2) Type library I need to be connected to.

I would like to use ADO rather than DAO.

Thanks!

amy
===
Dim db As ado.Database
Dim rst As ado.Recordset

Set rst = CurrentDb

' Open linked table to see if connection information is correct.
On Error Resume Next
Set rst = dbs.OpenRecordset("Fees_be")

[amywolfie]

I was thinking ahead in case I have to upsize the backend to SQL.

But in order to use the DAO command, which Type Library do I need to activiate?

Thanks!
amy
===
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<40**********************@per-qv1-newsreader-01.iinet.net.au>...

Database is a DAO object.
CurrentDb is supplied by DAO.
TableDef is a DAO object, and so on.

Why would you want to use ADO and the associated problems and
inconsistencies of the ADOX library versions, when DAO is the native Access
library?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"amywolfie" <am*******@verizon.net> wrote in message
news:33**************************@posting.google.c om...

I am using Access 2002, and of course, when I copied the solution from
the Solutions.mdb to link tables at startup, I got an area using the
code supplied.

I have since tried a variety of other calls, to no avail.
Below is sample code.

Could someone provide:
1) Correct code
2) Type library I need to be connected to.

I would like to use ADO rather than DAO.

Thanks!

amy
===
Dim db As ado.Database
Dim rst As ado.Recordset

Set rst = CurrentDb

' Open linked table to see if connection information is correct.
On Error Resume Next
Set rst = dbs.OpenRecordset("Fees_be")

[Rick Brandt]

"amywolfie" <am*******@verizon.net> wrote in message
news:33**************************@posting.google.c om...

I was thinking ahead in case I have to upsize the backend to SQL.

FWIW I've been using SQL Server back ends for years and have yet to write my
first line of ADO code.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Allen Browne]

The library is:
Microsoft DA0 3.6

More information about references:
http://allenbrowne.com/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"amywolfie" <am*******@verizon.net> wrote in message
news:33**************************@posting.google.c om...

I was thinking ahead in case I have to upsize the backend to SQL.

But in order to use the DAO command, which Type Library do I need to activiate?
Thanks!
amy
===

[Pieter Linden]

am*******@verizon.net (amywolfie) wrote in message news:<33**************************@posting.google. com>...

I was thinking ahead in case I have to upsize the backend to SQL.

But in order to use the DAO command, which Type Library do I need to activiate?

Thanks!
amy
===

Microsoft DAO 3.X Object Library (If you're using 2000 or later, it's version 3.6).

[amywolfie]

Thanks everyone for your help. I opted for ADO since I was involved
in upsizing a very large Access database with reams of DAO code to
SQL, and the developer ended up rewriting that code in ADO.

From what you're saying, that wasn't entirely necessary.

Thanks!
amy
===
pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>...

am*******@verizon.net (amywolfie) wrote in message news:<33**************************@posting.google. com>...

I was thinking ahead in case I have to upsize the backend to SQL.

But in order to use the DAO command, which Type Library do I need to activiate?

Thanks!
amy
===

Microsoft DAO 3.X Object Library (If you're using 2000 or later, it's version 3.6).