Error 1541 - connection busy

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have Form 1 that calls Form 2. When that call is made, I get Error 1541 -
connection busy. I can't tell exactly where it's happening, because the
error occurs in "Line 0". If I choose "Ignore", Form 2 opens and runs
properly.

The forms have nothing in the de; all data is opened in form.load. Both have
private data sessions. The data is all in MSSQL, which I access via remote
views based on a connection to an ODBC source.

Naturally, the error occurs only at the client site, and not on my own
network.

Might this have something to do with the SHARE clause in the view creation
statement? Some views were created in the view designer, which as far as I
can tell, has no option to set this clause, and others were created in code,
some with SHARE and some without. The description of the SHARE clause of
CREATE SQL VIEW in the FoxPro help file is not at all clear to me.

If this is what's causing my problems? Is it possible to set the SHARE
attribute in the view designer? Why does it work on my network but not on
the client's?

Any other suggestions?



.

Relevant Pages

  • Re: StDev Query
    ... The WHERE clause is always evaluated BEFORE the aggregate/group, ... You have to use, in the designer, in the line Total, use ... I can do this in Excel. ...
    (microsoft.public.access.queries)
  • Re: StDev Query
    ... The WHERE clause is always evaluated BEFORE the aggregate/group, ... the designer is a little bit tricky since with a Total query, ... You have to use, in the designer, in the line Total, use ...
    (microsoft.public.access.queries)
  • Re: Custom Menu in Multiuser Application
    ... In the menu designer, ... expression in an item's SKIP FOR clause and that is dynamically evaluated at ... > I am looking for code sample or an example application which will ... > multi-user application. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Application Speed Dilemma
    ... I do not see anything wrong except you do not need ORDER BY ID ASC clause ... If yes, then it will work faster, because database is ... Check network. ...
    (microsoft.public.dotnet.framework.windowsforms.databinding)
  • Re: Application Speed Dilemma
    ... I do not see anything wrong except you do not need ORDER BY ID ASC clause ... If yes, then it will work faster, because database is ... Check network. ...
    (microsoft.public.dotnet.framework.adonet)