M
Matt
Are there any articles that compare Archiving vs Archiving. What are
the thoughts in the group?
the thoughts in the group?
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tony Toews [MVP]
Matt said:Are there any articles that compare Archiving vs Archiving. What are
the thoughts in the group?
Archiving older data to another MDB? Unless you're close to the 2 Gb
limit don't bother. Performance on large tables in Access is very
good so long as proper indexing on criteria and sorting fields is in
place.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
M
Matt
Archiving older data to another MDB? Unless you're close to the 2 Gb
limit don't bother. Performance on large tables in Access is very
good so long as proper indexing on criteria and sorting fields is in
place.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
I am close to 2gb ... does this mean I must archive?
T
Tony Toews [MVP]
Matt said:I am close to 2gb ... does this mean I must archive?
2 Gb is the largest size possible for Access MDBs so you're going to
need to figure something out before you hit that limit.
But 2 Gb is quite large. Do you have any graphics in the MDBs? Or do
you have millions of records in tables?
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
M
Matt
2 Gb is the largest size possible for Access MDBs so you're going to
need to figure something out before you hit that limit.
But 2 Gb is quite large. Do you have any graphics in the MDBs? Or do
you have millions of records in tables?
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
Millions of records ... also we have a current outstanding work table
that deletes and re-appends approx 15000 records per hour ... so that
gets big pretty quick. A compact and repair is done weekly, but it
only takes it down to about 700 MB (and rising). I see us hitting 2GB
in about a year. Just trying to be prepared before that happens.
D
Douglas J. Steele
Matt said:Millions of records ... also we have a current outstanding work table
that deletes and re-appends approx 15000 records per hour ... so that
gets big pretty quick. A compact and repair is done weekly, but it
only takes it down to about 700 MB (and rising). I see us hitting 2GB
in about a year. Just trying to be prepared before that happens.
You might consider using a temporary database for your work table.
See what Tony has at http://www.granite.ab.ca/access/temptables.htm for an
example.
T
Tony Toews [MVP]
Matt said:Millions of records ...
Reasonable enough.
also we have a current outstanding work table
that deletes and re-appends approx 15000 records per hour ... so that
gets big pretty quick.
See what Doug said about Temp Tables. said:A compact and repair is done weekly, but it
only takes it down to about 700 MB (and rising). I see us hitting 2GB
in about a year. Just trying to be prepared before that happens.
Ah, we like to see people who are thinking ahead. <smile>
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
T
Tony Toews [MVP]
Matt said:Millions of records ...
I would then wonder if you should be considering SQL Server (or
equivalent) because you have a mission critical system. That is your
business depends on it and having to go back to last nights backup
should something happen would mean losing lots of business.
I'm thinking of call centre applications to be specific such as hotel
reservations or taking phone orders. Losing a whole days of hotel
reservations would cause a huge amount of grief and misery for your
front desk staff who have to tell folks that sorry you don't have a
room because the computer burped.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
M
Matt
I would then wonder if you should be considering SQL Server (or
equivalent) because you have a mission critical system. That is your
business depends on it and having to go back to last nights backup
should something happen would mean losing lots of business.
I'm thinking of call centre applications to be specific such as hotel
reservations or taking phone orders. Losing a whole days of hotel
reservations would cause a huge amount of grief and misery for your
front desk staff who have to tell folks that sorry you don't have a
room because the computer burped.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
It is actually a Call Center/Processing Metrics Database. We have
upwards of 300 processors and CSR's, and this database that stores
their metrics. We will never lose sales for this database, just sleep.
T
Tony Toews [MVP]
Tony Toews said:I'm thinking of call centre applications to be specific such as hotel
reservations or taking phone orders.
Just to clarify this for lurkers. A call center application is just
one of many different situations where the data should not be kept in
MS Access. Front end in Access is just fine of course.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
T
Tony Toews [MVP]
Matt said:It is actually a Call Center/Processing Metrics Database. We have
upwards of 300 processors and CSR's, and this database that stores
their metrics. We will never lose sales for this database, just sleep.
<smile> Then it's your corporate decision on how much sleep you would
lose.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
M
Matt
I wish it were my decision ... I have been lobbying for a SQL Server
database for awhile now ... I work for a company that is
technologically stuck in 1998 and the only thins they know about SQL
server is that it costs ... Access is already bought and paid for.
I will be compacting and repairing for life!
database for awhile now ... I work for a company that is
technologically stuck in 1998 and the only thins they know about SQL
server is that it costs ... Access is already bought and paid for.
I will be compacting and repairing for life!
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.