473,657 Members | 2,776 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Database Help

g
Hi,
I have an MS Access 2000 Database on a network. When ever 2 people use it at
the same time it crashes. The database size is 14 megs. I have another
database just like it...and it has not experienced any problems like this.
It is about 5 MB. I don't think that size will matter? Anyhow the crashes
occur usually when someone is using a form, and another person opends up a
database and then in a given ammount of time closes it. Afterwords I cannot
open the database. I was able to fix this with the JetComp tools though. But
it would be nice if these crashed did not occur at all.

Thanks.
Nov 12 '05 #1
6 2373
TC
Maybe saying what the error message is (from the 50 gazillion messages that
it could be), might help someone answer?

TC
"g" <--*@sdlf.com> wrote in message news:bn******** **@mozo.cc.purd ue.edu...
Hi,
I have an MS Access 2000 Database on a network. When ever 2 people use it at the same time it crashes. The database size is 14 megs. I have another
database just like it...and it has not experienced any problems like this.
It is about 5 MB. I don't think that size will matter? Anyhow the crashes
occur usually when someone is using a form, and another person opends up a
database and then in a given ammount of time closes it. Afterwords I cannot open the database. I was able to fix this with the JetComp tools though. But it would be nice if these crashed did not occur at all.

Thanks.

Nov 12 '05 #2
g
Sorry,
I enter database password. The I get a popup message...
The error I'm getting is "The database <file name> needs to be repaired or
isn't a microsoft access databse. Do you want to repair the database?'
I click yes.
Another pop-up "password not recognized"
I click ok.
Another popup: "The database <filename> can't be repaired or isn't a MS
access database."
I click ok.
Then again I get not a valid password. I click ok...then get grey screen.
I can repair the databse with the JetComp utility, but I would had to use
this every day when it crashes.

Thanks
"TC" <a@b.c.d> wrote in message news:1066803679 .502327@teuthos ...
Maybe saying what the error message is (from the 50 gazillion messages that it could be), might help someone answer?

TC
"g" <--*@sdlf.com> wrote in message news:bn******** **@mozo.cc.purd ue.edu...
Hi,
I have an MS Access 2000 Database on a network. When ever 2 people use it at
the same time it crashes. The database size is 14 megs. I have another
database just like it...and it has not experienced any problems like

this. It is about 5 MB. I don't think that size will matter? Anyhow the crashes occur usually when someone is using a form, and another person opends up a database and then in a given ammount of time closes it. Afterwords I

cannot
open the database. I was able to fix this with the JetComp tools though.

But
it would be nice if these crashed did not occur at all.

Thanks.


Nov 12 '05 #3
TC
Ok. Those messages certainly suggest that the database file is corrupt.

But you say: "When ever 2 people use it at the same time it crashes". In
what way does it "crash"? Does the PC just hang, or is there a message, or
some other symptom? This is what really needs more explanation.

HTH,
TC
"g" <--*@sdlf.com> wrote in message news:bn******** **@mozo.cc.purd ue.edu...
Sorry,
I enter database password. The I get a popup message...
The error I'm getting is "The database <file name> needs to be repaired or
isn't a microsoft access databse. Do you want to repair the database?'
I click yes.
Another pop-up "password not recognized"
I click ok.
Another popup: "The database <filename> can't be repaired or isn't a MS
access database."
I click ok.
Then again I get not a valid password. I click ok...then get grey screen.
I can repair the databse with the JetComp utility, but I would had to use
this every day when it crashes.

Thanks
"TC" <a@b.c.d> wrote in message news:1066803679 .502327@teuthos ...
Maybe saying what the error message is (from the 50 gazillion messages that
it could be), might help someone answer?

TC
"g" <--*@sdlf.com> wrote in message

news:bn******** **@mozo.cc.purd ue.edu...
Hi,
I have an MS Access 2000 Database on a network. When ever 2 people use it
at
the same time it crashes. The database size is 14 megs. I have another
database just like it...and it has not experienced any problems like this. It is about 5 MB. I don't think that size will matter? Anyhow the crashes occur usually when someone is using a form, and another person opends
up a database and then in a given ammount of time closes it. Afterwords I

