Database exploding in size!

[varich]

I've created an Access database with the tables on our SQL server. The database only has about 400 records so far, but the size of the .accdb file has grown to nearly 200 meg. The tables where the data is stored is on the SQL server, so I don't know why the .accdb file is growing uncontrollably. Any ideas? Did I turn something on somewhere?

 

[randy700]

Try doing a compact and repair.
This should eliminate any unused space.
The database will grow in size whenever you introduce a new object. Make-Table queries, for example.
During design time, this could happen a lot. Not so much later, but if it does, you can put a compact and repair command in your Close event.


Randy

 

[varich]

This database has issues. The database has a password. When I open the database, it asks for the password. I put the password in, and the database opens. Then I try to do a compact and repair and it asks for the password. I type the password, and it tells me it’s the wrong password. Of course, it’s not wrong password. Then I try to turn off the database encryption. It asks for the password and asks for a verify password. I put the password in, and it tells me it’s the wrong password. Of course, it’s not the wrong password. What is going on with this database?

 

[Hap007]

I would suggest creating a brand new, blank database.
Then, import all of the elements from the original DB.

Then, open up a code window and compile the new database.

Now, try using the newly created Access Database.

Hope This Helps,
Hap...


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121