Hello again,
Thanks to Scott for helping out with my last query.
I've had a good look round but I can't find anything that carries out what I'm trying to do.
I've got a function that imports a set of text files into already-defined tables. Every time I run it, the database swells considerably, so it would be good to be able to automatically run the compact/repair feature at the end of this script.
I've tried the compact-repair function below, but it doesn't allow me to do it on the currently-open database.
http://www.thescripts. com/forum/thread205241.ht ml
Any ideas on how to automate this?
Thanks in advance.
3 5602
After these files are imported, are you the only user in the database, or are there other users logged in?
Brad.
Try this link:
http://www.mvps.org/access/general/gen0041.htm
I just slipped the code into my test db to try it out, and it seems to work as far as compacting the db goes, but opened the VBA editor window up to the function module after executing.
Not quite a perfect solution, as you'll need to play around with it in order to get it working seamlessly, but it seems to be able to do what you want... as long as you are the only user signed into the database at the time... I think compact repair only works as long as your are the exclusive user, since if you tried to compact repair while other users were signed in, it could wreak havoc with data being sent to the db, etc...
Regards,
Scott
Thanks again, Scott. I'll try it out later and see if I can get it to work.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Paul T. Rong |
last post by:
Dear all,
My aim is to compact and repair current database, I got the following code
from http://www.mvps.org/access/general/gen0041.htm
Option Compare Database
' ***** Code Start *****
Public Sub CompactDB()
|
by: Paolo |
last post by:
Hi,
I am trying to compact and repair my database, however every time I try it
comes up a message saying: Table: "TempMSysAccessObject already exists",
whenever I try to look for this table I cannot find it anywhere... Any
clues...
Already went into the help file and nothing...
Also try to copy my database and the same message comes up
|
by: Ken Winters |
last post by:
Whenever I run the Repair/Compact on my database, the security settings on
the file change.
A 3rd party application can only access the database over the network when
the username "Everyone" is added to the "Group or user names" with access to
the file. But each time the Repair/Compact utility is run, it removes
"Everyone" from the list.
This is under Win2000. Can anyone offer some advise or suggestions?
Thanks
|
by: GaryDave |
last post by:
My school registration database has not been quite right after a recent
compact and repair (done while I was away). Though most of the many
forms and subforms are working normally, one form in particular will no
longer allow new entries into the subform - the recordset of the
underlying query is no longer updatable.
The subform in question enters the identity and other vital info for
children whose parent's ID provides the FK, linking...
|
by: bobdydd |
last post by:
Hi Everybody
For Microsoft Access 2000 and above
Windows XP
I am trying to mimic the action of this command that at the moment runs
from the start>>all programs at the bottom left of the screen.
"C:\Program Files\Microsoft Office\ART\Office\MSACCESS.EXE" _
/excl /runtime /profile "MYDB" /wrkgrp _
| |
by: Simon |
last post by:
Dear reader,
How can I use a command in the current mdn to compact and repair the mdb.
In which the source file is the current database.
|
by: Ron |
last post by:
Hi All,
Using WinXP pro/Access 2000.
I have a database that's been used for about 5 months. Transferred lots of
data from a dos based program, then the users have been using it for that 5
months. About 180000 records in one of the main files (maybe 25000 new since
the dos conversion). Been having some speed issues crop up along the way
(much faster to do same reports when I first transferred the data than now,
with the new 25000...
|
by: Ron |
last post by:
New discovery.
If I take a perfectly good database, and "compact/repair" on it with Access
2000 (seems to be at multiple sites--I've tried it with my system here, at
another office on an entirely different network), it damages the file
somehow. The user's machine that did the compact/repair can see the file
fine. But any networked user can't get in. I can double click on a good
database file from any user (over the network) and it...
|
by: Bizmark |
last post by:
Access2003,
Windows XP Pro OEM user OS,
Windows Sever 2000 server OS.
Not-so-recently I inherited 3 Access DB's from another company merging with our own. Our own system works off of SQL server, but mainting these databases is critical to keeping the business running. 1 database in particular has been causing problems. Along the course we have had a few problems with random records corrupting (new and old) and Values within fields...
|
by: zufie |
last post by:
When I Repair/Compact my Access databse. I get icons/copies of a
database named db1.mdb, db2.mdb, db3.mdb, etc...
How else may I repair this database?
Thanks!,
Zuf
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |