The record source ... specified on this form does not exist

[Alex Ivanov]

Hi,
Since we upgraded Novell Client to version 4.90.2.20040617 on our
remaining NT4 workstations, we are having problems with some Access
databases (Access 2002 Runtime front-end). If a startup form is
displayed by setting the startup property at design time or from
OpenForm action in Autoexec macro, the code behind a form chokes at
the lines like
set rs=currentdb.openrecodset(source) if source is a query based on a
linked table from a database residing on a novell server and linked
using UNC path. The error we receive states that "The record source
.... specified on this form does not exist" and then the application
shuts down.

However, if I link the table used in the startup procedure using
mapped drive letter, the error does not occur and the rest of the
application works fine, even if other tables are still linked using
UNC notation. What even more weird, if I change the OpenForm action in
Autoexec to RunCode and then DoCmd.OpenForm from there, it runs fine.

Another effect after that upgrade (which may be related somehow to
what I described above) is that we can't any longer start Access 97
apps (full version) by double-clicking an mdb file icon. The reason
for this is that the registry default value at
HKEY_CLASSES_ROOT\Access.Application.8\shell\open\command does not
have quotes around C:\Program Files\Microsoft
Office\Office\MSACCESS.EXE. If I put the quotes manually, the problem
is getting fixed until next time I run an Access 2002 app. Then the
quotes disappear again.

Does anybody know a solution to these problems?

 

[Alex Ivanov]

Update ...

Autoexec to RunCode and then DoCmd.OpenForm from there, it runs

fine.
it works only if I call some DAO methods like
currentdb.openrecordset(anyrecordset) before docmd.openform.