Running Database Query

[Brandr]

Hello, I think that this is an easy question with a quick solution. To let you know, I'm running VB5 Enterprise and Access 97. Now onto my question...

I have a database (scs.mdb) with six different tables and two different update queries. I would like to know how I can code VB so that when a user hits a command button the two queries automattically run.

I've been experimenting with shelling Access and then using the SendKeys function, but this is a real pain and it won't work. Please help!

Thanks in advance,
Brandr Beekman
bbeekman@rbscorp.com

[JHausmann]

Not sure, my Access docs are at home, but you might be able to do a passthru query, just sending the name of your access update queries. At the very least you could create an access object and send the commands to it to run the queries.

I'll update this later, when I get home.