Database needs to be repaired HELP!!!
 

Hello everyone, thanks for taking the time to help me with this issue.

I have built an automated timesheet for my company using Excel whic
quieries an access database. If the admin are working on the databas
users sometimes get an error on the timesheet saying something on th
lines of

Database Xxxxx.dbs Needs to be repaired!

I understand that this is an unsupressable error that is generated b
Excel, What i was wondering was is there a way to check if the databas
is available or.... working properly and if not, skip the code tha
generates the unsupressable error? (btw the error is caused by m
quiering the database).

Thanks for your help

Gree

--
greenfalco
-----------------------------------------------------------------------
greenfalcon's Profile: http://www.excelforum.com/member.php...fo&userid=1362
View this thread: http://www.excelforum.com/showthread.php?threadid=39112

Database needs to be repaired HELP!!!
 

any help with this error

--
greenfalco
-----------------------------------------------------------------------
greenfalcon's Profile: http://www.excelforum.com/member.php...fo&userid=1362
View this thread: http://www.excelforum.com/showthread.php?threadid=39112

Database needs to be repaired HELP!!!
 

You may want to try one of the Access newsgroups if you don't get a good reply
here.

greenfalcon wrote:

Hello everyone, thanks for taking the time to help me with this issue.

I have built an automated timesheet for my company using Excel which
quieries an access database. If the admin are working on the database
users sometimes get an error on the timesheet saying something on the
lines of

Database Xxxxx.dbs Needs to be repaired!

I understand that this is an unsupressable error that is generated by
Excel, What i was wondering was is there a way to check if the database
is available or.... working properly and if not, skip the code that
generates the unsupressable error? (btw the error is caused by me
quiering the database).

Thanks for your help

Green

--
greenfalcon
------------------------------------------------------------------------
greenfalcon's Profile: http://www.excelforum.com/member.php...o&userid=13622
View this thread: http://www.excelforum.com/showthread...hreadid=391126

--

Dave Peterson