p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Unrecognized Database Format


Message #1 by "Enzo" <enzaux@g...> on Tue, 4 Jun 2002 15:01:59 +0800
	Hi and hello!!  I have this problem regarding the Subject.  At first I thought this won't bother me since the other Access
application is the one having this error.  So I'm not held responsible.  But only today,  I have found out that the Access
application that I've made was also having that error. :(  But the two applications are in different computers and also have
different users.  The first App was used on the first floor and the other one was on used by @nd floor people.

	Here's my database setup (for both application).  I have the main database reside on one workstation.  Then  I install a seperate
access Application on the other workstations and have their tables linked to the Main Database.  For the past few months it's
working out fine.  But suddenly one day one end user told me that he can't make any modifications or addition to the database.  And
the error was the database was in unrecognizeable format.  So what I did is that I compact and repair the database then it works
fine again. But after a few days here comes again the error so I need to compact and repair the databas.

	What do you think that causes the problem?  Please help, this gives me worries because there was one time that some records were
deleted after I compacted and repaired the database. Luckily I have a backup.  Please advise as soon as possible.

Thanks in advance,

Enzo




Message #2 by "Carnley, Dave" <dcarnley@a...> on Tue, 4 Jun 2002 09:16:13 -0500
If it is the main database that is becoming corrupt, then I would suggest
getting a new workstation for it.  You can try to track down what is causing
the corruption but chances are using a new box will stop this from
happening.  Is that workstation also being used by one of the users?  Use a
dedicated machine just for hosting the main database.

If it is the user's databases getting corrupted... then you've got to do
some digging.  Look for new software installed on the machines where it has
broken.  Find out of the users are having problems with other programs,
especially office programs. Our network guys are constantly rolling out
software "upgrades" (I use the term loosely) and stuff like that and
sometimes they break stuff.  Look for something that changed in the
environment about the time it started breaking.

Or it may be something else completely different.  Good Luck!

-----Original Message-----
From: Enzo [mailto:enzaux@g...]
Sent: Tuesday, June 04, 2002 2:02 AM
To: Access
Subject: [access] Unrecognized Database Format



	Hi and hello!!  I have this problem regarding the Subject.  At first
I thought this won't bother me since the other Access
application is the one having this error.  So I'm not held responsible.  But
only today,  I have found out that the Access
application that I've made was also having that error. :(  But the two
applications are in different computers and also have
different users.  The first App was used on the first floor and the other
one was on used by @nd floor people.

	Here's my database setup (for both application).  I have the main
database reside on one workstation.  Then  I install a seperate
access Application on the other workstations and have their tables linked to
the Main Database.  For the past few months it's
working out fine.  But suddenly one day one end user told me that he can't
make any modifications or addition to the database.  And
the error was the database was in unrecognizeable format.  So what I did is
that I compact and repair the database then it works
fine again. But after a few days here comes again the error so I need to
compact and repair the databas.

	What do you think that causes the problem?  Please help, this gives
me worries because there was one time that some records were
deleted after I compacted and repaired the database. Luckily I have a
backup.  Please advise as soon as possible.

Thanks in advance,

Enzo





Message #3 by "Enzo" <enzaux@g...> on Wed, 5 Jun 2002 13:25:36 +0800
Yes, the main database is becoming corrupt.  I ca't track down where the problem is.  but one thing I
suspect is because of the OS
I'm using because the workstation that holds the main database have win98 installed while those computers accesing have win2k
installed on their computers.  What do you mean by using a new box?

Thanks Dave!

Enzo

-----Original Message-----
From: Carnley, Dave [mailto:dcarnley@a...]
Sent: Tuesday, June 04, 2002 10:16 PM
To: Access
Subject: [access] RE: Unrecognized Database Format


If it is the main database that is becoming corrupt, then I would suggest
getting a new workstation for it.  You can try to track down what is causing
the corruption but chances are using a new box will stop this from
happening.  Is that workstation also being used by one of the users?  Use a
dedicated machine just for hosting the main database.

