John Mishefske <mi****@execpc.comwrote:
>- most split apps have only one BE file but it is certainly possible to
link to tables in more than one BE file. Uncommon but just something to
be aware of.
Indeed. I have have code in a few databases that, on startup, double checks that all
tables are linked to the same backend. Just belts and suspenders programming.
>- you'll want to ensure that the BE actually exists. No error is raise
when opening a FE with linked tables to a BE that doesn't exist - you'll
want to code for that possibility.
Another good point. This is as simple is opening a recordset based on a table
preferably with only a few records in it. If the open succeeds that all is well.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -
http://msmvps.com/blogs/access/