Randomblink
The Irreverent Reverend
- Local time
- Today, 14:48
- Joined
- Jul 23, 2001
- Messages
- 279
Can someone do me a favor?
I want a line of code that will do the following:
1) Close the open database (it is a front end for arguments sake).
2) Goto a specified location on the server (using a mapped network drive and if you can, what is the coding to go without the mapped network drive) and grab the path and filename of database XYZ
3) Copy the XYZ completely over the database that was closed in line 1) and name XYZ to the name of the closed database
In laymans terms. I want to be in a database. On a form in the database, click on a specific button. Once clicked, the database I just clicked the button on is replaced with a new database from a certain spot on the server.
See I am going to get a spot on the server that is READ-ONLY to everyone. I am going to put updated front-end databases there. When I update a database I want to send out an email and have everyone click on the update button...and it will update.
I am being extremely lazy it seems? No. I don't have time to search. If someone can help, GREAT! If not, I am going to have to send this database out without the update option...ugh! Which I will have to do...time constraints!
Thanks if you can help. I hope I don't piss anyone off. For the record I have searched and come up with very little that helped. Most of it is version checking and autoupdating and stuff...I just need the lines so I can implement them in my own unique way! Thanks...
I want a line of code that will do the following:
1) Close the open database (it is a front end for arguments sake).
2) Goto a specified location on the server (using a mapped network drive and if you can, what is the coding to go without the mapped network drive) and grab the path and filename of database XYZ
3) Copy the XYZ completely over the database that was closed in line 1) and name XYZ to the name of the closed database
In laymans terms. I want to be in a database. On a form in the database, click on a specific button. Once clicked, the database I just clicked the button on is replaced with a new database from a certain spot on the server.
See I am going to get a spot on the server that is READ-ONLY to everyone. I am going to put updated front-end databases there. When I update a database I want to send out an email and have everyone click on the update button...and it will update.
I am being extremely lazy it seems? No. I don't have time to search. If someone can help, GREAT! If not, I am going to have to send this database out without the update option...ugh! Which I will have to do...time constraints!
Thanks if you can help. I hope I don't piss anyone off. For the record I have searched and come up with very little that helped. Most of it is version checking and autoupdating and stuff...I just need the lines so I can implement them in my own unique way! Thanks...