If it is the user's databases getting corrupted... then you've got to do
some digging.  Look for new software installed on the machines where it has
broken.  Find out of the users are having problems with other programs,
especially office programs. Our network guys are constantly rolling out
software "upgrades" (I use the term loosely) and stuff like that and
sometimes they break stuff.  Look for something that changed in the
environment about the time it started breaking.

Or it may be something else completely different.  Good Luck!

-----Original Message-----
From: Enzo [mailto:enzaux@g...]
Sent: Tuesday, June 04, 2002 2:02 AM
To: Access
Subject: [access] Unrecognized Database Format



	Hi and hello!!  I have this problem regarding the Subject.  At first
I thought this won't bother me since the other Access
application is the one having this error.  So I'm not held responsible.  But
only today,  I have found out that the Access
application that I've made was also having that error. :(  But the two
applications are in different computers and also have
different users.  The first App was used on the first floor and the other
one was on used by @nd floor people.

	Here's my database setup (for both application).  I have the main
database reside on one workstation.  Then  I install a seperate
access Application on the other workstations and have their tables linked to
the Main Database.  For the past few months it's
working out fine.  But suddenly one day one end user told me that he can't
make any modifications or addition to the database.  And
the error was the database was in unrecognizeable format.  So what I did is
that I compact and repair the database then it works
fine again. But after a few days here comes again the error so I need to
compact and repair the databas.

	What do you think that causes the problem?  Please help, this gives
me worries because there was one time that some records were
deleted after I compacted and repaired the database. Luckily I have a
backup.  Please advise as soon as possible.

Thanks in advance,

Enzo









Message #4 by "George Oro" <george@c...> on Wed, 5 Jun 2002 17:42:21 +0400
Enzo,
Just an info:
I had faced this problem three months back in one of my client. The scenario is, the database is in Access2000 then I configured one
new client's machine having AccessXP. Every time this new machine will run the database, the entire database will get corrupted,
fortunately I always got a change to repair it. I cannot see where's the problem is but I'm sure it's originated from that new
machine so I convinced my client to remove the database on that machine rather than taking a risk.


Cheers,
George

-----Original Message-----
From: Enzo [mailto:enzaux@g...]
Sent: Wednesday, June 05, 2002 9:26 AM
To: Access
Subject: [access] RE: Unrecognized Database Format


Yes, the main database is becoming corrupt.  I ca't track down where the problem is.  but one thing I suspect is because of the OS
I'm using because the workstation that holds the main database have win98 installed while those computers accesing have win2k
installed on their computers.  What do you mean by using a new box?

Thanks Dave!

Enzo

-----Original Message-----
From: Carnley, Dave [mailto:dcarnley@a...]
Sent: Tuesday, June 04, 2002 10:16 PM
To: Access
Subject: [access] RE: Unrecognized Database Format


If it is the main database that is becoming corrupt, then I would suggest
getting a new workstation for it.  You can try to track down what is causing
the corruption but chances are using a new box will stop this from
happening.  Is that workstation also being used by one of the users?  Use a
dedicated machine just for hosting the main database.

If it is the user's databases getting corrupted... then you've got to do
some digging.  Look for new software installed on the machines where it has
broken.  Find out of the users are having problems with other programs,
especially office programs. Our network guys are constantly rolling out
software "upgrades" (I use the term loosely) and stuff like that and
sometimes they break stuff.  Look for something that changed in the
environment about the time it started breaking.

Or it may be something else completely different.  Good Luck!

-----Original Message-----
From: Enzo [mailto:enzaux@g...]
Sent: Tuesday, June 04, 2002 2:02 AM
To: Access
Subject: [access] Unrecognized Database Format



	Hi and hello!!  I have this problem regarding the Subject.  At first
I thought this won't bother me since the other Access
application is the one having this error.  So I'm not held responsible.  But
only today,  I have found out that the Access
application that I've made was also having that error. :(  But the two
applications are in different computers and also have
different users.  The first App was used on the first floor and the other
one was on used by @nd floor people.

	Here's my database setup (for both application).  I have the main
