DAO.Recordset and DAO.Database Help

  • Thread starter Thread starter James
  • Start date Start date
J

James

I've got 2 databases... we'll call them a and b. I'm in 'a' and I want
my DAO.Database object to be database 'b' how do i set my object to
that database?


Here's some of my code:

Dim dbs As DAO.Database
Dim rs As DAO.Recordset

Set dbs = __________
Set rs = dbs.OpenRecordSet(qOfferings_Display)



I'm just an intern trying to learn (never delt with DAO stuff
before).... Thanks for the help.
 
You need to use the OpenDatabase method to return a reference to the other
database. The query name then needs to be delimited with quotes when
establishing the recordset:

Dim dbs As DAO.Database
Dim rs As DAO.Recordset

Set dbs = OpenDatabase("C:\SomeFolder\SomeSubfolder\b.mdb")
Set rs = dbs.OpenRecordSet("qOfferings_Display")

Check out the OpenRecordset method in Help as you might need to specify the
type of recordset as the second argument depending on what you want to do
with it.

Ken Sheridan
Stafford, England
 
You need to use the OpenDatabase method to return a reference to the other
database. The query name then needs to be delimited with quotes when
establishing the recordset:

Dim dbs As DAO.Database
Dim rs As DAO.Recordset

Set dbs = OpenDatabase("C:\SomeFolder\SomeSubfolder\b.mdb")
Set rs = dbs.OpenRecordSet("qOfferings_Display")

Check out the OpenRecordset method in Help as you might need to specify the
type of recordset as the second argument depending on what you want to do
with it.

Ken Sheridan
Stafford, England
 
Back
Top