Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update Excel Database via Access Main Database with a script Finnbar New Users to Excel 2 November 3rd 08 07:24 PM
XLS files opening as Read-Only Repaired Compatibility mode CindyInTexas Excel Discussion (Misc queries) 0 September 4th 08 07:36 PM
database query not showing foxpro database How I import data mangat New Users to Excel 1 June 24th 07 03:31 PM
How to make reference to database and if true copy from database? V!p3r Excel Discussion (Misc queries) 4 February 5th 07 02:19 PM
Excel renames sheet (repaired) when trying to change data from a . Debbie Excel Worksheet Functions 0 April 20th 05 08:15 PM


All times are GMT +1. The time now is 01:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"