Re: Date format

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 07/20/04 

Date: Tue, 20 Jul 2004 13:10:30 -0500

Check Help for the Access specifications for the "official" answers/limits.
The actual sizes and numbers will vary depending on the number of users and
lots of other factors. I know of several apps with millions of records that
run reliably and other apps with hundreds that seem slow. 

-- 
Duane Hookom
MS Access MVP
"James" <anonymous@discussions.microsoft.com> wrote in message
news:07a201c46e5d$3f959cc0$a401280a@phx.gbl...
> many thanks for your reply, I think I will have to stick
> to text format.
>
> Few more questions, I'm building a database not my first
> but just a couple of questions:
>
> How many fields can a table have before it becomes too
> big or slow?
>
> How many tables can a Access database have before it
> becomes slow?
>
> How big MB/records can a database be?
>
> Many thanks.
> >-----Original Message-----
> >I would never change regional settings for all Windows
> applications to make
> >one app "maybe" run properly. A date field must store
> the day of the month.
> >
> >-- 
> >Duane Hookom
> >MS Access MVP
> >
> >
> >"Theo" <Theo@discussions.microsoft.com> wrote in message
> >news:2B9F74A5-C071-4AD6-8C9D-
> 912312556441@microsoft.com...
> >> Try This:
> >> Go to Control Panel.
> >> Click on Regional Settings.
> >> Select "Date" Tab (Top Right)
> >> Change the Short Date format to 'MM/yy'
> >> Remember to use capital letters for month, 'mm' refers
> to minutes
> >>
> >> "James" wrote:
> >>
> >> > Hello
> >> >
> >> > Im trying to create a field that displays date like
> on a
> >> > credit card mm/yy. This is not a problem, but when
> >> > entering the date in this format the field thinks
> you are
> >> > entering in dd/mm/yy so for example, I want to enter
> a
> >> > date as October 2005 so I type 08/05 but then the
> system
> >> > changes is to 05/04!! I have tried a custom format
> under
> >> > date/time and have made a input mask but it always
> does
> >> > it.
> >> >
> >> > Please help!
> >> >
> >> > Many thanks James.
> >> >
> >
> >
> >.
> >

Relevant Pages

  • Re: Collecting data in MS Outlook
    ... In addition User Level Security is not supported in the new format. ... When I was converting my database, ... The link you showed only uses Microsoft Outlook 2007 and Microsoft Access ... Dim fdrInBox As Outlook.MAPIFolder ...
    (microsoft.public.access.security)
  • Re: Collecting data in MS Outlook
    ... a 3rd possibility is to not convert to the new format. ... easier is a product written to work with Outlook called Easy Survey: ... responses into an Access 2000 format database. ... Dim fdrInBox As Outlook.MAPIFolder ...
    (microsoft.public.access.security)
  • Re: Simples Rules make creating Big Balls of Mud impossible.
    ... excellent bracing internal test framework. ... other almost entirely thru the database. ... villages (apps). ... the internals of an object may leverage the stuff in other layers ...
    (comp.object)
  • Re: Protel 2004 answer to Brad Velander.
    ... Sorry, you misunderstand me, I mean to say that jump from 99SE to 2004 XP ... you don't have the same format with one database will all the documents. ... Well you said that you can export file format more recent than AUTOCAD 14 ... key/mouse click you press because I don't know how to do that with Protel ...
    (sci.electronics.cad)
  • Re: Open challenge to Fa-Goon
    ... world where all apps are written to read from, and write to, a single ... Each document would be a database entry, ... local database, in a flat file, in the cloud, etc.). ... API calls, and the code implementing the API would worry about those ...
    (comp.sys.mac.advocacy)