cannot
open the database. I was able to fix this with the JetComp tools

though. But
it would be nice if these crashed did not occur at all.

Thanks.



Nov 12 '05 #4
Hello,

I have exactly the same problem.
My database is now 13MB. There are more or less 60 users who use it
simultaneously, and sometimes (one or twice per week), when somebody try to
open it, he get the problem you describe. The users who already opened the
database can continue to work
The only way to repair is to ask to everybody to get out of the program,
then compact the database with the JETCOMP tool.

Hope somebody can help.

Guy

"g" <--*@sdlf.com> wrote in message news:bn******** **@mozo.cc.purd ue.edu...
Sorry,
I enter database password. The I get a popup message...
The error I'm getting is "The database <file name> needs to be repaired or
isn't a microsoft access databse. Do you want to repair the database?'
I click yes.
Another pop-up "password not recognized"
I click ok.
Another popup: "The database <filename> can't be repaired or isn't a MS
access database."
I click ok.
Then again I get not a valid password. I click ok...then get grey screen.
I can repair the databse with the JetComp utility, but I would had to use
this every day when it crashes.

Thanks
"TC" <a@b.c.d> wrote in message news:1066803679 .502327@teuthos ...
Maybe saying what the error message is (from the 50 gazillion messages that
it could be), might help someone answer?

TC
"g" <--*@sdlf.com> wrote in message

news:bn******** **@mozo.cc.purd ue.edu...
Hi,
I have an MS Access 2000 Database on a network. When ever 2 people use it
at
the same time it crashes. The database size is 14 megs. I have another
database just like it...and it has not experienced any problems like this. It is about 5 MB. I don't think that size will matter? Anyhow the crashes occur usually when someone is using a form, and another person opends
up a database and then in a given ammount of time closes it. Afterwords I

cannot
open the database. I was able to fix this with the JetComp tools

though. But
it would be nice if these crashed did not occur at all.

Thanks.



Nov 12 '05 #5
TC
How is your application structured? Is it a "front-end/back-end" situation?
Does each user have their own seperate copy of the front-end?

TC
"Guy Cauwenbergh" <gc**@ifrance.c om> wrote in message
news:fb******** *************** *******@news.te ranews.com...
Hello,

I have exactly the same problem.
My database is now 13MB. There are more or less 60 users who use it
simultaneously, and sometimes (one or twice per week), when somebody try to open it, he get the problem you describe. The users who already opened the
database can continue to work
The only way to repair is to ask to everybody to get out of the program,
then compact the database with the JETCOMP tool.

Hope somebody can help.

Guy

"g" <--*@sdlf.com> wrote in message news:bn******** **@mozo.cc.purd ue.edu...
Sorry,
I enter database password. The I get a popup message...
The error I'm getting is "The database <file name> needs to be repaired or
isn't a microsoft access databse. Do you want to repair the database?'
I click yes.
Another pop-up "password not recognized"
I click ok.
Another popup: "The database <filename> can't be repaired or isn't a MS
access database."
I click ok.
Then again I get not a valid password. I click ok...then get grey screen. I can repair the databse with the JetComp utility, but I would had to use this every day when it crashes.

Thanks
"TC" <a@b.c.d> wrote in message news:1066803679 .502327@teuthos ...
Maybe saying what the error message is (from the 50 gazillion messages

that
it could be), might help someone answer?

TC
"g" <--*@sdlf.com> wrote in message

news:bn******** **@mozo.cc.purd ue.edu...
> Hi,
> I have an MS Access 2000 Database on a network. When ever 2 people use
it
at
> the same time it crashes. The database size is 14 megs. I have

another > database just like it...and it has not experienced any problems like

this.
> It is about 5 MB. I don't think that size will matter? Anyhow the

crashes
> occur usually when someone is using a form, and another person

opends up
a
> database and then in a given ammount of time closes it. Afterwords I
cannot
> open the database. I was able to fix this with the JetComp tools

