How do I modify connection properties in Access Passthrough Query

B

bickforc

In Access 2003, you could right click on a Passthrough query in SQL view and
choose "properties".
That feature seems to have gone in 2007.
Is there another way to reset the connection properties?
 
A

Albert D. Kallal

bickforc said:
In Access 2003, you could right click on a Passthrough query in SQL view
and
choose "properties".
That feature seems to have gone in 2007.
Is there another way to reset the connection properties?

Bring up the query in design view, and then display the property sheet. You
can see the connection string setting, and also click on the [...] button
that appears when you click on the connection setting in that property sheet
to bring up the connection builder/wizard........
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top