database reside on one workstation.  Then  I install a seperate
access Application on the other workstations and have their tables linked to
the Main Database.  For the past few months it's
working out fine.  But suddenly one day one end user told me that he can't
make any modifications or addition to the database.  And
the error was the database was in unrecognizeable format.  So what I did is
that I compact and repair the database then it works
fine again. But after a few days here comes again the error so I need to
compact and repair the databas.

	What do you think that causes the problem?  Please help, this gives
me worries because there was one time that some records were
deleted after I compacted and repaired the database. Luckily I have a
backup.  Please advise as soon as possible.

Thanks in advance,

Enzo











Message #5 by "Carnley, Dave" <dcarnley@a...> on Wed, 5 Jun 2002 09:20:30 -0500
yes, exactly - a "box" is a computer - I meant get a new computer to host
your main database.  Get a windows 2k machine for your main database and my
guess is this problem goes away.



-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: Wednesday, June 05, 2002 8:42 AM
To: Access
Subject: [access] RE: Unrecognized Database Format


Enzo,
Just an info:
I had faced this problem three months back in one of my client. The scenario
is, the database is in Access2000 then I configured one
new client's machine having AccessXP. Every time this new machine will run
the database, the entire database will get corrupted,
fortunately I always got a change to repair it. I cannot see where's the
problem is but I'm sure it's originated from that new
machine so I convinced my client to remove the database on that machine
rather than taking a risk.


Cheers,
George

-----Original Message-----
From: Enzo [mailto:enzaux@g...]
Sent: Wednesday, June 05, 2002 9:26 AM
To: Access
Subject: [access] RE: Unrecognized Database Format


Yes, the main database is becoming corrupt.  I ca't track down where the
problem is.  but one thing I suspect is because of the OS
I'm using because the workstation that holds the main database have win98
installed while those computers accesing have win2k
installed on their computers.  What do you mean by using a new box?

Thanks Dave!

Enzo

-----Original Message-----
From: Carnley, Dave [mailto:dcarnley@a...]
Sent: Tuesday, June 04, 2002 10:16 PM
To: Access
Subject: [access] RE: Unrecognized Database Format


If it is the main database that is becoming corrupt, then I would suggest
getting a new workstation for it.  You can try to track down what is causing
the corruption but chances are using a new box will stop this from
happening.  Is that workstation also being used by one of the users?  Use a
dedicated machine just for hosting the main database.

If it is the user's databases getting corrupted... then you've got to do
some digging.  Look for new software installed on the machines where it has
broken.  Find out of the users are having problems with other programs,
especially office programs. Our network guys are constantly rolling out
software "upgrades" (I use the term loosely) and stuff like that and
sometimes they break stuff.  Look for something that changed in the
environment about the time it started breaking.

Or it may be something else completely different.  Good Luck!

-----Original Message-----
From: Enzo [mailto:enzaux@g...]
Sent: Tuesday, June 04, 2002 2:02 AM
To: Access
Subject: [access] Unrecognized Database Format



	Hi and hello!!  I have this problem regarding the Subject.  At first
I thought this won't bother me since the other Access
application is the one having this error.  So I'm not held responsible.  But
only today,  I have found out that the Access
application that I've made was also having that error. :(  But the two
applications are in different computers and also have
different users.  The first App was used on the first floor and the other
one was on used by @nd floor people.

	Here's my database setup (for both application).  I have the main
database reside on one workstation.  Then  I install a seperate
access Application on the other workstations and have their tables linked to
the Main Database.  For the past few months it's
working out fine.  But suddenly one day one end user told me that he can't
make any modifications or addition to the database.  And
the error was the database was in unrecognizeable format.  So what I did is
that I compact and repair the database then it works
fine again. But after a few days here comes again the error so I need to
compact and repair the databas.

	What do you think that causes the problem?  Please help, this gives
