Access 2007 split database

[BlueHorizon]

Hi all,

Thanks in advance!!

I have a split database (backend on server and frontend on PCs). Can I create queries on the frontend copies?

Thanks!

Best,
Blue Horizon

 

[randy700]

yes

Randy

 

[BlueHorizon]

Ok, so make me beg....How?

Best,
Blue Horizon

 

[PHV]

Ok, so make me beg....How?
what is the problem ?
Create queries using the linked tables

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[BlueHorizon]

When I use Create/Query Design, it won't let me load any tables. When I use the Query Wizard, it won't show any fields for any table I select from the drop down.

Any ideas on what might be happening? It sounds like it should work....

Best,
Blue Horizon

 

[PHV]

How do you know you're connected to the BackEnd ????

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Hap007]

I would open one of the Linked tables.

If you can open a linked table and see data then you should be able to use the query wizard.

If not, the try refreshing the linked tables connection.

Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[BlueHorizon]

That's it! Thanks for the tip about refreshing linked tables. Duh!



Best,
Blue Horizon