Acess 2000 File Limitations 1

  • Thread starter Thread starter HAze
  • Start date Start date
H

HAze

Hi:


I would like to check;
Are there any limitations to the no. of records that
Access 2000 can hadle in a single file??
Please indicate the max.no. of records that Access 2000
can handle.
 
No, there are no limitations on the number of records, however, Access 2000
databases are restricted to a maximum 2GB file size.

You can get around this by creating multiple backends (to contain the
tables), which can be linked to the frontend. In this way, the effective
database size is limited only by the size of your hard disk.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
 
Can you please explain what you mean by backends and frontend and how you go
about doing this? In my case the database is on a 'server' and therefore is
(presumably) not limited to the size of my hard disk but to a limiting factor
to do with the server.

Many thanks
 
"Frontend" and "Backend" are terms used to describe two of the fundamental
parts of a database software system. In the case of Access, the "frontend"
is a normal Access database file (*.mdb) that contains all the forms,
reports, queries, macros and so on. The "backend" is a standard Access
database file (*.mdb) that contains only tables. The backend is sometimes
referred to as the "data store", because it "stores" the data.

If you don't have a "split" database, you can split it by selecting Tools |
Database Utilities | Database Splitter.

Once you split the database, you can place the "backend" on a server share,
so it is accessible to everyone. Each user would then normally have a
"frontend" installed on their workstation; one frontend per user. It is not
good practice to have a single frontend stored on a server and used by
multiple users.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
 
Back
Top