Hi,
I have experience of strange behavior of my Access 97 database.
I went to the existing database, which has a size of 30mb, and change
three lines of VBA codes behind reports. 15 reports have been
modified. And after compacting database I got 33.5mb database. What
did I change that caused database jump on 3.5 megabytes of size? What
can I do to clean up that absolutely odd behavior of Access 97?
Thanks in advance,
Alex
9  2099 
Hi Alex, use the DECOMPILE command for decreasing the db size. Check
this on Advisor.com site.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
CSL <cs*****@hotmail.com> wrote in message news:<3f*********************@news.frii.net>... Hi Alex, use the DECOMPILE command for decreasing the db size. Check
this on Advisor.com site.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Thanks it's works for decreasing a size of the database
(tremendously), but now I can't compile modules. It's keep telling me
that "A module is not a valid type". What do I do to fix it?
Alex
"Sashafay" <af******@mwh.com> wrote in message
news:a1**************************@posting.google.c om... CSL <cs*****@hotmail.com> wrote in message
news:<3f*********************@news.frii.net>... Hi Alex, use the DECOMPILE command for decreasing the db size. Check
this on Advisor.com site.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Thanks it's works for decreasing a size of the database
(tremendously), but now I can't compile modules. It's keep telling me
that "A module is not a valid type". What do I do to fix it?
Restore from backup?
TC
Sahafay,
I believe you may be able to create a blank database and import all
your objects from the troubled database. See if that clears up your
problem.
-tom
"TC" <a@b.c.d> wrote in message news:<1068780150.631376@teuthos>... "Sashafay" <af******@mwh.com> wrote in message
news:a1**************************@posting.google.c om... CSL <cs*****@hotmail.com> wrote in message
news:<3f*********************@news.frii.net>... Hi Alex, use the DECOMPILE command for decreasing the db size. Check
this on Advisor.com site.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Thanks it's works for decreasing a size of the database
(tremendously), but now I can't compile modules. It's keep telling me
that "A module is not a valid type". What do I do to fix it?
Restore from backup?
TC
"TC" <a@b.c.d> wrote in message news:<1068780150.631376@teuthos>... "Sashafay" <af******@mwh.com> wrote in message
news:a1**************************@posting.google.c om... CSL <cs*****@hotmail.com> wrote in message
news:<3f*********************@news.frii.net>... Hi Alex, use the DECOMPILE command for decreasing the db size. Check
this on Advisor.com site.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Thanks it's works for decreasing a size of the database
(tremendously), but now I can't compile modules. It's keep telling me
that "A module is not a valid type". What do I do to fix it?
Restore from backup?
TC
Well.. I know that...
I'm asking about some real action...please!
Alex
Hmmm.....I used Reply to Group and posted a link to a KB article for you approx. 7 hours
ago from work. I don't see this post showing up yet, when I view this thread at home.
Here is my original post again:
ACC: "A Module Is Not a Valid Type" Compile Error Message http://support.microsoft.com/default...b;en-us;138018
Tom
___________________________________________
"Sashafay" <af******@mwh.com> wrote in message
news:a1**************************@posting.google.c om...
Well.. I know that...
I'm asking about some real action...please!
Alex
Reposted 2nd time -- For some reason unknown to me, answers that I am posting from work
are not showing up in the list when I view the same thread at home much later on.
I posted this answer approx. 16 hours ago the first time....
It shows up in the list of messages when I view them from work, but not from home. Very
strange to me! Anyway, the 2nd link points to the original Cary Prague article on the
topic of large database bloat in Access 97 databases.
From: Still, Erik R
Sent: Friday, November 14, 2003 9:02 AM
To: Wickerath, Tom; DL AccessDevTalk
Subject: RE: Does anyone have a copy of this article?
Try the waybackmachine ( http://www.archive.org/web/web.php).
There are several versions of the article that are cached (e.g., http://web.archive.org/web/200302040...m/largedb.htm).
-- Erik
Erik Still, librarian
Boeing Library Services
(425) 237-4339
_________________________________________________
"Sashafay" <af******@mwh.com> wrote in message
news:a1*************************@posting.google.co m...
Hi,
I have experience of strange behavior of my Access 97 database.
I went to the existing database, which has a size of 30mb, and change
three lines of VBA codes behind reports. 15 reports have been
modified. And after compacting database I got 33.5mb database. What
did I change that caused database jump on 3.5 megabytes of size? What
can I do to clean up that absolutely odd behavior of Access 97?
Thanks in advance,
Alex
FYI, I can't see them either.
TC
"Tom Wickerath" <AO***********************@comcast.net> wrote in message
news:yu********************@comcast.com... Reposted 2nd time -- For some reason unknown to me, answers that I am
posting from work are not showing up in the list when I view the same thread at home much
later on.
I posted this answer approx. 16 hours ago the first time....
It shows up in the list of messages when I view them from work, but not
from home. Very strange to me! Anyway, the 2nd link points to the original Cary Prague
article on the topic of large database bloat in Access 97 databases.
From: Still, Erik R
Sent: Friday, November 14, 2003 9:02 AM
To: Wickerath, Tom; DL AccessDevTalk
Subject: RE: Does anyone have a copy of this article?
Try the waybackmachine (http://www.archive.org/web/web.php).
There are several versions of the article that are cached (e.g.,
http://web.archive.org/web/200302040...reations.com/l
argedb.htm).
-- Erik
Erik Still, librarian
Boeing Library Services
(425) 237-4339
_________________________________________________
"Sashafay" <af******@mwh.com> wrote in message
news:a1*************************@posting.google.co m...
Hi,
I have experience of strange behavior of my Access 97 database.
I went to the existing database, which has a size of 30mb, and change
three lines of VBA codes behind reports. 15 reports have been
modified. And after compacting database I got 33.5mb database. What
did I change that caused database jump on 3.5 megabytes of size? What
can I do to clean up that absolutely odd behavior of Access 97?
Thanks in advance,
Alex
Thank you all for your input!!!
I've got my answer.
Thanks again,
Alex
"TC" <a@b.c.d> wrote in message news:<1068946483.917384@teuthos>... FYI, I can't see them either.
TC
"Tom Wickerath" <AO***********************@comcast.net> wrote in message
news:yu********************@comcast.com... Reposted 2nd time -- For some reason unknown to me, answers that I am
posting from work are not showing up in the list when I view the same thread at home much
later on.
I posted this answer approx. 16 hours ago the first time....
It shows up in the list of messages when I view them from work, but not
from home. Very strange to me! Anyway, the 2nd link points to the original Cary Prague
article on the topic of large database bloat in Access 97 databases.
From: Still, Erik R
Sent: Friday, November 14, 2003 9:02 AM
To: Wickerath, Tom; DL AccessDevTalk
Subject: RE: Does anyone have a copy of this article?
Try the waybackmachine (http://www.archive.org/web/web.php).
There are several versions of the article that are cached (e.g.,
http://web.archive.org/web/200302040...reations.com/l
argedb.htm).
-- Erik
Erik Still, librarian
Boeing Library Services
(425) 237-4339
_________________________________________________
"Sashafay" <af******@mwh.com> wrote in message
news:a1*************************@posting.google.co m...
Hi,
I have experience of strange behavior of my Access 97 database.
I went to the existing database, which has a size of 30mb, and change
three lines of VBA codes behind reports. 15 reports have been
modified. And after compacting database I got 33.5mb database. What
did I change that caused database jump on 3.5 megabytes of size? What
can I do to clean up that absolutely odd behavior of Access 97?
Thanks in advance,
Alex
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Marvin Libson |
last post by:
Hi All:
I am running DB2 UDB V7.2 with FP11. Platform is Windows 2000. I
have created a java UDF and trigger. When I update my database I get
the following error:
SQL1224N A database...
|
by: Kums |
last post by:
What is the maximum permissible size of a database? Is there any limitation.
What is the maximum # of tablespace's allowed in a database?
Thanks for your response.
|
by: ImraneA |
last post by:
Hi there
Many thanks to those people who contributed to this group, helped me
greatly.
Enclose, my code, hope it helps others :-
Public Function Export_Excel_9(tbx1 As Variant, tbx2 As...
|
by: Pam Ammond |
last post by:
I need the code to update the database when Save is clicked and a text field
has changed. This should be very easy since I used Microsoft's wizards for
the OleDBAdapter and OleDBConnection, and...
|
by: bartonc |
last post by:
#Boa:Dialog:DBConnectDialog
import wx
##"""Given a set if login specs, create a dbServer instance and
## ensure that there is a valid, open connection to the database.
## If not, set the...
|
by: vijay.db |
last post by:
Hi Group,
It's really confusing to calculate the size of the DB2 UDB database in
versions lesser than 8.2.
In Version 8.2 if we run the query db2 "call get_dbsize_info(?,?,?,0)"
it gives us...
|
by: narayan2586 |
last post by:
Hi all,
When ever i am trying to connect my application it's giving below error message:
RemoteException occurred in server thread; nested exception is: java.rmi.RemoteException: ; nested...
|
by: rustyc |
last post by:
Well, here's my first post in this forum (other than saying 'HI' over in the hi forum ;-)
As I said over there:
... for a little side project at home, I'm writing a ham radio web site in...
|
by: Atli |
last post by:
You may be wondering why you would want to put your files “into” the database, rather than just onto the file-system. Well, most of the time, you wouldn’t.
In situations where your PHP application...
|
by: Brit |
last post by:
I have an ASP file that retrieves names from an Access database for 4 different categories of membership, which the visitor to the page selects (corporate, institutional, regular, or student). The...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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,...
|
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...
|
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,...
|
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...
|
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...
|
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,...
| |
