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
6  1657 
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
"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
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
"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
"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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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 and is there a fix? Thanks for any help,
|
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
|
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 info:
Windows XP Pro with SP1
|
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 skills are few and far between so this
is proving somewhat of a challenge. Because I am trying to...
|
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
| | |
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.
Any idea what is happening??
RDeW
|
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 can't get in. I can double click on a good
database file from any user (over the network) and it...
|
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 can't think of anything other than the Compact & Repair Database that could've done this. Now this isn't...
|
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 clear it whenever the database is
opened. That would probably work. But I'd prefer a cleaner...
|
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 the database closes, it
creates a database2, which it does not delete, and this continues each
time...
|
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 usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
| | |
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
