Link to home
Create AccountLog in
Avatar of Juan Velasquez
Juan VelasquezFlag for United States of America

asked on

How can I surpress invalid file path messages on split access database

Hello,

I have a database where code is run on startup to check if all the tables are linked.  If there are any broken links, code is executed to refresh those links.  That seems to work fine.  How do I surpress the system generated error messages that appear when the database initially starts up on the ocassions, when the links are broken.
Avatar of als315
als315
Flag of Russian Federation image

Look at sample here:
http://www.eraserve.com/tutorials/MS_ACCESS_VBA_Check_If_Table_Exists.asp
You can run this test from autoexec macro before any form is opened
May be better to change SQL to:
"Select TOP 1 * from " & TableName & ";"
You're welcome to use our free J Street Access Relinker.  It's at www.JStreetTech.com/downloads.

Cheers,
Armen
Avatar of Juan Velasquez

ASKER

Hello,
I already have something that works.  My question concerns suppressing the default error messages that occur when a table link is broken.  I'm going to try the setting  the SetWarnings action to No in the Autoexec Macro
ASKER CERTIFIED SOLUTION
Avatar of Juan Velasquez
Juan Velasquez
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
The customer is fine with the error messages