Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook

Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

All of a sudden: "The process cannot access .

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    All of a sudden: "The process cannot access .

    My application has been working fine for some time now, and all of a sudden I am getting this error message: "The process cannot access the file because it is being used by another process"

    This occurs when I have a browse in a dialog box, and then press a button to access another dialog form containg a browse based on the same table as the calling form. This was not happening before. Can someone please tell me what is this about, and how to fix it?

    Thanks in advance ...

    Gary Traub
    Gary S. Traub, Ph.D.


    #2
    RE: All of a sudden:

    Gary,
    I have encountered this message many times, unfortunately. Usually in the midst of a table lookup non-dialog form. I don't know of a cure. Sometimes closing the form works, usually you have to close Alpha. Sometimes you have to reboot the "server" (I'm talking peer to peer). In the latter case, there are usually open file handles on the server - possibly caused by a conflict between someone using Alpha on the server and someone else using Alpha at a remote station. Sorry I can't shed any more light on this.
    Peter
    AlphaBase Solutions, LLC

    [email protected]
    https://www.alphabasesolutions.com


    Comment


      #3
      RE: All of a sudden:

      My best guess is that you are leaving the file open, from some previous script.

      One way to test is to restart the computer (real clean fresh start), open the application, open dialog1, and then dialog2, and then back out back to your "master menu" - when supposedly all files are closed, except the one the menu is based on. Then exit to the control panel, and do a database compact. If any files are left open, you will get an error message. If so, retrace your steps - are you closing the dialogs twice, once when you close the dialog from within the dialog, and then again where you opened it from?

      f1=form.view("form1","dialog")
      in form1
      f2=form.view("form2","dialog")
      f2.close()
      f1.close()

      when you open a dialog within a dialog, some strange things happen - I've recently done a lot of work in this area where I have as many as 3 dialogs open. If you have any problems email me and I'll help if I can.

      differences:
      1. you have to disable forms if you open a 2nd dialog - whereas with only 1 dialog you can't go outside the dialog box as long as its open; with two or more that is no longer true.
      2. global variables tend to get reset (emptied) - there are workarounds, though. I really like dialogs, and have found the extra learnig cure worth the effort
      Cole Custom Programming - Terrell, Texas
      972 524 8714
      [email protected]

      ____________________
      "A young man who is not liberal has no heart, but an old man who is not conservative has no mind." GB Shaw

      Comment


        #4
        RE: All of a sudden:

        These are good thoughts. But the thing is this was all working fine. I just don't get it.I use dialogs extensively. In fact the entire application is done with dialog forms. I always use a parentform.disable() before callimng another dialog form, and then enable it again, and I also always close the dialog. I just don't get it. Oh well, ....

        Gary
        Gary S. Traub, Ph.D.

        Comment


          #5
          RE: All of a sudden:

          Gary, did you try my suggestion - about the fresh start, open, close, etc.

          If it was working before, I bet some change in a script somewhere is leaving something open. Also, if there are 2 or 3 instances of the file open, I think you have to be very careful to reference them as aliases and not directly.
          Cole Custom Programming - Terrell, Texas
          972 524 8714
          [email protected]

          ____________________
          "A young man who is not liberal has no heart, but an old man who is not conservative has no mind." GB Shaw

          Comment


            #6
            RE: All of a sudden:

            Gary:

            If the problem is persistent (after a shutdown and reboot) I'd look at the structural fundamentals of the tables and sets involved to make sure no corruption has crept in.

            Finian
            Finian

            Comment


              #7
              RE: All of a sudden:

              Gary,

              Gremlins come at strange times from strange places, even when things have worked for quite awhile. I have an app at work that has worked fine, day in and day out. Then, all of a sudden, something hangs up. Usually it's because I was making a change here or there and it's something I did. Even had a button hang up for no apparrent reason. Somehow, things can become corrupt. Perhaps it's the apps "indigestion"?

              Perhaps, after following Martin's suggestion, if it still hangs up, try a database compact. That's bailed me out a few times. Hadn't a clue why or how the gremlin (figure of speech) got in the app but the database compact routed it out.

              Hope this is of some help,

              kenn
              TYVM :) kenn

              Knowing what you can achieve will not become reality until you imagine and explore.

              Comment


                #8
                RE: All of a sudden:

                Thanks for all the replies ...

                Yes, I have rebooted, in fact many times. I have also tried Database compact many times. But, maybe indeed some tables are corrupt. I don't think that is likely because this error is not occurring with just one table. As far as I can tell, it is happening whenever I call a dialog from another dialog, where the browses on each are based on the same table. Again, this was not happening before. Now, if I am to pursue the corrupt table(s) idea, and I have already run Database compact many times, where would I begin? Any ideas?

                Again, thanks for all the input - this has really stumped me...

                Gary Traub
                Gary S. Traub, Ph.D.

                Comment


                  #9
                  RE: All of a sudden:

                  Gary:

                  Having just had my first file corruption occurrence in about 2 years, I guess I'm focused on that. As I recall the sequence of events from yesterday, the first error message was the the "unable to ... process is in use .." soon followed by "Error 20". There are likely a number of causes for these errors, but in my case it was the data dictionary or dictionaries that were corrupted (a ddx file seems to have gotten wiped out), following a period of pretty intense coding. The tables themselves (dbf'd) seem to be fine.

                  You could try a compact, but I would go through the tables and set or sets involved around where you are getting the error and examine each element: restructure and redefine tables and indexes; open forms and layouts in design mode and, if there are scripts attached to or involved in those processes, make sure you can open/edit the scripts.

                  Finian
                  Finian

                  Comment


                    #10
                    RE: All of a sudden:

                    Thanks Finian, I will definitely try that.

                    Gary
                    Gary S. Traub, Ph.D.

                    Comment


                      #11
                      RE: All of a sudden:

                      Guys:

                      I'm still struggling with all of this and what I'm about to say might seem trite.

                      During testing of a script using a dialog method I frequently do a database compact for this reason...

                      When a dialog form has done its stuff, it becomes invisible but remains open. To see if I've properly closed it in the script, I do a database compact. If it is 'invisible' and still open, Alpha interupts the 'compact' with a message '[tablename] is active - do you want to drop it from the database?' When I see that, I know that my script did not explicitly close the form, and still needs work.

                      Looks like A5V5 is going to bail us out of a lot of these problems.

                      Ken

                      Comment

                      Working...
                      X