Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    shell function (VB6)

    I want to launch an access mde file using a specific mdw file from a VB application. Using the Shell function I have had a problem on a one or two PCs launching Access which then gives an error message "system error or not enough free memory to run this application". Has anyone else had good or bad experiences using the shell function it seems to work Ok on most PCs.

    The construct I am using is

    dim varret
    dim strPath

    strpath ="C:Program FilesMicrosoft OfficeOfficeMSACCESS.EXE" "Data FilesAppFolderAppFile.mde" /wrkgrp "Data FilesAppFolderSmSt.mdw" /user SysAdmin/Pwd wiggle"
    varRet = Shell(strpath, vbMaximizedFocus)

    Maybe this is not the right function to use in these circumstances. If I paste the file path in to a shortcut it works OK on all PCs

    My colleague is using this simple vb app to run an access 97 project he is distributing as run time application. It worked OK on his PC and lap top for a while. He has now used Wise Install to build a distribution package. It worked ok on his machines for the first two or three builds of the set up script but now it gives this error message. It is giving the message on about 50% of the installations on W98 and NT4

    Can anyone help me with this as our clients don't reckon much to it!

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: shell function (VB6)

    Are you distributing the Access runtime or just using the Jet engine as a datastore? I had problems with the Access 97 runtime on some machines where Office 2000 was installed, regardless of operating system. It seemed to be machine specific because some of them worked just fine, even machines that had never had Office 97 installed. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    However, if this is an Access 97 runtime, then why are you launching it from VB at all?
    Charlotte

  3. #3
    New Lounger
    Join Date
    Jun 2002
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: shell function (VB6)

    The reason I am using a simple vb application is to launch the runtime Access application secured with a MDW file. I can launch the programme with a password and restrict users through a simple interface in the application. This way the clients do not need to get involved with Access security. It also stops just anyone opening the data file. Its quite a good system when it works but on some pcs its giving this error. It is an Access error because the application starts and the error dialog is an Access error. The strange thing is that i can paste the same string path and password into a shortcut and it works OK, this is not secure though as anyone can see the password.

    Thanks Mark

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •