Access 2007 queries in frontend of a split database

[BlueHorizon]

Hi all,

Thanks in advance!!

I have a split database (backend on server and frontend on PCs).

How can individual users create queries on the frontend copies?

Thanks!

Best,
Blue Horizon

 

[randy700]

The only difference between building queries in a split database from one that is not split is the use of linked tables. The query itself is built in the same manner.


Randy

 

[dhookom]

There is a query by form applet that allows users to create and share queries.

Duane
Hook'D on Access
MS Access MVP

 

[BlueHorizon]

Hi,
thanks for your help - I just need to refresh the links on the linked tables.


Best,
Blue Horizon