How Can I Compact Access Database?

Dec 28, 2004

To Everyone

My access database grow exponentially to 170 MB, We share the access database on the network and those tables on
the access database are linked to SQL Server. I tried to compact and converted to 2003 format, It still doesn't shrink too much for the size. Please someone tell me what should I do for it, because someone try to access thur the VPN connect, and it make no sense for her to take 5 mins for loading a report remotely.

Timothy

View Replies


ADVERTISEMENT

General :: Access 2013 - Compact Database To New Name

Jan 30, 2015

Access 2013 ... Is it possible to compact a database to a new name?

(In previous incarnations of Access I regularly 'compacted and repaired' databases to USB sticks rather than simply copy the file in the (mistaken??) belief that this was a more reliable approach)...

I can't see where to do this in Access 2013!

View 1 Replies View Related

Modules & VBA :: Compact And Close Database With Delay - Access 2007

Feb 12, 2014

"how to COMPACT the DB by introducing delay of 10 seconds and then close the DB".In the Database, I'm able to accomplish the "Compact" the database using the function below.

Function Compact()
SendKeys "%(FMC)", False
End Function

As my DB is quite huge, the Compact action takes around 10 seconds to complete.Now, i would like to Close the Database after Compacting the DB. I tried including "DoCmd.Quit" in the function. The commands in the function, closes the DB but the Compact function doesn't seem to have executed as it needs 10 seconds to complete.

Function Compact()
SendKeys "%(FMC)", False
DoCmd.Quit
End Function

how to introduce this delay of 10 seconds and then close the DB.

View 3 Replies View Related

Cannot Compact A Database

Mar 2, 2006

I know this has been discussed before but I have not been able to find a solution for my problem.

I have a database with linked tables from the back end database. The normal size is about 4.5 mb but after doing some work on a fairly simple form and a function with Select Case statements and simple SQL (the SQL was here before that change) the size has risen to 33Mb. This actually doubled to 66Mb earlier today after a very minor change but did compact back to 33Mb.

I have the Jet Compact Utility to no aval. I have tried creating a new database and imported all the objects from the original but again to no avail.

Help please???

Kevin

View 2 Replies View Related

Database Won't Compact

Aug 10, 2006

I have an access 2000 database, which we copied from it's original location to another computer. I now am trying to modify/update the file, and have discovered an unusual problem. The filesize is roughly 75 megs! It is not a huge database, the biggest table has 2200 entries x maybe 8 fields.

There apparently had been corruption in the 2200 line table, as when I first looked into it, it had something like 275,000 rows. So I deleted back to the 2200 "good" rows of data. Figured I had the filesize problem fixed. But it won't shrink. Tried compact/repair and it didnt help. Crunched data for a long time, seemed to be working, but the filesize turns out nearly the same.

I then created a new database, and imported all of the info from the "big" one. Filesize = 1.5 meg. Great! not really. I cant get any of the code to copy over and I am not a VBA guy. All of the form buttons return error messages, and when I look into the event procedures there is no code. I tried copying all that code over, and it appears to have copied, but it doesnt work.

Maybe someone out there can offer suggestions? Thanks, Harry Manvel

View 1 Replies View Related

Compact And Repair Database

Jan 31, 2006

Hi,

I was wondering if anyone might be able to help me. What i'd like to do is to be able to get the access to trigger compact and repair database tool automatically just before it shuts. Is it feasible? or has to be done manually?

Thank you in advance

View 2 Replies View Related

Unable To Compact Database

Aug 22, 2006

Hi,

I have created a database with approx ten tables with many queries (make table and append and delete queries). I need to compact this database as I would normally do (usually deal with databases of 500MB and more with no issue) however after over an hour I still get the message 'not responding'. I have tried creating a new one from scrath and get the same issue. Can anyone help please?

View 3 Replies View Related

Compact And Repair Database

Apr 17, 2007

The compact and repair utility is very good.
Since all my record operations are done through menu, I would like to put a command button for this utility also. But I dont know how to do this. Would somebody help? Thanks in advance.

View 2 Replies View Related

Compact Secured Database

Jan 31, 2008

I am trying to compact & repair a secured database. I log in exclusively as the administrator with the following shortcut property target: "C:Program FilesMicrosoft OfficeOFFICE11MSACCESS.EXE" f:pathnameappname.mdb /User "adminname" /Pwd "adminpwd" /wrkgrp f:pathnameappname.mdw /excl

When I run Compact & Repair, I get the following message: "Microsoft Office Access can't delete f:pathnameappname.mdb after compacting it. The compacted database has been named f:pathnamedb1.mdb."

It goes on to say that it can't delete the original database because it is read-only (even though it is not).

Can I compact a secured database manually, or does it require some sort of utility?

Thanks.

View 5 Replies View Related

Compact And Repair Database

Mar 17, 2008

Hi all,

I ahve come across a small problem and i am wandering if someone can helo me out on this.
I have a programme which is for the fast food and uses a order no for each receipt, now the problem is each time the form is closed and opened the number goes to the next avaialable number so last nunber was 32 the next will be 33 etc this number adding is done by code but i am having a problem somewhere along the lines and it goes back to 1 every so often, so the you have to log off and log in to to to the next available record,

So i was thinking rather having to do the number increment by code why not have a auto number field in there instead, the only problem is at the end of the day the number should go back to 1 for the next day so is there a way to compact and repair the database or better still to zero the tables i wish??

Thank you

Regards
Naym

View 2 Replies View Related

How To Compact Database Automatic ?

Nov 18, 2004

HI,

