Access question

  • Thread starter Thread starter RollieG
  • Start date Start date
R

RollieG

I know this isn't the correct forum for this question, but it is basic, and I
think I already know the answer.

How can creating a query in Access affect the data table that the query is
using?
 
Is this an Access query on an Access table? Is it a Select Query? Runnig a
Select query on a table does nothing to the table in and of itself. You can
typically make changes to the source table within the Select query, but not
by running it alone.
 
Yes, this is a select query in Access (2003).

Sean Timmons said:
Is this an Access query on an Access table? Is it a Select Query? Runnig a
Select query on a table does nothing to the table in and of itself. You can
typically make changes to the source table within the Select query, but not
by running it alone.
Click to expand...
 
Yes, this is an Access select query.

Sean Timmons said:
Is this an Access query on an Access table? Is it a Select Query? Runnig a
Select query on a table does nothing to the table in and of itself. You can
typically make changes to the source table within the Select query, but not
by running it alone.
Click to expand...
 
The only thing a query can do to a table is lock it so that nothing else can
use it at the same time.

You can even avoid this issue.

In Design View of the Query, right click in the grey area and select
Properties.

10th item down, ensure you have No Locks.

Other than that, you are free and clear!
 
If the database is on a shared server, where records are being continuously
added to the table, can I still run the query without affecting the addition
of new records.

I believe I am just querying the table at the time of running it. I know I
could run the query 5 minutes later and get different results.
 
Correct. You can run the query at any time, without locks, and you would do
no harm.

That is part of the fun in using Databases!
 
Back
Top