Hi, all our caseworkers currently use a database (file size 81.4MB) to hold
all the information on our clients. Since last week, we cannot open the
database or access the file. The following message appears;

"The Document 'casework.mdb' caused a serious error the last time it was
opened. Would you like to continue opening it?'

we click 'yes' and then another message appears;
'The database 'THE DATABASE PATH' needs to be repaired or isn't a database
file.
you or another user may have unexpectedly quit a Microsoft Office Access
while a Microsoft Office Access database was open.
Do you want Microsoft Office Access to attempt to repair the database?'

I click 'yes'

Then the SEND ERROR REPORT box opens and the program closes. We have just
found that the backup has not been working for a while, which means we stand
to lose alot of data if we cannot get the file to run.

I have tried searching google and support.microft, but haven't found
anything that helps. I downloaded Jetcomp but ain't having any luck.

Our network is running 'WINDOWS XP PROFESSIONAL VERSION 5.1, SERVICE PACK 2'
and 'MICROSOFT OFFICE ACCESS 2003'
any advice would be helpful, cheers,

Jamie O'Neill <(E-Mail Removed)> wrote:

> Hi, all our caseworkers currently use a database (file size 81.4MB) to
> hold all the information on our clients. Since last week, we cannot
> open the database or access the file. The following message appears;
>
> "The Document 'casework.mdb' caused a serious error the last time it
> was opened. Would you like to continue opening it?'

Not a Windows issue. Post to this group (via Newsreader):
news://msnews.microsoft.com/microsoft.public.access

--
d-d

Jamie,

If all the users are out of the database then you can compact & repair the
database

As this is obviously a network DB have you checked your profile? Maybe that
is corrupt & you may notice that other things are missing when you're logged
in. If someone else logs in to that machine, does the same error exist? If
not then it is a profile issue. Otherwise you need to look at your MS Access
install.

Will await your reply,