Is there anyone out there that knows if it is possible in any way to make a database compact automatic at a certain time. If someone (user) has forgotten to close the database, automatic gets thrown out and then it compacts itself ?

View 5 Replies View Related

Unable To Compact Database

Mar 14, 2005

Hello All,

I have found myself with a big problem, One of my databases has managed to become rather large in size, 1,084,576kb

Unfortunatley i am unable to compact the database, as i get the following error on compact "record(s) can't be read; no read permission on L:database name"

The size of the database now seems to be the reason why reports and queries are failing,

I have tried "database utilities" Repair Database - and this has no affect.
I have also tried temporally removing some of the tables and queries into another database, but the Db size remains the same.

Does anyone have any ideas as i'm stumped? p.s. the database in running on ACCESS 97

Thanks and best regards

Aaron

View 3 Replies View Related

Compact And Reoair Database

Jan 6, 2006

i have a database that is 12 megabytes. when i compact and repair it, the database is 6 megabytes.

am i losing information? is there anything bad about compact and repaiir?
my database seems normal after the compact and repairt, but i would like to confirm weather or not compacting makes the database lose info

View 3 Replies View Related

Compact And Repair Upon Closing A Database

Aug 3, 2007

Is it possible to make the database compact and repair itself when it is closed to prevent it becoming too large?

Alternatively, can you create a macro to compact and repair at the click of a button?

Thanks, Steve

View 2 Replies View Related

Database - Automatically Compact And Repair

Feb 9, 2008

Can anyone give me guidance or code on how to automatically compact and repair.

There is something going on in my database when I open and it goes from 3.7kb to 26 kb each time it is opened - I cant find out why - ope to the why suggestion but another option is to automatically compact and repair

Thanks in anticipation.

Humph

View 2 Replies View Related

General :: Database Auto Compact On Idle

Nov 9, 2012

In my access applications i have used the database split built in functionallity to split my frontend and backend tables.I have created a mail mechanism and when the database grows to that level i recieve a mail, ask users to get out of the database and compact the database. But this is tiding. I have a scheduled job that compacts databases early in the morning before users logged on. But during day work databases grow enormous again. Well is there a way by VBA code to create an auto compact function that on idle will log off all users in the database and compact it?

View 2 Replies View Related

How To Compact Ms Access 2000 In Vba Code

Sep 28, 2005

Hi,

Does anyone know how to compact a ms access 2000 db in vba code. I want the database to compact evertime it is opened up.

Thanks

View 2 Replies View Related

Access 2007 - Compact And Repair Feature

Dec 30, 2007

Does anyone know where the Compact and Repair feature is to be found in Access 2007? It was on the Tools menu in Access 2003, but I can't find it in 2007!

Thanks,

Gary

View 1 Replies View Related

Compact Access 2000 From A Batch File

Apr 14, 2008

Hi All

I am looking to find some code that I can use in a batch file to compact an Access 2000 database that has a database password set on it.

I know about "C:WIPSPOCOneCall_BE.mdb" /compact but need to find a way to pass it the password. What it does at the moment is open and waits for the password to be entered, and then it just opens.

I am looking to set up a scheduled task so that the database gets compacted every night.

Any ideas?

Cheers.

View 4 Replies View Related

Compact And Repair Messes With User Access

Mar 2, 2005

Hello,

I am trying to do a compact and repair on my database but when I do that I find that my database which is on the server is not recognized by the 9 other client machines.

My shortcut which uses a workgroup file is on each machine and was working fine until yesterday. Once I perform a compact and repair the clients say that they cannot find the file on the server.

Howcome the compact and repair operation is screwing up with the accessibility of the file?

Please advise.

Thanks,

View 1 Replies View Related

Can You Compact On Close In Access 2000 Runtime?

Jan 4, 2006

Can you compact on close in an access 2000 runtime enviorment?

Also, if i select the option to compact on close will it work on every computer i copy this database to? Or is it a property of that computer?

View 1 Replies View Related

General :: How To Use Access 2010 Setting Compact On Close

Apr 17, 2013

How would I use the Access 2010 setting, 'Compact on close'?We have a back end on a server and many users with front ends on their computers. So would I set 'Compact on close' on the back end? And then it would compact when the last user logged out?

View 3 Replies View Related

General :: Rightclick Menu In Explorer - Compact Or Decompile Access File

Sep 24, 2012

I am looking for a registry setting or .reg file to rightclick on an Access file and in the menu i want to compact or decompile the access file.

I know it is possible but i don't know what's the registry setting.

View 1 Replies View Related

Compact Once A Day...

Dec 27, 2005

Hi everyone,

hopefully you'll be able to help me out with this one, been searching but can't find the exact answer.

I am running a database with multiple users, max of 10, currently the database autocompacts when it is closed, however this takes time every time anyone closes it.

what i am looking to do is have the database automatically compact but only once a day. Any ideas???

many thanks

View 1 Replies View Related

Right Time To Compact

Oct 21, 2005

Hi All,

Is there any way to determine the right time for compacting a database?

I mean say for example - is there any way (thru a property/system table) which I can refer to see how many records are marked for deletion?

This way - I can compact the database ONLY if there are large number of records marked for deletion?

I have searched all the places I could but could not get the answer I want. :confused:

Thank you,
Dev.
:)

View 5 Replies View Related

Compact And Repair

Jan 13, 2006

Goodmorining,
I use Access XP and I have a problem with the Compact and Repair function.
When I start this function via the normal menu's access doesn't seem to respond anymore. I can leave my comp on for hours dut nothing happens.
He does make a copy (db1) with the same volume but then it stops.

Does anybody else has this problem and what can I do about it

Thanks

Kind regards

Rolf

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved