troubleshooting Question

Small MDE is bloating in size?

Avatar of jrtool
jrtool asked on
Microsoft Access
5 Comments2 Solutions350 ViewsLast Modified:
Hi, I have a database that was made in Access 2000. I wanted to make an MDE of it so I had to convert it to Access 2003 and then made the MDE which turned out around 876 kb. This MDE is then put on a network drive where multiple users access it at different times. This db is also updated from another db on the same network drive by each user before each use. The update consists of a delete and append query. The problem I am having is this db grows in size to around 4 mb and the users complain of corrupt reports and so on. I am wondering where to look for the problem to this. The db should not grow that big after updates, the data is not changed by very much to explain this growth. Also a compact and repair makes little difference, the db still hovers around the 4 mb level. Thanks for any help. jrtool
ASKER CERTIFIED SOLUTION
Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 2 Answers and 5 Comments.
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>

Mike

Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 2 Answers and 5 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004