How do I modify connection properties in Access Passthrough Query

  • Thread starter Thread starter bickforc
  • Start date Start date
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?
 
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?
Click to expand...

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........
 
Back
Top