A Card Swipe/ Gate Check Table....

[Bob Barnes]

W/ 2 or 3 Fields...

A...Any advantage to storing a Date only, and a Time Only
in 2 different Fields, or just using one Field...w/ Queries
to check the time of day of the Card Swipe?

B...If an Access Table has 3 Fields, how "big" (records)
can it get before it "sputters"...at least 200,000 ???

TIA - Bob

 

[scubadiver]

A) Personally, I would stay with one. You can use the formatting however you
like to get whatever date or time information you need. Check the help.

B) The recommended maximum memory is 2GB for a database. The number of
records will depend on the number of fields, forms and other stuff.

 

[Douglas J. Steele]

<picky>
B) The maximum size is 2GB for a database.
</picky>

It's not a recommendation: it's a physical limit.

That having been said, 200,000 records in a 3 field table is peanuts for
Access.

 

[Bob Barnes]

Thank you Doug.

I feel Access gets "bad-mouthed" when it shouldn't be.

 

[Bob Barnes]

Thank you scubadriver...

A) Personally, I would stay with one. You can use the formatting however you
like to get whatever date or time information you need. Check the help.

B) The recommended maximum memory is 2GB for a database. The number of
records will depend on the number of fields, forms and other stuff.

 

[scubadiver]

As far as the formatting is concerned, you can be *very* creative. I didn't
appreciate how flexible it can be.