database size increase

[Guest]

I have an Access 2002 datase linked to an SQL backend. We have been having
problems lately with the database getting corrupted. It is on a shared drive
with about 10-15 users accessing it. We have been repairing it on an almost
daily basis. Also and very puzzling the size will dramaticaly increase, in
a 2 day period the size went from 5.768 MB to 4 Gig. And when I tried to
open it, it was an unrecognized database. What will cause this and how can
we fix it.

 

[Douglas J. Steele]

I'm not surprised it won't open: the maximum size for an MDB file is 2 Gb.

You should not be sharing the database. Each user should have his/her own
copy of the database, ideally on his/her hard drive.

 

[aaron.kempf]

you need to get rid of MDB; ADP works great with large datasets

you do not need a front end / back end

you just need an Access Data Project

start MSACCESS, file, new, PROJECT (existing data)

hope that helps; I feel bad for you

but MDB is for ****ing retards that don't know how to spell SQL

 

[Guest]

I agree that the best option woud be to have a copy of the database on each
users workstation...However, until you have the time/resources to do this,
you may want to try auto-compating the database on close. Open your database
and go to your "Tools" menu and select "Options". From the "Options" window,
select the "General" tab and make sure that the "Compact on Close" option is
checked. This might help keep the file size under the 2gb limit and prevent
it from getting corrupted until you can distribute the file to all of your
users.

 

[Tony Toews [MVP]]

I have an Access 2002 datase linked to an SQL backend. We have been having
problems lately with the database getting corrupted. It is on a shared drive
with about 10-15 users accessing it. We have been repairing it on an almost
daily basis. Also and very puzzling the size will dramaticaly increase, in
a 2 day period the size went from 5.768 MB to 4 Gig. And when I tried to
open it, it was an unrecognized database. What will cause this and how can
we fix it.

Each user should have thier own copy of the FE.

I specifically created the Auto FE Updater utility so that I could
make changes to the FE MDE as often as I wanted and be quite confident
that the next time someone went to run the app that it would pull in
the latest version. For more info on the errors or the Auto FE
Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the
FE on each PC up to date.

In a Terminal Server or Citrix environment the Auto FE Updater now
supports creating a directory named after the user on a server. Given
a choice put the FE on the Citrix server to reduce network traffic and
to avoid having to load objects over the network which can be somewhat
sluggish.

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

 

[Guest]

I agree, but when changes are made we must go to each desktop and insure the
change is made. I have over 100 users that utilize this database. The size
should not increase dramatically because all the data is in the back end SQL.
I have been using this program since 1988 and have not had this problem
before, even when I had an ACCESS database prior to the SQL conversion.

 

[Tony Toews [MVP]]

I agree, but when changes are made we must go to each desktop and insure the
change is made. I have over 100 users that utilize this database.

I'd suggest reading my reply again

The size
should not increase dramatically because all the data is in the back end SQL.
I have been using this program since 1988 and have not had this problem
before, even when I had an ACCESS database prior to the SQL conversion.

You've been lucky to never have this problem. Although Access 97 and
earlier appears to have been much less susceptible to this problem.

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