Linking using fRefreshLinks

[tobesurveyor via AccessMonster.com]

Hello All,

I am using Dev Ashish's fRefreshLinks in a new version of an application I am
writing. In my old version everything worked great, a Splash screen would
open on application start and run the fRefreshLinks function and check all my
linked tables.

I have since modified the database so that there are several tables that are
linked to the backend on a server and some tables that stay within the front
end, which are tables that will not be updated or changed once the
application is distributed. Instead of running the split wizard, I linked
manually to the tables in my backend using the File>Import External Data.

When ever I try calling this function on the On_Open or On_Load event, I get
a nice error message stating that it had a problem communicating with the OLE
Server or ActiveX Control. Is this caused because I have several tables that
are not linked? Is there a work around to this?

Any help would be greatly appreciated.
Thanks,
Chris

 

[david epsom dot com dot au]

No, that message indicates something else is wrong.

Perhaps the database is corrupted, or perhaps you have
something like a calender control, or perhaps you have
an invalid reference.

Can you make an MDE from the file? If you can't make
an MDE, there is certainly something wrong, but not
with the tables.

(david)