me worries because there was one time that some records were
deleted after I compacted and repaired the database. Luckily I have a
backup.  Please advise as soon as possible.

Thanks in advance,

Enzo












Message #6 by "Enzo" <enzaux@g...> on Thu, 6 Jun 2002 08:46:29 +0800
George,

	Thanks for the advice.  But I'm still not quite sure if I'm correct with my suspicion that the OS issue is the culprit because the
database is being corrupted not succesively, sometimes it would run for few days then wholla it would suddenly crash again.

	It can be fixed with Compact and Repair BUT the big problem is ......IT DELETES SOME RECORDS ON MY TABLE!!! That's the worst thing
:(  There was one time that it deleted a lot of records and I have nothing to do but to take the old records to patch up the lost
records on the current database which is VERY risky and cumbersome to find what's lost and what's needed.

Thanks,

Enzo

-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: Wednesday, June 05, 2002 9:42 PM
To: Access
Subject: [access] RE: Unrecognized Database Format


Enzo,
Just an info:
I had faced this problem three months back in one of my client. The scenario is, the database is in Access2000 then I configured
one
new client's machine having AccessXP. Every time this new machine will run the database, the entire database will get corrupted,
fortunately I always got a change to repair it. I cannot see where's the problem is but I'm sure it's originated from that new
machine so I convinced my client to remove the database on that machine rather than taking a risk.


Cheers,
George

-----Original Message-----
From: Enzo [mailto:enzaux@g...]
Sent: Wednesday, June 05, 2002 9:26 AM
To: Access
Subject: [access] RE: Unrecognized Database Format


Yes, the main database is becoming corrupt.  I ca't track down where the problem is.  but one thing I suspect is because of the OS
I'm using because the workstation that holds the main database have win98 installed while those computers accesing have win2k
installed on their computers.  What do you mean by using a new box?

Thanks Dave!

Enzo

-----Original Message-----
From: Carnley, Dave [mailto:dcarnley@a...]
Sent: Tuesday, June 04, 2002 10:16 PM
To: Access
Subject: [access] RE: Unrecognized Database Format


If it is the main database that is becoming corrupt, then I would suggest
getting a new workstation for it.  You can try to track down what is causing
the corruption but chances are using a new box will stop this from
happening.  Is that workstation also being used by one of the users?  Use a
dedicated machine just for hosting the main database.

If it is the user's databases getting corrupted... then you've got to do
some digging.  Look for new software installed on the machines where it has
broken.  Find out of the users are having problems with other programs,
especially office programs. Our network guys are constantly rolling out
software "upgrades" (I use the term loosely) and stuff like that and
sometimes they break stuff.  Look for something that changed in the
environment about the time it started breaking.

Or it may be something else completely different.  Good Luck!

-----Original Message-----
From: Enzo [mailto:enzaux@g...]
Sent: Tuesday, June 04, 2002 2:02 AM
To: Access
Subject: [access] Unrecognized Database Format



	Hi and hello!!  I have this problem regarding the Subject.  At first
I thought this won't bother me since the other Access
application is the one having this error.  So I'm not held responsible.  But
only today,  I have found out that the Access
application that I've made was also having that error. :(  But the two
applications are in different computers and also have
different users.  The first App was used on the first floor and the other
one was on used by @nd floor people.

	Here's my database setup (for both application).  I have the main
database reside on one workstation.  Then  I install a seperate
access Application on the other workstations and have their tables linked to
the Main Database.  For the past few months it's
working out fine.  But suddenly one day one end user told me that he can't
make any modifications or addition to the database.  And
the error was the database was in unrecognizeable format.  So what I did is
that I compact and repair the database then it works
fine again. But after a few days here comes again the error so I need to
compact and repair the databas.

	What do you think that causes the problem?  Please help, this gives
me worries because there was one time that some records were
deleted after I compacted and repaired the database. Luckily I have a
backup.  Please advise as soon as possible.

Thanks in advance,

Enzo
















  Return to Index