Hendra-
That's not absolutely necessary. During a compact and repair, Access will
delete all temporary objects. When you run a query - particularly a complex
one - Access will sometimes decide to save a "compiled" version of the query
to improve performance. If you scan TableDefs in code, you can find these
"temp" objects by looking for queries whose names start with ~sq. If you
delete all temp objects just before distributing the database, Access will
rebuild and save this "compiled" version the first time the user runs the
query.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
agesthahendra@ymail.com
Sent: Thursday, January 03, 2013 6:22 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Run all queries in FE before distribute the FE
(after compacting & repairing it)
Hi Everyone,... :)
When we have finished the developing of our application (FE), do we have to
run all queries in it before we distribute the FE (after compacting &
repairing)..? i read an article about this technique,..but is that really
important to do..? how if we have hundreds queries ? it need much times and
more patient to run all queries one by one...
Regards
Hendra Agestha
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar