By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,737 Members | 1,289 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,737 IT Pros & Developers. It's quick & easy.

Connect to existing DataSet in MS Access report

P: 1
I'm using VBA in Access 2003 to create and process recordsets in reports. As a separate development, I'm now creating these same "recordsets" as .NET DataSets. How do I connect to these new .NET DataSets from Access? I can't seem to import the .NET System.Data library.

In essence, I'd like to change the VBA code in my reports from

Expand|Select|Wrap|Line Numbers
  1. Set rst_chg = dbs.OpenRecordset("SELECT ...")
to something like this:

Expand|Select|Wrap|Line Numbers
  1. Set rst_chg = the existing DataSet from my other development
Thanks,
Guy
May 29 '07 #1
Share this Question
Share on Google+
1 Reply

MMcCarthy
Expert Mod 10K+
P: 14,534
Hi Guy

I don't think you can do this with DAO. Look into creating an ADO connection to your data source instead.

Mary
Jun 1 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.