DAO.Recordset and DAO.Database Help

James

Guest

Posts: n/a

20th Jun 2006

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.

« SQL String continuation in VB | Hyperlink to specfic file »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't open a Database for a Recordset	=?Utf-8?B?Sm9obg==?=	Microsoft Access VBA Modules	4	2nd Feb 2007 05:37 PM
DAO.Recordset and DAO.Database Help	James	Microsoft Access	2	20th Jun 2006 06:47 PM
database connection with recordset in vb.net	Swarup Kalyan via .NET 247	Microsoft Dot NET Compact Framework	0	6th Sep 2004 04:09 AM
In Memory Recordset Without Creating Database	Alok Joshi	Microsoft Excel Programming	3	26th Jul 2004 08:41 AM
Database Recordset not updateable	Aaron Shumaker	Microsoft Access	7	27th Mar 2004 11:28 PM