--
Newbie Coder
(It's just a name)
"Jamie O'Neill" <(E-Mail Removed)> wrote in message
news:CF0561C8-D59F-489C-8B40-(E-Mail Removed)...
> Hi, all our caseworkers currently use a database (file size 81.4MB) to
hold
> all the information on our clients. Since last week, we cannot open the
> database or access the file. The following message appears;
>
> "The Document 'casework.mdb' caused a serious error the last time it was
> opened. Would you like to continue opening it?'
>
> we click 'yes' and then another message appears;
> 'The database 'THE DATABASE PATH' needs to be repaired or isn't a database
> file.
> you or another user may have unexpectedly quit a Microsoft Office Access
> while a Microsoft Office Access database was open.
> Do you want Microsoft Office Access to attempt to repair the database?'
>
> I click 'yes'
>
> Then the SEND ERROR REPORT box opens and the program closes. We have just
> found that the backup has not been working for a while, which means we
stand
> to lose alot of data if we cannot get the file to run.
>
> I have tried searching google and support.microft, but haven't found
> anything that helps. I downloaded Jetcomp but ain't having any luck.
>
> Our network is running 'WINDOWS XP PROFESSIONAL VERSION 5.1, SERVICE PACK
2'
> and 'MICROSOFT OFFICE ACCESS 2003'
> any advice would be helpful, cheers,

I can't do that, i can't sent to it.
"Jamie O'Neill" wrote:

> Hi, all our caseworkers currently use a database (file size 81.4MB) to hold
> all the information on our clients. Since last week, we cannot open the
> database or access the file. The following message appears;
>
> "The Document 'casework.mdb' caused a serious error the last time it was
> opened. Would you like to continue opening it?'
>
> we click 'yes' and then another message appears;
> 'The database 'THE DATABASE PATH' needs to be repaired or isn't a database
> file.
> you or another user may have unexpectedly quit a Microsoft Office Access
> while a Microsoft Office Access database was open.
> Do you want Microsoft Office Access to attempt to repair the database?'
>
> I click 'yes'
>
> Then the SEND ERROR REPORT box opens and the program closes. We have just
> found that the backup has not been working for a while, which means we stand
> to lose alot of data if we cannot get the file to run.
>
> I have tried searching google and support.microft, but haven't found
> anything that helps. I downloaded Jetcomp but ain't having any luck.
>
> Our network is running 'WINDOWS XP PROFESSIONAL VERSION 5.1, SERVICE PACK 2'
> and 'MICROSOFT OFFICE ACCESS 2003'
> any advice would be helpful, cheers,

noone on our server can access it. The file is saved on our server. How do I
compact it? I tried using Jetcomp, but that didn't work.

I thought perhaps we would need an updated service pack, but would that not
just stop the problem in future?

"Jamie O'Neill" wrote:

> Hi, all our caseworkers currently use a database (file size 81.4MB) to hold
> all the information on our clients. Since last week, we cannot open the
> database or access the file. The following message appears;
>
> "The Document 'casework.mdb' caused a serious error the last time it was
> opened. Would you like to continue opening it?'
>
> we click 'yes' and then another message appears;
> 'The database 'THE DATABASE PATH' needs to be repaired or isn't a database
> file.
> you or another user may have unexpectedly quit a Microsoft Office Access
> while a Microsoft Office Access database was open.
> Do you want Microsoft Office Access to attempt to repair the database?'
>
> I click 'yes'
>
> Then the SEND ERROR REPORT box opens and the program closes. We have just
> found that the backup has not been working for a while, which means we stand
> to lose alot of data if we cannot get the file to run.
>
> I have tried searching google and support.microft, but haven't found
> anything that helps. I downloaded Jetcomp but ain't having any luck.
>
> Our network is running 'WINDOWS XP PROFESSIONAL VERSION 5.1, SERVICE PACK 2'
> and 'MICROSOFT OFFICE ACCESS 2003'
> any advice would be helpful, cheers,

Jamie O'Neill wrote:
> noone on our server can access it. The file is saved on our server. How do I
> compact it? I tried using Jetcomp, but that didn't work.
>
> I thought perhaps we would need an updated service pack, but would that not
> just stop the problem in future?

You mention "caseworkers". Where is your IT Dept.? Why are you not
calling them immediately? Also, make sure you have backups!

If you really want to try and get help in a newsgroup, do as previously
suggested and post to an Access newsgroup. Make sure you include the
version of Access that you are using. Troubleshooting Access databases
requires specialized skills and you don't want to be messing about with
this blindly.

http://aumha.org/nntp.htm - list of MS newsgroups


Malke
--
Elephant Boy Computers
www.elephantboycomputers.com
"Don't Panic!"
MS-MVP Windows - Shell/User

We are a small charity, dont have an it department. I will try access the
newsgroups but i dont have outlook express and dont know how to get it on my
outlook.

"Malke" wrote:

> Jamie O'Neill wrote:
> > noone on our server can access it. The file is saved on our server. How do I
> > compact it? I tried using Jetcomp, but that didn't work.
> >
> > I thought perhaps we would need an updated service pack, but would that not
> > just stop the problem in future?
>
> You mention "caseworkers". Where is your IT Dept.? Why are you not
> calling them immediately? Also, make sure you have backups!
>
> If you really want to try and get help in a newsgroup, do as previously
> suggested and post to an Access newsgroup. Make sure you include the
> version of Access that you are using. Troubleshooting Access databases
> requires specialized skills and you don't want to be messing about with
> this blindly.
>
> http://aumha.org/nntp.htm - list of MS newsgroups
>
>
> Malke
> --
> Elephant Boy Computers
> www.elephantboycomputers.com
> "Don't Panic!"
> MS-MVP Windows - Shell/User
>

Jamie O'Neill wrote:
> Hi, all our caseworkers currently use a database (file size 81.4MB) to hold
> all the information on our clients. Since last week, we cannot open the
> database or access the file. The following message appears;
>
> "The Document 'casework.mdb' caused a serious error the last time it was
> opened. Would you like to continue opening it?'
>
> we click 'yes' and then another message appears;
> 'The database 'THE DATABASE PATH' needs to be repaired or isn't a database
> file.
> you or another user may have unexpectedly quit a Microsoft Office Access
> while a Microsoft Office Access database was open.
> Do you want Microsoft Office Access to attempt to repair the database?'
>
> I click 'yes'
>
> Then the SEND ERROR REPORT box opens and the program closes. We have just
> found that the backup has not been working for a while, which means we stand
> to lose alot of data if we cannot get the file to run.
>
> I have tried searching google and support.microft, but haven't found
> anything that helps. I downloaded Jetcomp but ain't having any luck.
>
> Our network is running 'WINDOWS XP PROFESSIONAL VERSION 5.1, SERVICE PACK 2'
> and 'MICROSOFT OFFICE ACCESS 2003'
> any advice would be helpful, cheers,


Sounds like it's irretrievably corrupted. Restore it from the most
recent backup.


--

Bruce Chambers

Help us help you:
http://dts-l.org/goodpost.htm
http://www.catb.org/~esr/faqs/smart-questions.html

They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety. -Benjamin Franklin

Many people would rather die than think; in fact, most do. -Bertrand Russell

Jamie O'Neill wrote:
> We are a small charity, dont have an it department. I will try access the
> newsgroups but i dont have outlook express and dont know how to get it on my
> outlook.

Small charity or not, what will happen if you destroy your database? You
always have the option of having a local professional come on-site. I
understand that you want to save money, but there's no sense in being
penny-wise, pound-foolish. I'm not trying to be too harsh with you so
please don't be hurt; it's just that my clients are small businesses
just like you and I know first-hand what can happen. So please take my
cautions to you as coming from someone who cares.

If you have Windows XP, you have Outlook Express. Outlook will call the
newsgroups using OE. Here are instructions:

Using Outlook Express as Newsreader:
http://michaelstevenstech.com/outloo...snewreader.htm
http://rickrogers.org/setupoe.htm
Accessing the MS newsgroups in Outlook Express Newsreader
http://www.microsoft.com/windowsxp/e...roupsetup.mspx

How to Post:
http://www.dts-l.org/goodpost.htm
http://www.catb.org/~esr/faqs/smart-questions.html
http://aumha.org/nntp.htm - list of MS newsgroups
microsoft.public.test.here - MS group to test if your newsreader is
working properly
http://www3.telus.net/dandemar/munad.htm - how to munge email address
http://www.blakjak.demon.co.uk/mul_crss.htm - multiposting vs. crossposting

Malke
--
Elephant Boy Computers
www.elephantboycomputers.com
"Don't Panic!"
MS-MVP Windows - Shell/User

Jamie O'Neill wrote:
> Hi, all our caseworkers currently use a database (file size 81.4MB) to hold
> all the information on our clients. Since last week, we cannot open the
> database or access the file. The following message appears;
>
> "The Document 'casework.mdb' caused a serious error the last time it was
> opened. Would you like to continue opening it?'
>
> we click 'yes' and then another message appears;
> 'The database 'THE DATABASE PATH' needs to be repaired or isn't a database
> file.
> you or another user may have unexpectedly quit a Microsoft Office Access
> while a Microsoft Office Access database was open.
> Do you want Microsoft Office Access to attempt to repair the database?'
>
> I click 'yes'
>
> Then the SEND ERROR REPORT box opens and the program closes. We have just
> found that the backup has not been working for a while, which means we stand
> to lose alot of data if we cannot get the file to run.
>
> I have tried searching google and support.microft, but haven't found
> anything that helps. I downloaded Jetcomp but ain't having any luck.
>
> Our network is running 'WINDOWS XP PROFESSIONAL VERSION 5.1, SERVICE PACK 2'
> and 'MICROSOFT OFFICE ACCESS 2003'
> any advice would be helpful, cheers,

Hi Jamie,

I haven't done any pro bono work for 2007. The e-mail address here
is valid if you can show proof of 501(c)(3) status I will help you
out for free.

Sincerely,
C.Joseph S. Drayton, Ph.D. AS&T

http://csdcs.tlerma.com/