Using more than one database together

L

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...
 
N

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.
 
T

Tony Toews [MVP]

lvensen said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top