ah, I see thanks!
| 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.
| | >
| | >
| |
| |
|
|
