By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,394 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

Compact on close not happening

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
"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


Nov 12 '05 #3

P: n/a
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



Nov 12 '05 #4

P: n/a
"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
Nov 12 '05 #5

P: n/a
"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
Nov 12 '05 #6

P: n/a
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

Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.