473,322 Members | 1,480 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

MS Access Database File Size smaller then previous version

I am novice to MS Access Development,
I regularly back my access database every 2, 3 days ...today when I was
going to back my database I saw the access file on the network drive was only

9 MB in size, while the backup files that I had saved few days back were 258

MB in size.

And the network drive is where the database is saved on.
Can anyone suggest something why or how I can track what happend or a way to
compare the backup database with the new database to see where they differ..
how to compare table size or forms size in the 2 database, anyone aware of
any bugs that could cuz a sudden change in the Access Database size?

Appriciate all your input.

Thanks
Knick

--
Knick

Message posted via http://www.accessmonster.com

Aug 22 '06 #1
3 7113
Bri

Knick via AccessMonster.com wrote:
I am novice to MS Access Development,
I regularly back my access database every 2, 3 days ...today when I was
going to back my database I saw the access file on the network drive was only

9 MB in size, while the backup files that I had saved few days back were 258

MB in size.

And the network drive is where the database is saved on.
Can anyone suggest something why or how I can track what happend or a way to
compare the backup database with the new database to see where they differ..
how to compare table size or forms size in the 2 database, anyone aware of
any bugs that could cuz a sudden change in the Access Database size?

Appriciate all your input.

Thanks
Knick
A database will shrink if you do:
Tools - Database Utilities - Compact Database

This removes temporary objects and deleted objects/records.

The size change you have here is very large. Did the file grow from
around 9 MB up to the 258 MB? Are the tables in their own MDB or are
they with the Forms, Queries and Reports?

To compare the current one to the backup, you could open both up and
look at the record counts of the tables and see if they are comparible.

--
Bri

Aug 22 '06 #2
Bri
I was trying to figure out what happened, if someone tampered with the
existing db... file is on the network drive, the older copies of the db was
258 MB and then today when i was making a back i saw a small file,which was
only 9 MB ... Since it resides on the network their are many who have access
to it... Although I have back copies of it I wanted to see if there was any
way to track when was the last update or modification occure ...

Comparing the two databases backup and the original they both seem to have
the same number of records... Yes the database has forms, Queries, VBA code
Modules and Reports. Tables are with the Form queries and modules

so far I am unable to find any difference...
Thanks for you help
Knick

--
Knick

Message posted via http://www.accessmonster.com

Aug 23 '06 #3
Bri

Knick via AccessMonster.com wrote:
Bri
I was trying to figure out what happened, if someone tampered with the
existing db... file is on the network drive, the older copies of the db was
258 MB and then today when i was making a back i saw a small file,which was
only 9 MB ... Since it resides on the network their are many who have access
to it... Although I have back copies of it I wanted to see if there was any
way to track when was the last update or modification occure ...

Comparing the two databases backup and the original they both seem to have
the same number of records... Yes the database has forms, Queries, VBA code
Modules and Reports. Tables are with the Form queries and modules

so far I am unable to find any difference...
Thanks for you help
Knick
If you can't find any differences then perhaps it is just that someone
compacted the DB. Compacting is a GOOD idea to do regularly. So is
splitting the tables into their own DB. Then you can give each user
their own copy of the application part. This can solve a lot of
potential problems. There is a wizard to help you with doing this. Read
the Help on it first so you understand what is happening.

Your size difference is significant. This could be because of several
reasons; Lots of edits to forms or reports, use of temp tables, embedded
images in forms or reports, lots of table structure modifications, never
been compacted before, etc.

--
Bri

Aug 23 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Êþóôáò ×ýôáò | last post by:
Hello!!! Can i add a user control in Access database file (mdb)? I want to make o form in an mdb file and i want to add my button. Hope You can help me. Thanks
2
by: CLarkou | last post by:
My program developed in Access 2003 includes 2 MDE files. Both of them are signed with VeriSign certificate. Program was installed on 2 client machines with Office 2003. One of the machines...
17
by: shineofleo | last post by:
Here is the situation: I wrote a VB programm, which stores all the information in a single Access database file using jet engine. It worked well, however one of my customs reported that there was...
7
by: Kosmos | last post by:
Hey guys, I was hoping someone could give me an idea of where I should look for this..my access database file is rapidly growing....but I have the access database import an excel spreadsheet and...
5
by: John | last post by:
Hi I have a typical front end/back end access app. Additionally a vb.net app accesses the backend mdb file every few minutes and runs insert and update queries on some table. The data to be...
4
by: gpl666666 | last post by:
Does anyone know any free online space which allows user to upload mdb Access database file?
1
by: soniasherry | last post by:
Can I please get some guidance.I'm new to MSACCESS 2003 How do I update all the tables in a main access database file with around 50 tables with unique records from similar tables placed in...
4
by: manishpo | last post by:
Hi Do any one know how to convert the structred wordocument contents to Access database file using C++ script. Do I have to use word document model for in MFC. if yes then how. Thanks ...
1
by: saifulislam | last post by:
Hi All, i m a network administrator in a multinational firm. i m facing a problem while accessing an access databse file in the LAN. We have our database file where different employees make...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.