One disadvantage of this is that append queries can cause back end bloat.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of wrmosca@comcast.net
Sent: Monday, January 06, 2014 1:01 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] VBA Code is missing
Jim
If you want a centralized place to share these tables with everyone and have one person (or group) responsible for generating these temp tables then I would change the processes to delete existing records and append the new ones. That way you could keep the links to the tables and keep them in the back end.
Bill
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (38) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar