473,580 Members | 2,870 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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
Nov 12 '05 #1
6 1646
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************ ***********@bti nternet.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
"CDB" <al***@delete.w ave.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************ ***********@bti nternet.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
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************ ***********@bti nternet.com> wrote in message
news:40******** *************** @news.aaisp.net .uk...
"CDB" <al***@delete.w ave.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************ ***********@bti nternet.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
"Mike MacSween" <mi************ ***********@bti nternet.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
"Mike MacSween" <mi************ ***********@bti nternet.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
Thanks for the tips Tony.

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

Cheers, Mike
"Tony Toews" <tt****@teluspl anet.net> wrote in message
news:62******** *************** *********@4ax.c om...
"Mike MacSween" <mi************ ***********@bti nternet.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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
5065
by: James Franklin | last post by:
Hi, I have a number of databases in A2K, written on different machines with different installations of Office. I have found that compacting a database while it is open regularly fails, seemingly at random. This is especially annoying as I usually set the Compact on Close setting in Tools/Options to true. Has anyone else experienced this...
9
319
by: Mike MacSween | last post by:
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
1
2092
by: smitty mittlebaum | last post by:
I have a strange problem that has reared its ugly head in the last few weeks. I have the option "Compact on Close" (Tools, Options, General tab) enabled on my development machine. I did this because every time I worked on my app it just grew and grew. What started out as a 14Meg file kept growing into a monster of over 90 Megs! System...
1
4945
by: Mark | last post by:
Hi all, I have a Access 2002 FE/BE scenario where the BE is stored on a network drive. Due to the amount of importing/deleting, the database bloats quite a lot. UP until now, I have been booting the users out of the database and manually compacting it. What I am trying to do is automate the process so I don't have to worry about it. My VB...
1
4816
by: robert demo via AccessMonster.com | last post by:
In my startup routine, I have the following code: s = CLng(FileLen(filespec) / 1000000) If s > 5 Then 'FIRST, BACKUP THE FRONT END If BackupFrontEnd = False Then Exit Function End If
2
1727
by: Riley DeWiley | last post by:
I have a C++/OleDB project that is compacting an access db on-the-fly. I close all my sessions, and close the DB. When I call IJetCompact::Compact(), I get back E_FAIL. The same file, when pulled in to Access, will compact just fine from the IDE. I do not have a failure record in the database after a failure is recorded. I am using Jet 4.0. ...
9
3984
by: Ron | last post by:
New discovery. If I take a perfectly good database, and "compact/repair" on it with Access 2000 (seems to be at multiple sites--I've tried it with my system here, at another office on an entirely different network), it damages the file somehow. The user's machine that did the compact/repair can see the file fine. But any networked user...
2
1777
by: RZ15 | last post by:
Hi, I was working on a query this morning and everything was working fine. Some time in the last half hour, I used the Compact & Repair Database feature. After that, when I went to open the query in design view, and also tried to run the query afterwards, they both gave me the same result: Access would close with no error message at all. I...
29
2759
by: Neil | last post by:
I would like to compact on close only if the database size goes over a certain amount, rather than each time. Thus, I'd like to check the file size and then perform the compact through code as the mdb's closing. Is that possible? I suppose one option would be to set the Compact On Close option in the switchboard's On Close event, and then...
2
5135
by: Icarus | last post by:
I've got several Access 2000 databases that are currently being run with Access 2007. When the databases close, I've got them set to compact on close. This creates the database1.mdb file, however once the database has finished compacting and the database is closed, the database1.mdb still remains in the folder. As a result, the next time...
0
7854
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
8132
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8296
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7878
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8157
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5349
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3790
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3806
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1118
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.