Re: Acess 2000 File Limitations 1

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Graham R Seach (gseach_at_NOSPAMpacificdb.com.au)
Date: 08/10/04 

Date: Tue, 10 Aug 2004 13:27:25 +1000

"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

"D Stretton" <DStretton@discussions.microsoft.com> wrote in message
news:C7EA8F91-A1C8-4AB4-A6C8-B782A4D08F1C@microsoft.com...
> 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
>
>
> "Graham R Seach" wrote:
>
> > 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
> >
> >
> > "HAze" <shizhen25@hotmail.com> wrote in message
> > news:2d23d01c46a1c$dbf34bc0$a401280a@phx.gbl...
> > > 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.
> > >
> > >
> > >
> >
> >
> >

Relevant Pages

  • Re: Split Database Security Problem
    ... Both frontend and backend ... > permissions, but as in all good stories there is a catch. ... The newAdmin for the 'object database' has the ...
    (comp.databases.ms-access)
  • RE: 5 access 2000 users and 1 AccessXP user
    ... I, too, have a split database with the backend on a server. ... > This is then followed by a message to the effect that the mde is corrupted. ...
    (microsoft.public.access.conversion)
  • RE: Form on front end loading slowly
    ... I gather the user has a frontend that uses a backend database on a server ... > have a database backend with a table that lists employees, ...
    (microsoft.public.access.formscoding)
  • Re: Split Database Security Problem
    ... Both frontend and backend ... > permissions, but as in all good stories there is a catch. ... The newAdmin for the 'object database' has the ...
    (comp.databases.ms-access)
  • Re: Multi users Logon Security questions
    ... > The next thing I need to do is split the database so others can work ... and navigate to the mdb - copy the mdb. ... You can use your desktop shortcut (which will open your frontend). ... Ctrl-O and open the backend mdb. ...
    (microsoft.public.access.security)