I know the 2 GB file size limit in Access, and my database apparently
has hit it. My problem is, I've gone and deleted tables that contained
old data, but when I check file size again, it reports exactly the same
size! I even made a copy of it, and deleted tables that I know were
the larger tables, yet I still get the same file size. I checked it in
DOS as well....still the same. Is there some sort of cleaning routine
I can do to get this fixed? There are no forms, no reports, just
tables. 4 1726
> I know the 2 GB file size limit in Access, and my database apparently has hit it. My problem is, I've gone and deleted tables that contained old data, but when I check file size again, it reports exactly the same size! I even made a copy of it, and deleted tables that I know were the larger tables, yet I still get the same file size. I checked it in DOS as well....still the same. Is there some sort of cleaning routine I can do to get this fixed? There are no forms, no reports, just tables.
Hi, sounds like you need to compact the database to retrieve the used space.
In Access 97 this is in Tools | Database Utilities | Compact....not sure
about later versions though.
Alan
Close enough for me (Access 2000). However, Access keeps telling me
that I have already exclusively opened it, so it can't compact it. I
have one instance of Access open, and I give the command to compact the
database without opening it (straight from the Access opening menu).
No open tasks or processes refer to MS Access if I close it down, so I
don't know how to release my "exclusive open" on the database.
(Just FYI, I'm also trying to clear duplicate rows out of another
table, but I run into another known Access bug when running a INSERT
INTO .... SELECT DISTINCT * query. I can't wait until I get to do
something in Access that works.)
>However, Access keeps telling me that I have already exclusively opened it, so it can't compact it. I have one instance of Access open
You sure about the above? I would close down ms-access, and re-boot your
computer......
Then open the mdb file, and then use the tools->compact...
If you still can't compact, then I would exit ms-access, and look for a ldb
file..and delete it...
So, you do open the mdb file regular way (assuming there is no startup form,
or startup code)...
You then should be able to compact....
If you can't compact, you can create a blank mdb file..and then go file->get
external data..and import everything.....
I would try and determine why you can't compact. When *developing* code, I
compact several times daily.....
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada pl************* ****@msn.com http://www.members.shaw.ca/AlbertKallal
"Albert D. Kallal" <ka****@msn.com > wrote in
news:bn78g.1433 29$7a.33553@pd7 tw1no: If you can't compact, you can create a blank mdb file..and then go file->get external data..and import everything.....
The JetCompact utility is also an option. It can sometimes compact
MDBs that are prevented by their corruption from being opened in
Access.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Dave C |
last post by:
I've written the following code that won't compile, trimmed down to
just the pertinent stuff:
--- WindowClass.hxx ----------------------------------------------------
#include <set>
class Window;
class WindowClass {
public:
|
by: Jim |
last post by:
Hey guys
I DESPERATLY need some help with this small javascript i have on this
website. All that it's supposed to do is change the button image once
it's pressed but alas... I copy-pasted the code as it was given to me
from Imageready but it won't work. The event that i wanted (and
"created" with Imageready) was ondown. The code is this:
ONMOUSEOUT="changeImages('company', 'Images/company.gif'); return true;"...
|
by: John Warner |
last post by:
I have a wierd problem that I can't find any reference to in the
knowledge base. I develop simple databases at the company where I
work, and many of them are used by hundreds of employees. We all have
the same basic computers with the same base image. The problem is,
whenever I create a hyperlink object in the database, I'm able to
click on it from my PC and it works just fine. All other users click
on it and Access just sits there...
|
by: Claire |
last post by:
Running XP pro, SP2. Visual studio .NET 2003. App written in C#
I have written an application that hides itself when run and shows a
notification icon in the system tray.
If the main form is visible/restored to the desktop, and I tell windows to
restart, windows shuts down fine.
If the main form is minimized to the tray and I tell windows to restart,
other desktop apps close down fine but my program's icon remains sat in the
system...
|
by: Claire |
last post by:
Windows refuses to close down if my applications main form is hidden and
there's a notify icon in the system tray. If I restore the form, then
shutting down Windows succeeds.
If I comment out the code in "frmOptions_Closing" then run and hide the
application, Windows shuts down normally.
I think there was a way to find out what was causing an application to close
down - api call? Is there anything in .net that I can query
My code is...
| |
by: simon |
last post by:
I have simple html(aspx) page, but vertical height won't work.
Even if i had set the height of a table=100%, the table is not 100% height.
I spend a lot of time(my real page is more complicated) to figured it out that this won't work because of attribute of a page:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
I have visual studio 2005 beta2 and it appends this attribute to every...
|
by: wespvp |
last post by:
I've got a 2 hour index build that has been running for 9 hours. With 'ps
-efl' I see that there is a VACUUM ANALYZE running that started 24 hours ago
and my index build is 'wating'. I sent a SIGINT to postmaster and it kicked
all sessions out, but the VACUUM is still running so postmaster won't shut
down.
How do I safely kill this thing so I can get restart postmaster and my index
build?
Wes
|
by: GaryDean |
last post by:
We have a new server2003 machine that was built like all the rest - IIS and
everything needed to run asp.net apps. We have a test asp.net website that
we use for new machines to make sure everything works right.
This new server won't run our test app. It won't run .aspx pages. It will
run default.htm just fine. We cant see anything wrong with it.
for instance it won't run http://69.50.211.122/default.aspx
but it will run...
|
by: tpgames |
last post by:
Two days ago, MS office Word would type JP fonts, I thought. I didn't think I was using Works. Now, it won't type in JP. Jasc Paint shop pro 8, should type JP fonts because I am using XP, according to Corel's website, and Jasc uses whatever is in the XP font folder. But, it won't. All the JP fonts types as English, even with JP selected in the Language Bar. I can't afford to upgrade to any better paint program. I do have a free JP word...
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |