Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Oct 2003
    Location
    Nashville, Tennessee, USA
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy / Past FE (Access 97)

    Currently, I have shortcuts pasted into an e-mail instructing the user to:

    1) Open Shortcut A (Which goes to N:TempCBu)
    2) Copy the file(s) (Which are: N:TempCBueber.mde & N:TempCBuUpdate.mdb)
    3) Open Shortcut B (Which goes to C
    4) Paste the files
    5) Cut the supplied shortcut C (Which goes to C:Update.mdb)
    6) Paste C onto desktop

    Could the above be shrunk to a "vbs"?? file then the file sent out? That way all the user would have to do is to double click the file and the copy/Paste....Cut/Paste would be done automatically. If so, where could I learn some about this "VBS" file type
    If not, could does anyone have any ideas on how to create such a batch file to simply copy files from N:tempcbueber.mde , paste them to C:eber.mde Also, if possible how to cut a shortcut from N: and paste directly to the desktop?

  2. #2
    2 Star Lounger
    Join Date
    Jun 2002
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy / Past FE (Access 97)

    Not sure about vbs but you could do the same with a .bat file.

  3. #3
    2 Star Lounger
    Join Date
    Jun 2002
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy / Past FE (Access 97)

    If I remember correctly, you can create the bat file in Note Pad. Change the file extention from .txt to .bat

    In the .bat file you would use dos commands.

    copy n:myfoldermyfile.mdb c:mynewfoldermyfile.mdb

  4. #4
    Star Lounger
    Join Date
    Oct 2003
    Location
    Nashville, Tennessee, USA
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy / Past FE (Access 97)

    Worked great!

    There is one other item however concerning a possible shortcut and the visibility of the batch file. Here our desk top is located at
    C:winntprofiles**USERID**Desktop

    Instead of including a shortcut in the e-mail for the user to cut then paste onto their desktop, is there away to include the shortcut in the batchfile so that it would copy to the user's desktop?
    If not, is there away to have the FE to automatically create a shortcut, if one does not exist, when it is opened for the first time?

    As for the batch file.... Since the FE takes some time to copy (depending on the machine), is there something that can be added to the batch file to run "invisible" then once the FE download is complete automatically run the FE?

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy / Past FE (Access 97)

    We have several Access databases being used in 70 schools in our school system. We are on a Novell network and have our users start the applications from their Novell-delivered applications that appears on their Windows task bar. The application object was set up to create a folder if none exists and then copy the latest version of the front end from their school server to the users computer into the folder we specified. The application object then starts Access and opens the database. By using this procedure we can easily make changes to the front end, run a batch file to copy the new front end to each server and the very next time the user clicks on the icon in their Novell-delivered applications they get the latest version.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  6. #6
    Star Lounger
    Join Date
    Oct 2003
    Location
    Nashville, Tennessee, USA
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy / Past FE (Access 97)

    The Update needs of the front end are taken care of through a database that checks the current vs on their c: and compares it to the vs on the network. If they are different the most current is copied over.
    The use of this batch file is to get the mde FE and the update mdb onto the c: of the computers who will be using the DB. Therefore, the batch file simply copies the vs of the FE and the update mdb file onto the c: when ran. Then every other time the FE is opened the update does the checking, which does not require the .BAT.

    The problem I am facing is that this DB is to be used by many "Access Afraid" users. Therefore, I would like to keep them from having to open Access then search for the file. A shortcut would be the best.

    However, on our network each users desktop is saved as a "profile" onto the server. Which allows us to log onto any computer and consistantly see the same desktop. By doing this, the profile must reference the userId...as in...
    C:winntprofile****USERID****Desktop ..... I.E. My desktop is under.... C:winntprofilesbrownp2desktop while a coworkers is under C:winntprofilesnmm445desktop

    What I need to do is have the batch file copy the shortcut to the DB to the users individual desktop location. For instance, if this was being done in Access, I know somthing like this would work:

    Dim strUser as String

    C:winntprofilesstrUserdesktop

    strUser = environ("username")

    What I need to know is if something similar can be done in the batch file.

  7. #7
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Copy / Past FE (Access 97)

    You might want to consider a more sophisticated solution available from FMS - here the link to it. Total Access Startup There are also a couple of others available that might be less expensive.
    Wendell

Posting Permissions

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