Compact on close not happening

The back end is on a server. Compact on close is set on, but on the clients
server isn't happening, though no errors are being generated. On my machine
here Compact On Close happens fine.

Is this an NT permissions thing?

Cheers, Mike

The BE is not "opened/closed" by an FE using linked tables from it.v How are
you opening the back end db?

Clive

"Mike MacSween" <mike.macsween.damnthespam@btinternet.com> wrote in message
news:407fa379$0$39887$5a6aecb4@news.aaisp.net.uk.. .[color=blue]
> The back end is on a server. Compact on close is set on, but on the[/color]
clients[color=blue]
> server isn't happening, though no errors are being generated. On my[/color]
machine[color=blue]
> here Compact On Close happens fine.
>
> Is this an NT permissions thing?
>
> Cheers, Mike
>
>[/color]

"CDB" <alpha@delete.wave.co.nz> wrote in message
news:c5od4m$d1b$1@news.wave.co.nz...[color=blue]
> The BE is not "opened/closed" by an FE using linked tables from it.[/color]

Thanks, I didn't know that.
[color=blue]
> How are
> you opening the back end db?[/color]

FE links to BE tables.

There's a temp table being written I think. Needs to be in the FE?

Cheers, Mike
[color=blue]
> Clive
>
> "Mike MacSween" <mike.macsween.damnthespam@btinternet.com> wrote in[/color]
message[color=blue]
> news:407fa379$0$39887$5a6aecb4@news.aaisp.net.uk.. .[color=green]
> > The back end is on a server. Compact on close is set on, but on the[/color]
> clients[color=green]
> > server isn't happening, though no errors are being generated. On my[/color]
> machine[color=green]
> > here Compact On Close happens fine.
> >
> > Is this an NT permissions thing?
> >
> > Cheers, Mike
> >
> >[/color]
>
>[/color]

Temp tables can exist in the FE, or as David Fenton propounds with good
reason, in a separate local mdb created and destroyed for each session. Or
only in memory.

In a multi-user situation, having two people using what they think is "my"
table in a BE could be disastrous.

Clive


"Mike MacSween" <mike.macsween.damnthespam@btinternet.com> wrote in message
news:407fc5ca$0$39895$5a6aecb4@news.aaisp.net.uk.. .[color=blue]
> "CDB" <alpha@delete.wave.co.nz> wrote in message
> news:c5od4m$d1b$1@news.wave.co.nz...[color=green]
> > The BE is not "opened/closed" by an FE using linked tables from it.[/color]
>
> Thanks, I didn't know that.
>[color=green]
> > How are
> > you opening the back end db?[/color]
>
> FE links to BE tables.
>
> There's a temp table being written I think. Needs to be in the FE?
>
> Cheers, Mike
>[color=green]
> > Clive
> >
> > "Mike MacSween" <mike.macsween.damnthespam@btinternet.com> wrote in[/color]
> message[color=green]
> > news:407fa379$0$39887$5a6aecb4@news.aaisp.net.uk.. .[color=darkred]
> > > The back end is on a server. Compact on close is set on, but on the[/color]
> > clients[color=darkred]
> > > server isn't happening, though no errors are being generated. On my[/color]
> > machine[color=darkred]
> > > here Compact On Close happens fine.
> > >
> > > Is this an NT permissions thing?
> > >
> > > Cheers, Mike
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

"Mike MacSween" <mike.macsween.damnthespam@btinternet.com> wrote:
[color=blue]
>FE links to BE tables.
>There's a temp table being written I think. Needs to be in the FE?[/color]

See the TempTables.MDB page at my website which illustrates how to use a temporary
MDB in your app. http://www.granite.ab.ca/access/temptables.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

"Mike MacSween" <mike.macsween.damnthespam@btinternet.com> wrote:
[color=blue]
>The back end is on a server. Compact on close is set on, but on the clients
>server isn't happening, though no errors are being generated. On my machine
>here Compact On Close happens fine.[/color]

When the user exits the FE attempt to rename the backend MDB preferably with todays
date in the name in yyyy-mm-dd format. Ensure you close all bound forms, including
hidden forms, and reports before doing this. If you get an error message, oops, its
busy so don't bother. If it is successful then compact it back.

See my Backup, do you trust the users or sysadmins? tips page for more info.
http://www.granite.ab.ca/access/backup.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

"Mike MacSween" <mike.macsween.damnthespam@btinternet.com> wrote:
[color=blue]
>FE links to BE tables.
>There's a temp table being written I think. Needs to be in the FE?[/color]

See the TempTables.MDB page at my website which illustrates how to use a temporary
MDB in your app. http://www.granite.ab.ca/access/temptables.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

"Mike MacSween" <mike.macsween.damnthespam@btinternet.com> wrote:
[color=blue]
>The back end is on a server. Compact on close is set on, but on the clients
>server isn't happening, though no errors are being generated. On my machine
>here Compact On Close happens fine.[/color]

When the user exits the FE attempt to rename the backend MDB preferably with todays
date in the name in yyyy-mm-dd format. Ensure you close all bound forms, including
hidden forms, and reports before doing this. If you get an error message, oops, its
busy so don't bother. If it is successful then compact it back.

See my Backup, do you trust the users or sysadmins? tips page for more info.
http://www.granite.ab.ca/access/backup.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Thanks for the tips Tony.

You're right, I should be doing my temp tables somewhere else.

Cheers, Mike
"Tony Toews" <ttoews@telusplanet.net> wrote in message
news:62s580h1tfi2rbb9bo4vjoma22p47ne7lm@4ax.com...[color=blue]
> "Mike MacSween" <mike.macsween.damnthespam@btinternet.com> wrote:
>[color=green]
> >The back end is on a server. Compact on close is set on, but on the[/color][/color]
clients[color=blue][color=green]
> >server isn't happening, though no errors are being generated. On my[/color][/color]
machine[color=blue][color=green]
> >here Compact On Close happens fine.[/color]
>
> When the user exits the FE attempt to rename the backend MDB preferably[/color]
with todays[color=blue]
> date in the name in yyyy-mm-dd format. Ensure you close all bound forms,[/color]
including[color=blue]
> hidden forms, and reports before doing this. If you get an error[/color]
message, oops, its[color=blue]
> busy so don't bother. If it is successful then compact it back.
>
> See my Backup, do you trust the users or sysadmins? tips page for more[/color]
info.[color=blue]
> http://www.granite.ab.ca/access/backup.htm
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm[/color]

Thanks for the tips Tony.

You're right, I should be doing my temp tables somewhere else.

Cheers, Mike
"Tony Toews" <ttoews@telusplanet.net> wrote in message
news:62s580h1tfi2rbb9bo4vjoma22p47ne7lm@4ax.com...[color=blue]
> "Mike MacSween" <mike.macsween.damnthespam@btinternet.com> wrote:
>[color=green]
> >The back end is on a server. Compact on close is set on, but on the[/color][/color]
clients[color=blue][color=green]
> >server isn't happening, though no errors are being generated. On my[/color][/color]
machine[color=blue][color=green]
> >here Compact On Close happens fine.[/color]
>
> When the user exits the FE attempt to rename the backend MDB preferably[/color]
with todays[color=blue]
> date in the name in yyyy-mm-dd format. Ensure you close all bound forms,[/color]
including[color=blue]
> hidden forms, and reports before doing this. If you get an error[/color]
message, oops, its[color=blue]
> busy so don't bother. If it is successful then compact it back.
>
> See my Backup, do you trust the users or sysadmins? tips page for more[/color]
info.[color=blue]
> http://www.granite.ab.ca/access/backup.htm
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm[/color]