Odd Database Size

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

re: Odd Database Size

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!

re: Odd Database Size

CSL <csl_dev@hotmail.com> wrote in message news:<3fb39a56$0$196$75868355@news.frii.net>...[color=blue]
> 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![/color]

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

re: Odd Database Size

"Sashafay" <afayfman@mwh.com> wrote in message
news:a13f8a22.0311131053.3d1cc10b@posting.google.c om...[color=blue]
> CSL <csl_dev@hotmail.com> wrote in message[/color]
news:<3fb39a56$0$196$75868355@news.frii.net>...[color=blue][color=green]
> > 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![/color]
>
> 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?[/color]


Restore from backup?

TC

re: Odd Database Size

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>...[color=blue]
> "Sashafay" <afayfman@mwh.com> wrote in message
> news:a13f8a22.0311131053.3d1cc10b@posting.google.c om...[color=green]
> > CSL <csl_dev@hotmail.com> wrote in message[/color]
> news:<3fb39a56$0$196$75868355@news.frii.net>...[color=green][color=darkred]
> > > 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![/color]
> >
> > 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?[/color]
>
>
> Restore from backup?
>
> TC[/color]

re: Odd Database Size

"TC" <a@b.c.d> wrote in message news:<1068780150.631376@teuthos>...[color=blue]
> "Sashafay" <afayfman@mwh.com> wrote in message
> news:a13f8a22.0311131053.3d1cc10b@posting.google.c om...[color=green]
> > CSL <csl_dev@hotmail.com> wrote in message[/color]
> news:<3fb39a56$0$196$75868355@news.frii.net>...[color=green][color=darkred]
> > > 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![/color]
> >
> > 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?[/color]
>
>
> Restore from backup?
>
> TC[/color]

Well.. I know that...
I'm asking about some real action...please!

Alex

re: Odd Database Size

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" <afayfman@mwh.com> wrote in message
news:a13f8a22.0311132250.510d2d23@posting.google.c om...

Well.. I know that...
I'm asking about some real action...please!

Alex

re: Odd Database Size

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" <afayfman@mwh.com> wrote in message
news:a13f8a22.0311121438.bd10319@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

re: Odd Database Size

FYI, I can't see them either.

TC


"Tom Wickerath" <AOS168RemoveThisSpamBlock@comcast.net> wrote in message
news:yuudnfHHlec0iiuiRVn-iw@comcast.com...[color=blue]
> Reposted 2nd time -- For some reason unknown to me, answers that I am[/color]
posting from work[color=blue]
> are not showing up in the list when I view the same thread at home much[/color]
later on.[color=blue]
>
> 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[/color]
from home. Very[color=blue]
> strange to me! Anyway, the 2nd link points to the original Cary Prague[/color]
article on the[color=blue]
> 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.,
>[/color]
http://web.archive.org/web/200302040...reations.com/l
argedb.htm).[color=blue]
>
> -- Erik
> Erik Still, librarian
> Boeing Library Services
> (425) 237-4339
>
>
>
> _________________________________________________
>
>
> "Sashafay" <afayfman@mwh.com> wrote in message
> news:a13f8a22.0311121438.bd10319@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
>
>[/color]

re: Odd Database Size

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>...[color=blue]
> FYI, I can't see them either.
>
> TC
>
>
> "Tom Wickerath" <AOS168RemoveThisSpamBlock@comcast.net> wrote in message
> news:yuudnfHHlec0iiuiRVn-iw@comcast.com...[color=green]
> > Reposted 2nd time -- For some reason unknown to me, answers that I am[/color]
> posting from work[color=green]
> > are not showing up in the list when I view the same thread at home much[/color]
> later on.[color=green]
> >
> > 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[/color]
> from home. Very[color=green]
> > strange to me! Anyway, the 2nd link points to the original Cary Prague[/color]
> article on the[color=green]
> > 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.,
> >[/color]
> http://web.archive.org/web/200302040...reations.com/l
> argedb.htm).[color=green]
> >
> > -- Erik
> > Erik Still, librarian
> > Boeing Library Services
> > (425) 237-4339
> >
> >
> >
> > _________________________________________________
> >
> >
> > "Sashafay" <afayfman@mwh.com> wrote in message
> > news:a13f8a22.0311121438.bd10319@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
> >
> >[/color][/color]