Compact on close not happening

[Mike MacSween]

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

[CDB]

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" <mi***********************@btinternet.com> wrote in message
news:40***********************@news.aaisp.net.uk.. .

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

[Mike MacSween]

"CDB" <al***@delete.wave.co.nz> wrote in message
news:c5**********@news.wave.co.nz...

The BE is not "opened/closed" by an FE using linked tables from it.
Thanks, I didn't know that.
How are
you opening the back end db?
FE links to BE tables.

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

Cheers, Mike
Clive

"Mike MacSween" <mi***********************@btinternet.com> wrote in message news:40***********************@news.aaisp.net.uk.. .

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

[CDB]

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" <mi***********************@btinternet.com> wrote in message
news:40***********************@news.aaisp.net.uk.. .

"CDB" <al***@delete.wave.co.nz> wrote in message
news:c5**********@news.wave.co.nz...

The BE is not "opened/closed" by an FE using linked tables from it.

Thanks, I didn't know that.

How are
you opening the back end db?

FE links to BE tables.

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

Cheers, Mike

Clive

"Mike MacSween" <mi***********************@btinternet.com> wrote in

message

news:40***********************@news.aaisp.net.uk.. .

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

[Tony Toews]

"Mike MacSween" <mi***********************@btinternet.com> wrote:

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

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

[Tony Toews]

"Mike MacSween" <mi***********************@btinternet.com> wrote:

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.

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]

Thanks for the tips Tony.

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

Cheers, Mike
"Tony Toews" <tt****@telusplanet.net> wrote in message
news:62********************************@4ax.com...

"Mike MacSween" <mi***********************@btinternet.com> wrote:

The back end is on a server. Compact on close is set on, but on the clientsserver isn't happening, though no errors are being generated. On my machinehere Compact On Close happens fine.
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