Almost correct. The 2GB limit is on the entire database file, including
tables, reports, forms, macros, queries...
In theory, the maximum records in a table is around 2,000,000,000. But this
table would be a single column with a maximum of one character in each
record. This leaves a few bytes over for a form, report etc.
--
Ron Symonds (Microsoft MVP - FrontPage)
Reply only to group - emails will be deleted unread.
"Rob Giordano (aka: Crash Gordon®)" <
[email protected]>
wrote in message I thought there was a theoretical table size limit of about 2 gb in Access.
| Access specifications:
|
http://office.microsoft.com/en-us/assistance/HP051868081033.aspx
|
| No stated limit on number of records, but limits on what each record can
| contain, and overall limit on size of database.
|
| --
| Ron Symonds (Microsoft MVP - FrontPage)
| Reply only to group - emails will be deleted unread.
|
|
| | > One suggestion, but I don't know if you have the means to do it - server
| > requirements etc
| >
| > If you have MS Access, import the excel spreadsheet as the data
| > source/table to
| > an Access Database, then use the save as an mdb, then use the Database
| > Results
| > wizard in Frontpage to display the infomration from the Access DB in the
| > frontpage web You can then set up a search, pagination of the screens
(to
| > display
| > say 25 records per page rather than 5000 on one screen. However because
| > of the
| > volume of records Access *might* not cope with it, and you'd still have
| > the same
| > file-size problem.
| >
| > Mysql would (might) be better - although I've never used it myself.
| >
| > Access database & ASP reqiures ASP supported server, FP extensions, and
| > Access
| > Database enabled.
| >
| > Otherwise on Unix, I use scripts from
www.ezscripting.co.uk - very good
| > for
| > beginner developers.
| >
| > Perls scripts use flat-files - character (comma?) separated value files
| > (CSV =
| > plain ascii text).
| >
| > Anyway, you need to visit the site above to see if it might suit your
| > needs. They
| > offer a version of the scripts (for writing, reading, searching and
| > editing a
| > database with additional advanced scripts as well) and also a pay-for
| > version but
| > you get 5 scripts for $25 (US $ or equivalent Australian $$). pretty
good
| > value
| > really.
| >
| >
| > | >> I am new to Front Page and web development so I am in some real need of
| >> hands
| >> on experience that you might have.
| >>
| >> I have loaded a small file (some 150 records) from Excel to a page.
Front
| >> Page did an excellent job of converting these to a table and displaying
| >> them
| >> nicely. However, when I look at the file size for this page, it is just
| >> over
| >> 1mb which will certainly make it slow to access. Looking at the code
| >> generated, it appears to repeat the formatting for each record as
opposed
| >> to
| >> the file.
| >> The full file size will be some 5000 records so I need to find a better
| >> way
| >> of loading the data to a page.
| >>
| >> Can anyone advise me appropriate means of doing this.
| >>
| >> Your help would be much appreciated.
| >>
| >> Regards
| >> Cathy G.
| >
| >
|
|
