Using MS Access queries

Resolved · Low Priority · Version 2003

Wed 4 Mar 2009, 15:13 Delegate Richard said...

Richard has attended:
Access Advanced course

Using MS Access queries

Where I telework, the network speed is extremely slow. This affects me when I am trying to run MS Access queries.

How can I use MS Access to get round this? Is the use of make-table queries the best / only way round a slow network?

Thu 5 Mar 2009, 09:57 Trainer Stephen said...

RE: Using MS Access queries

Hi Richard

Thank you for your question

Using a make table query would place a copy of a table on your lap top. You could then build queries on that, thus avoiding the need to connect remotely to the database.

The problem would be that the tables you create would be a snapshot of the data at the time you built them and would not necessarily represent the up to date data.

You might want to consider the method you use to connect when working remotely, and seek advice from your IT support.

Regards

Stephen

Wed 11 Mar 2009: Automatically marked as resolved.

Access tip:

Design View in Relationship window

Your in the Relationship window and changes are required to be made to a Table's design.

Rather than exiting the Relationship window, if you perform a right-mouse click on the table, it opens that table up in Design view

View all Access hints and tips

Using MS Access queries

Using MS Access queries

RE: Using MS Access queries

Access articles

Access tip:

Design View in Relationship window