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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