though. But
> it would be nice if these crashed did not occur at all.
>
> Thanks.
>
>



Nov 12 '05 #6
"TC" <a@b.c.d> wrote in message news:1066960296 .167929@teuthos ...
How is your application structured? Is it a "front-end/back-end" situation? Does each user have their own seperate copy of the front-end?


I use MsAccess just as database. My application is written in another
language and I access the db by odbc.

Thanks for your response
Guy
Nov 12 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
3344
by: cooldv | last post by:
i am running a website on Windows 2000 server with ASP 3 webpages and Access 2000 database. (with a hosting company) traffic is slow at this time but expect to grow. lately i have been reading about sql database and sql server, specially this article: http://www.aspfaq.com/show.asp?id=2195 will someone help me understand: 1. with *SQL Server*, do i keep my current Access 2000 database and ASP pages?
4
4016
by: George Stout | last post by:
First off I do not know alot about writing queries to an Access Database from an ASP page. This is why I need help. I have an Events database for 6 colleges in our metro area. On the homepage I have to display the next event for each college. That would give me 6 events listed on the page. I have been trying to figure out how to write a query statement in my ASP page to select just the most current event from each college. I have not had...
19
2083
by: nospammmer | last post by:
Hello group, I have a rather general but interesting inquiry that is related to PHP and I hope this is the appropriate place to post it. I'm looking for a way to improve dramatically the performance of my PHP application. The application is getting slow as it is taking more load. It is performing a very high number of queries to a database, and I believe that this is taking up most of the ressources.
6
7335
by: Marvin Libson | last post by:
Hi All: I am running DB2 UDB V7.2 with FP11. Platform is Windows 2000. I have created a java UDF and trigger. When I update my database I get the following error: SQL1224N A database agent could not be started to service a request, or was terminated as a result of a database system shutdown or a force command.
0
2267
by: Alex | last post by:
Hi all, I've been running a db2 V8.1 databasle to store my radius server accounting info for a *long* time and have never had any problems with it. Last week we had a power outage in our computer room and since then I've been having problems with one of the 3 db2 instances running on my server ( BTW 8.1 FP4). The databases on the other 2 instances work fine but as far as the radius server one is concerned whenever i try
5
3004
by: Bec | last post by:
I'm in desperate need of your help.. I need to build an access database and have NO idea how to do this.. Not even where to start.. It IS for school, and am not asking anyone to do my homework for me.. I am merely asking for help, perhaps pointers as to where to begin.. I've never used access before.. I'm rather cluey when it comes to
12
2774
by: Ann Marinas | last post by:
Hi all, I would like to ask for some help regarding separating the asp.net webserver and the sql server. I have created an asp.net application for a certain company. Initially, we installed both the iis and sql server in a single machine. Not too long ago, the machine had some hardware problems, and management has decided to purchase new servers, for both asp.net and sql server.
9
3824
by: Wayne Smith | last post by:
I've come up against a major headache that I can't seem to find a solution for but I'm sure there must be a workaround and I would really be grateful of any help. I'm currently building a web site for a small club I belong to and one of the features I would like to include is the ability to allow users to upload image files. unfortunately the servers web root www folder only allows READ and EXECUTE permissions, which makes it...
18
9129
by: surfrat_ | last post by:
Hi, I am having the following problems in getting Microsoft Visual Studio 2005 Professional to link to an Access .mdb database. Please help me to sort this out. Problem 1: The Microsoft page "How to: Connect to Data in an Access Database"
12
3931
by: grace | last post by:
i am wondering why my database retrieval becomes too slow...we set up a new server (ubuntu, breezy badger) machine where we transferred all our files from the old server.. Our new server uses Asus p5pe-vm motherboard and an Intel Pentium D 3.0Ghz processor, compared to the old one where we uses asrock motherboard and AMD Duron. Both has the same version of mysql installed... To summarized, both machine has the same configuration except...
0
8403
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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8833
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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8737
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 captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8509
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,...
0
8610
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7345
agi2029
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...
0
4168
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...
1
2735
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
2
1967
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.