MS Access Multiuser - Auto closing Fe to compact Be

Author

Auto closing Fe to compact Be

Don

2005-05-15, 8:24 pm

I am going to run code that automaticly runs a series of action queries to
update and make tables on the BE, which is currently ran on the FE. In this
code, once the queries are finished, I want the BE to close to compact daily
as the application seems to blow up to over 2 gigs and cause errors without
this bit of maintenance after a couple of weeks. With compacting the
application is usually about 299 MB. I believe this excessive growth is due
to running these queries on the FE daily or more than daily on multiple
remotes. The queries are very intensive running up to 27 lines of code for
each record (thousands of records). I have already posted and this seems to
be the best way to extract "like" string quries and convert the extracted
value to another text. Other than that, the problem I have is when closing
the BE to be compacted, some work stations are lift on inactive and prohibit
the BE from compacting. Ours is a 24 hour operation, but at 5:20 AM no one is
actually using the system employees just don't back out of their forms
keeping records engauged. What I thought I could do is have a timer form
hidden on each one of the FE and to close the application say 5 to 10
minitues before the compacting begins. The question I have is, is this a good
idea or faulty thinking?

Thanks,
Dennis

Douglas J. Steele

2005-05-15, 8:24 pm

Before going to that extent, you might consider using a temporary database
to do your calculations in.

Tony Toews has an example of how to do this at
http://www.granite.ab.ca/access/temptables.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Don" <Don@discussions.microsoft.com> wrote in message
news:5B5FE129-53D8-4481-A1A9- D2C533572AAC@microso
ft.com...
>I am going to run code that automaticly runs a series of action queries to
> update and make tables on the BE, which is currently ran on the FE. In
> this
> code, once the queries are finished, I want the BE to close to compact
> daily
> as the application seems to blow up to over 2 gigs and cause errors
> without
> this bit of maintenance after a couple of weeks. With compacting the
> application is usually about 299 MB. I believe this excessive growth is
> due
> to running these queries on the FE daily or more than daily on multiple
> remotes. The queries are very intensive running up to 27 lines of code for
> each record (thousands of records). I have already posted and this seems
> to
> be the best way to extract "like" string quries and convert the extracted
> value to another text. Other than that, the problem I have is when closing
> the BE to be compacted, some work stations are lift on inactive and
> prohibit
> the BE from compacting. Ours is a 24 hour operation, but at 5:20 AM no one
> is
> actually using the system employees just don't back out of their forms
> keeping records engauged. What I thought I could do is have a timer form
> hidden on each one of the FE and to close the application say 5 to 10
> minitues before the compacting begins. The question I have is, is this a
> good
> idea or faulty thinking?
>
> Thanks,
> Dennis
>

Foo.sg

2005-05-16, 7:24 am

I went in to Tony's site and downloaded the TempTables.mdb but when I try to
open it my Access 2002 tells me:
"The Current User account doesn't have permission to convert or enable this
databases".

What did I do wrong. I have the same problem with all other MDB I downloaded
from the site.

Foo.sg

"Douglas J. Steele" wrote:

> Before going to that extent, you might consider using a temporary database
> to do your calculations in.
>
> Tony Toews has an example of how to do this at
> http://www.granite.ab.ca/access/temptables.htm
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "Don" <Don@discussions.microsoft.com> wrote in message
> news:5B5FE129-53D8-4481-A1A9- D2C533572AAC@microso
ft.com...
>
>
>

RuralGuy

2005-05-21, 8:23 pm

=?Utf-8?B?Rm9vLnNn?= <Foosg@discussions.microsoft.com> wrote in
news:270D5E7A-574C-4858-B539- ECA88EC4D573@microso
ft.com:

> I went in to Tony's site and downloaded the TempTables.mdb but when
I
> try to open it my Access 2002 tells me:
> "The Current User account doesn't have permission to convert or
> enable this
> databases".
>
> What did I do wrong. I have the same problem with all other MDB I
> downloaded from the site.
>
> Foo.sg
>

<snip>

Welcome to one of the many security features of Windows XP!

Right click on the file and bring up the properties sheet.

Depress the UNBLOCK button and then the security message goes away and
the file works normally.

The voice of experience talking.

HTH

RuralGuy

Sponsored Links