Re: ADO query to Access not working, no errors

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi Ralph.

That's not entirely accurate...

1. I have an MSAccess query object already in an MSAccess database. I
want the query object to take a string value, passed as a parameter
from the VB app, and use it as criteria in the query.

2. I can run the query from the VB app, (MSAccess will make the table
object and display the fields in the table that I have selected in the
query object in the MSAccess DB from the VB app) just can not get the
existing MSAccess query to take the parameter from the VB app and use
it as the query criteria.

Thanks!


Do I have this right?
1) You have a Query object in MSAccess that takes a parameter.
2) You want to run that Query object from a VB app using ADO?

If that is correct, then you can't do it. You can only call MSAccess Queries
using automation. However, you can create ADO SP with ADO and save them -
but the queries can not be seen from inside the MSAccess program.

-ralph

.

Relevant Pages

  • Re: ADO query to Access not working, no errors
    ... I have an MSAccess query object already in an MSAccess database. ... I can run the query from the VB app, ...
    (microsoft.public.vb.database.ado)
  • Re: Linked .csv File Locking
    ... I don't know if you are offering this MsAccess app that links to the ... or if your user community has written their own apps ... MsAccess db in the ftp download. ... using and keeping it read-only without locking it up. ...
    (microsoft.public.access.security)
  • Automate MSAccess from Windows .Net app
    ... then open MSAccess and open a secured Access ... the app is already open and opening the secured app. ... the MSAccess app but I can't get the API calls to work in .Net ...
    (microsoft.public.dotnet.general)
  • Re: Automate MSAccess from Windows .Net app
    ... First of all, if possible, I'd avoid automate Access app: ... then open MSAccess and open a secured Access ...
    (microsoft.public.dotnet.general)