Re: (Why) Cannot Find msysdb and other 'Missing' References?

From: Rick Brandt (rickbrandt2_at_hotmail.com)
Date: 01/24/05 

Date: Mon, 24 Jan 2005 12:51:09 -0600

Michael Miller wrote:
> I have had some random users, after using the program fine, for
> months, come up with either of the above Subject's errors, msysdb and
> objects showing as Missing in the References list.
>
> I have been able to resolve both those problems, but I don't know what
> causes them (msysdb is corruption, I know, but why?).
>
> Does anyone know the cause of these problems.
>
> Half of our office is located in MN and I am in CT, and the users
> have their own front ends, and the back end mdb is located on our
> shared server. The server is notoriously slow and MN takes 15 mins
> to open forms. There is also a chance that their connection to the
> server, over bridges and routers, burps, and maybe they temporarily
> (seconds) lose their connection, while the Access app is open. I
> don't know.
>
> But, wouldn't those errors fix themselves if they get out of Access
> and go back in, and especially if they reboot also???
>
> Thanks.

Access CANNOT be reliably run as a file share over a WAN connection. The
only practical way to operate over a WAN is with remote control software
like Terminal Services or PCAnywhere.

Keep in mind that the best WAN connection you will ever find is still MUCH
slower and suffers from way more dropped packets than the worst ethernet LAN
you would ever encounter and Access is picky enough running on a LAN. 

-- 
I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

Relevant Pages

  • Re: (Why) Cannot Find msysdb and other Missing References?
    ... >> I have had some random users, after using the program fine, for ... wouldn't those errors fix themselves if they get out of Access ... > Keep in mind that the best WAN connection you will ever find is still MUCH ... > slower and suffers from way more dropped packets than the worst ethernet LAN ...
    (microsoft.public.access.setupconfig)
  • Re: Missing email
    ... > I have an SBS2003 where users are reporting non receipt of email. ... > Random users are reporting this with random senders. ... The Server uses SMTP transport. ... There is nothing ion the event log to suggest an issue ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to SQL.
    ... Terminal server is probably the best option. ... >> & the WAN connection is good but it is still running slowly. ... > SQL Server doesn't magically make that problem go away. ...
    (microsoft.public.access.tablesdbdesign)
  • (Why) Cannot Find msysdb and other Missing References?
    ... I have had some random users, after using the program fine, for months, come ... causes them (msysdb is corruption, I know, but why?). ... and the back end mdb is located on our shared server. ... Access app is open. ...
    (microsoft.public.access.setupconfig)
  • Re: Microsoft FTP Server problem on W2K?
    ... >>Since the mainframe pushes files to our customers over a WAN connection, ... One server which doesn't support restartable upload is, IIRC, the FTP server ... Sounds like Unisys:) ...
    (microsoft.public.inetserver.iis.security)
Loading