Using more than one database together

[lvensen]

For example, we developed a windows application using ms access database as
backend. The database will be full in a period of time (ie) the database
meets the maximum memory size. But i want to use that application
continuously. How to overcome this one? pls explain this...

 

[Norman Yuan]

Before considering moving to other DB server, such as SQL Server/Express, as
the other post suggested, just make sure that by "maximun momery size", it
should be physical file size on the hard drive disk: the file size for an
Access database file has a limite of 2G. There is no momery limit. Also, the
the database is subject to constantdata inserting and deleting, the file
size could be bloated, a regular database ompacting is often needed, which
not only trim the file size, but also makes the database working stable.

 

[Armen Stein]

Why not just download the free SQL Server Express and then upsize the backend
table to SQL Server? Then you dont have to deal with the maximum size
limitation.

SQL Server Express has a size limitation too (4GB).

2005:
http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx

2008:
http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx


Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[Tony Toews [MVP]]

For example, we developed a windows application using ms access database as
backend. The database will be full in a period of time (ie) the database
meets the maximum memory size. But i want to use that application
continuously. How to overcome this one? pls explain this...

To add to Norman's posting. What message are you getting? Is the
MDB hitting the 2 Gb size limit? Are you storing graphics in it?

Tony