over limit for access

  • Thread starter Thread starter jas
  • Start date Start date
J

jas

If our databases have surpassed the limits of access,
what should we do? It has been suggested that we go to a
Database server with SQL or Oracle. Our IT dept says that
if we go with Oracle we will need to hire a full time
employee just to manage that database? Can anyone give me
some facts on what my be the best way to go? Thank you
very much.
 
If you go to a server based system, you will undoubtedly need an
administrator. Most Oracle databases do require a full-time admin.
SQL-Server will still need an admin, but in most smaller systems he/she
won't need to be full time. The practical limit of a well-designed Access
database is between 500 MB and about 1.5 GBs based on the intensity of usage
and robustness of the network. I have worked on far bigger systems which
were cobbled together, but I wouldn't recommend it.

Unless you are producing a phone book for a major city, or the retail sales
records of a large store, it is rare that a well maintained database is much
over a few hundred MBs, well within Access's limits.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
If our databases have surpassed the limits of access,
what should we do? It has been suggested that we go to a
Database server with SQL or Oracle. Our IT dept says that
if we go with Oracle we will need to hire a full time
employee just to manage that database? Can anyone give me
some facts on what my be the best way to go? Thank you
very much.
Click to expand...

Are you in fact over the limit (of 2 GByte per Access .mdb file) with
real data? How many records in your largest table? Do you regularly
use Tools... Database Utilities... Compact to compact the database?
Are you storing graphical images in the database (Access is horribly
inefficient at doing so)?

Apologies if these questions are overly elementary but as Sherlock
Holmes said, "one should never overlook the simple solution"...
 
Our databases are not over 2 Gbytes. We are using the
software Roadnet 5000. This is a mapping/routing software
created by UPS.
I had to send my .mdbs to UPS so that they could repair
them. They had to repair a "temp disc error" and compact
our databases. Each time we save our files it
asks us if we want to compact our database and we do.
That particular database was 2,000,000+ KBs. Technical
support made repairs and it became 500,000+kbs.
UPS is telling us we may want to go to SQL or Oracle.
Just not sure if this is our best option. Your questions
are not elementary as I do not know squat about Access.
Thank you very much for all of your help.
 
Back
Top