None that I know of. However, if you are going to use them for web
development, don't go over 20MB, at least IMHO
Dan Phillips
CFXHosting.com
-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 10:38 AM
To: CF-Talk
Subject: Access2000 file size l
ou better compact
it frequently. Realistically, if you are already concerned about file size,
then access is probably not the best choice in any case...
-Original Message-
From: Dan Phillips [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:36 AM
To: CF-Talk
Subject: RE: Access2
: Access2000 file size limits?
None that I know of. However, if you are going to use them for web
development, don't go over 20MB, at least IMHO
Dan Phillips
CFXHosting.com
-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 10:38 AM
To: CF-Talk
Su
Green [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 10:57 AM
To: CF-Talk
Subject: RE: Access2000 file size limits?
hehehe,
Your gonna love this then :)
Im using Access for temp storage of some dynamically generated code, Im
approaching 400mb access .mdb file ;)
jeff
-Original
AM
To: CF-Talk
Subject: RE: Access2000 file size limits?
hehehe,
Your gonna love this then :)
Im using Access for temp storage of some dynamically generated code, Im
approaching 400mb access .mdb file ;)
jeff
-Original Message-
From: Dan Phillips [mailto:[EMAIL PROTECTED]]
Sent: Tues
My 23MB Access2000 database is still holding up ok... it starts to choke
when more than 60 people at a time are browsing the site but is ok around
50..
.I know.. time to upgrade :-)
> Was wondering what file size limits Access2000 DB have?
>
___
>From Access 2000 help:
Max Database size: 2GB.
Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org
-Original Message-
From: Joseph Thompson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 1:04 PM
To: CF-Talk
Subject: Re: Access2000 file size limits?
My 2
I think I saw something about 2 gigs. 400mb..that is nothing...I have a
database that is 908mb!!!
joel
-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:57 AM
To: CF-Talk
Subject: RE: Access2000 file size limits?
hehehe,
Your gonna
Jeff Green wrote:
> Was wondering what file size limits Access2000 DB have?
Min(2 GB, max file size of your file system)
Jochem
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependabl
I would imagine that the hard limit depends on the file system that the DB sits on - 2
GB for FAT, etc...
Practically, it's a very bad idea to have an Access DB anywhere near this size. We
have a number of databases that are in the several hundred megabyte range - it's not
something I like or
> Was wondering what file size limits Access2000 DB have?
I believe that the maximum file size is 2 Gb. I've actually seen files
nearly that large being used in CF applications (1.8 Gb or so).
Interestingly enough, the file size by itself doesn't necessarily make that
much of a performance differ
That's one of the big problems. If the databases get that large, especially with a
large number of concurrent users, you need to be diligent in making sure that you
perform manual "compact and repair" operations on the database.
There are free alternatives, don't use Access unless you must.
haven't tried it yet...Macromedia has a custom tag called CF_Compact that claims to
let you compact an Access db remotely.
- Original Message -
From: Kevin Miller
To: CF-Talk
Sent: Tuesday, April 09, 2002 5:17 PM
Subject: RE: Access2000 file size limits?
That
oops..sorry, Jochem. CF_Compact is available at http://www.cfcomet.com/cfcomet/
author: Jochem van Dieten
- Original Message -
From: Dina Hess
To: CF-Talk
Sent: Tuesday, April 09, 2002 11:05 PM
Subject: Re: Access2000 file size limits?
haven't tried it yet...Macro
Access is good for quick and dirty database design especially for testing.
Then "upsize it" to SQL Server (if you have it).
Enterprise Manager can then be used to make adjustments to the SQL database.
Haven't used Access XP yet but it's probably even better.
>>Snip<<
There are free alterna
15 matches
Mail list logo
