We are using an Access 2000 application on a Windows NT / Citix server. The
app is split into a front end and back end mdb, and each user has the front
end mdb in their own folder.
Since we have put the front end mdb into each user's folder, I've noticed
the appearance in some of them of db1.mdb, db2.mdb etc.
It seems like these files are created when the users start their
applications, then closed and deleted when they exit the app. I suspect
that these files have been left behind when the server was rebooted while
the application was open for these users.
What is the function of these files and how can they be deleted? Is there
anyway to eliminate this problem short of not rebooting the server?
Many thanks,
Mike Thomas 4 5292
"Mike Thomas" <mi**@ease.co m> skrev i en meddelelse
news:QG******** *********@newss vr28.news.prodi gy.com... We are using an Access 2000 application on a Windows NT / Citix server.
The app is split into a front end and back end mdb, and each user has the
front end mdb in their own folder.
Since we have put the front end mdb into each user's folder, I've noticed the appearance in some of them of db1.mdb, db2.mdb etc.
It seems like these files are created when the users start their applications, then closed and deleted when they exit the app. I suspect that these files have been left behind when the server was rebooted while the application was open for these users.
What is the function of these files and how can they be deleted? Is there anyway to eliminate this problem short of not rebooting the server?
Many thanks, Mike Thomas
Hi Mike, just a thougt, but are the databases set to be compresed on exit ?
Best regards
Stef
Mike,
The db1.mdb, db2.mdb etc. files are being created because your users are trying
to create new database files. When you try to create a new database, Access
first requires you to create and save a file name for the database. Access
defaults to dbX.mdb for the file name and then provides you an opportunity to
give the file a name of your choice.
Your application apparently displays the Access menu at the top allowing the
users full access to Access as well as the application. If you would put a
custom menu at the top of your aplication, you would no longer see db1.mdb,
db2.mdb etc. because the users could no longer create new databases.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications re******@pcdata sheet.com www.pcdatasheet.com
"Mike Thomas" <mi**@ease.co m> wrote in message
news:QG******** *********@newss vr28.news.prodi gy.com... We are using an Access 2000 application on a Windows NT / Citix server. The app is split into a front end and back end mdb, and each user has the front end mdb in their own folder.
Since we have put the front end mdb into each user's folder, I've noticed the appearance in some of them of db1.mdb, db2.mdb etc.
It seems like these files are created when the users start their applications, then closed and deleted when they exit the app. I suspect that these files have been left behind when the server was rebooted while the application was open for these users.
What is the function of these files and how can they be deleted? Is there anyway to eliminate this problem short of not rebooting the server?
Many thanks, Mike Thomas
Stef,
Not bad, yes they are, I had not thought of this. Some are getting left
behind. Is there a reason?
Thanks
Mike Thomas
"Steffen Beck" <sr*@srd.dk> wrote in message
news:40******** *************** @dread15.news.t ele.dk... "Mike Thomas" <mi**@ease.co m> skrev i en meddelelse news:QG******** *********@newss vr28.news.prodi gy.com... We are using an Access 2000 application on a Windows NT / Citix server. The app is split into a front end and back end mdb, and each user has the front end mdb in their own folder.
Since we have put the front end mdb into each user's folder, I've
noticed the appearance in some of them of db1.mdb, db2.mdb etc.
It seems like these files are created when the users start their applications, then closed and deleted when they exit the app. I suspect that these files have been left behind when the server was rebooted
while the application was open for these users.
What is the function of these files and how can they be deleted? Is
there anyway to eliminate this problem short of not rebooting the server?
Many thanks, Mike Thomas
Hi Mike, just a thougt, but are the databases set to be compresed on exit
? Best regards Stef
Many thanks,
I think Stef had it right in the first post.
Mike Thomas
"PC Datasheet" <sp**@nospam.sp am> wrote in message
news:rN******** *********@newsr ead1.news.atl.e arthlink.net... Mike,
The db1.mdb, db2.mdb etc. files are being created because your users are
trying to create new database files. When you try to create a new database,
Access first requires you to create and save a file name for the database. Access defaults to dbX.mdb for the file name and then provides you an opportunity
to give the file a name of your choice.
Your application apparently displays the Access menu at the top allowing
the users full access to Access as well as the application. If you would put a custom menu at the top of your aplication, you would no longer see
db1.mdb, db2.mdb etc. because the users could no longer create new databases.
-- PC Datasheet Your Resource For Help With Access, Excel And Word Applications re******@pcdata sheet.com www.pcdatasheet.com
"Mike Thomas" <mi**@ease.co m> wrote in message news:QG******** *********@newss vr28.news.prodi gy.com... We are using an Access 2000 application on a Windows NT / Citix server.
The app is split into a front end and back end mdb, and each user has the
front end mdb in their own folder.
Since we have put the front end mdb into each user's folder, I've
noticed the appearance in some of them of db1.mdb, db2.mdb etc.
It seems like these files are created when the users start their applications, then closed and deleted when they exit the app. I suspect that these files have been left behind when the server was rebooted
while the application was open for these users.
What is the function of these files and how can they be deleted? Is
there anyway to eliminate this problem short of not rebooting the server?
Many thanks, Mike Thomas
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Erik Andersson |
last post by:
Hi!
I need to read a file (line-by-line) in reverse order, without reading the
whole file into memory first.
Is there an easy way of doing this? As in, is there a PHP function I could
use?
The solution has to be platform independent, so "popen("tac $filename")...
wouldn't work.
|
by: Count Dracula |
last post by:
Is there a way to write a c++ program that will
print out the last few lines of a file without reading
the whole file? The implementations of 'tail' I have
seen all appear to be system dependent. I am looking for
a standard (portable) c++ solution that will do just a
fraction of tail's functionality. To make a long story short,
I am looking for suggestions that may help me improve the
speed of the following implementation for long input...
|
by: Ian Taite |
last post by:
Hello,
I'm exploring why one of my C# .NET apps has "high" memory usage, and
whether I can reduce the memory usage.
I have an app that wakes up and processes text files into a database
periodically. What happens, is that the app reads the contents of a
text file line by line into an ArrayList. Each element of the ArrayList
is a string representing a record from the file. The ArrayList is then
processed, and the arraylist goes out of...
|
by: mail2atulmehta |
last post by:
Hi,
I do not know if this is right place for this, but i need some help. I
have a text file, whose values are seprated by a delimiter. I want to
open this file in excel, ( not import it) . I have written the driver
prg in c#. The code opens the file, but it is not writting the values
from text file into excel file. I can not figure out the problem here.
This is my code:
StreamReader dataFileReader = null;
FileInfo file = null;...
|
by: dgoel |
last post by:
Hi,
I Have a text file & I want to open it in excel sheet ( withou
importing). I have written code for it, but it is not opening exce
sheet. It opens the text file, but does not create a excel sheet
populate it. I do not know what the problem is, can someone please hel
out with this one,
Here is my code:
StreamReader dataFileReader = null;
FileInfo file = null;
Excel.Application ExcelObj = new Excel.Application();
| |
by: LBT |
last post by:
I have a window service written using VB.NET. This window service will scan
folders for file and grab the file content to be inserted to SQL Server on
file detection. There are altogether 18 folders to be watched. Each folder is
assigned with a timer for watching purpose. Hence there will be 18 timers and
each timer is set to elapse on every second.
Problem here, once the window service is installed and started, the CPU
usage is very...
|
by: News |
last post by:
Hi Everyone,
The attached code creates client connections to websphere queue managers
and then processes an inquiry against them.
The program functions when it gets options from the command line.
It also works when pulling the options from a file.
|
by: mrpincer21 |
last post by:
Could anyone help me by telling me how to create an excel document that monitors usage of many others by using visual basic program?
I currently produce excel reports for my company but need to somehow monitor how many times they are accessed and, if possible, when and by whom.
All these excel files are situated on a server that our company uses and all users systems are connected to this. We use office 2003 and Outlook as the emailing...
|
by: andrew.jefferies |
last post by:
Hi,
I'm trying to write a simple log parsing program. I noticed that it
isn't reading my log file to the end.
My log is around 200,000 lines but it is stopping at line 26,428. I
checked that line and there aren't any special characters.
This is the file reading code segment that I'm using:
sysFile=open(sysFilename,'r')
|
by: nma |
last post by:
Hi There,
I would like to create a log files/usage file that can show number of users using my system, how many times certain page was viewed, who are using most to the system, at what time etc.
What should I do? I'm developing a web based application.
Should I create a new table in MSSQL to store log data?
Thanks
|
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: 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: 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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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
|
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |