N
Nandini
I designed an access database using Access 2003. The limit of the capacity of
access database is 2 GB. But my database size is yet to be increased very
soon more than 2 GB. So I splitted the database into backend and frontend.
Backend is kept in sql server. For this sql server 2005 express edition is
used. Backend database contains only tables and the frontend database
contains rest of the objects like queries, forms, reports etc. I want to know
whether the jet database engine can functions properly if the size of
database crosses the limit of 2 GB. If it cant do so, what should I do. Early
response would be very much helpful.
With regards,
access database is 2 GB. But my database size is yet to be increased very
soon more than 2 GB. So I splitted the database into backend and frontend.
Backend is kept in sql server. For this sql server 2005 express edition is
used. Backend database contains only tables and the frontend database
contains rest of the objects like queries, forms, reports etc. I want to know
whether the jet database engine can functions properly if the size of
database crosses the limit of 2 GB. If it cant do so, what should I do. Early
response would be very much helpful.
With regards,