Ah – good to know.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, March 07, 2017 3:05 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: make table with a time stamp
Liz-
A Make Table should do the same bloat - assuming you are deleting the table after each use.
John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
(Paris, France)
On Mar 7, 2017, at 10:34 PM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Hey Bill. I totally do that if I weren't working with a situation that I'm working with a consultant on that is essentially building MRP with a LOT of data. So for the iterations, the delete/append was blowing the size up pretty heavy.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, March 07, 2017 2:29 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: make table with a time stamp
Liz - Instead of a Make Table, I usually keep the existing table and just delete the records before inserting new ones. That way I can put defaults in place, but your way will work just as well. You'll have to maintain the code while I just maintain the table structure. To each his own.
-Bill
Thanks Bill. Yes now() was the solution because we wanted to be assured of when data went in to the file precisely.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, March 07, 2017 1:42 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: make table with a time stamp
Liz - If you want date and time use:
WhenAdded: now()
If you only want a date use
WhenAdded: Date()
Pros, do you know how to create a timestamp on a make table?
Liz Ravenwood
<snip>
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.
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.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (8) |
Tidak ada komentar:
Posting Komentar