Copy / Past FE (Access 97)

Topic

New Reply

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?

Reply | Quote

Replies

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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?

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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?

Reply | Quote

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

Reply | Quote