Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access paramterised queries

Status
Not open for further replies.
Bakunin

Bakunin

Programmer
Dec 21, 2000
31
GB
Hi,
I have a simple question. Is it possible to pass parameters from VB(6) to an MS Acess queries and get a recordset back to VB using ADO?

I thought I had seen a method of doing this before but haven't seen it since.

ta.
 
Sort by date Sort by votes
It seems very possible. I have never done that before, but from VB(6), I would establish a DAO connection to that Access database and pull the SQL from that Querydef object. Next, modify the SQL with the parameters, then create the recordset in ADO.

I am sure someone else has a more definitive answer, but I hope my suggestion helps you in the right direction.

Gary
gwinn7
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Access VBA Syntax Error 1
Replies
5
Views
4K
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question
Using Access Database Without Having MS Access
Replies
9
Views
5K
grnzbra
grnzbra
OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
5K
OCM
OCM
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
979
renigar
renigar
TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
5K
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top