Not sure how you are handling your Error Messages in
in your Access program but the answer to your question
is yes.
However you'll have to put the problematic section(s)
in error handling code segments in order to do so.
Not having the time to look up the specific error as
well as not knowing from whence inside your Access
program the error is coming from I cannot be of much
more assistance than this. But seeing as you have a
rather large Access app and a VB app then I doubt
you'll be able to work it out. If you get stuck try
looking that specific error code up on the Microsoft
Website and or google it... I have generally been able
to answer most of my questions like this by doing just
that.
And good luck and remember perseverance does pay off.
--- Øystein Frostad <[EMAIL PROTECTED]> wrote:
> A made a big Access DB, and a small VB background
> program, sharing the same table.
>
> Sometimes, very rarely, I got error 3197 from
> Access, if the Access and VB programs are using the
> same table at the same time.
>
> I do not wish to change the VB program, so is there
> a way to prevent this error massage appear with
> Access code, and hold in a loop until the problem is
> over, and then continue?
>
> By the way...this is a great group.
>
> Stein.
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessVBACentral/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
