Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Access question
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Access question
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. "RollieG" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Access question
Yes, this is a select query in Access (2003).
"Sean Timmons" wrote: 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. "RollieG" wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Access question
Yes, this is an Access select query.
"Sean Timmons" wrote: 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. "RollieG" wrote: 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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Access question
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! "RollieG" wrote: Yes, this is a select query in Access (2003). "Sean Timmons" wrote: 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. "RollieG" wrote: 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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Access question
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. "Sean Timmons" wrote: 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! "RollieG" wrote: Yes, this is a select query in Access (2003). "Sean Timmons" wrote: 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. "RollieG" wrote: 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? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Access question
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! "RollieG" wrote: 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. "Sean Timmons" wrote: 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! "RollieG" wrote: Yes, this is a select query in Access (2003). "Sean Timmons" wrote: 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. "RollieG" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Access to Excel Question | Excel Discussion (Misc queries) | |||
Secondary Access Question | Charts and Charting in Excel | |||
Macro Question - Excel to Access and back again | Excel Discussion (Misc queries) | |||
Access Form In An Access Report (SubForm) Question | Links and Linking in Excel | |||
Conditional Worksheet Access Question | Excel Worksheet Functions |