Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rating: Thread Rating: 6 votes, 5.00 average. Display Modes
Old 06-04-2013, 06:01 AM   #1
AccessUser4
Newly Registered User
 
Join Date: Jun 2013
Posts: 7
Thanks: 1
Thanked 0 Times in 0 Posts
AccessUser4 is on a distinguished road
Access FE user auto copy most recent file

Hello all-

I am a new member - long time lurker. I have learned much from reading this forum over the past year. I am mostly self taught and until recently haven't used much VBA (started using it after an on-line tutorial I took but still definitely new to code writing) to run my database. I do have a question that I haven't quite found a previous complete solution on or at least complete in terms of my understanding exactly what I need to do.

I have read through a few threads and tried to reference them here but I am under the post count to allow for posting a link.

Background:
I have an access 2007 database that is split front end and back end. There are about 15 users and the backend is stored on the network. Currently I am e-mailing out the FE when chagnes are made so they have the latest copy.

With everything I have read I think a bat file would work the best at allowing me to make changes on demand without having to continually email out new versions of the FE. Sometimes the changes are behind the scenes unnoticable to the user while others are obvious.

Questions:
Exactly HOW does a bat file work? When the user clicks on the access file stored on their laptop? Where is the bat file stored? I am unfamiliar with where to write the bat file code as well - notepad perhaps?

I am not sure how to create a bat file and what the code should be?

For version tracking I need to put a version table in the BE and in the front end correct?

Anyone? If there is a better way please also share that as well. I have made a few significant changes but I'm holding out e-mailing it if I can get this version copying firgured out and in place first.

Thank you in advance for any help you can offer.

Lisa

AccessUser4 is offline   Reply With Quote
Old 06-04-2013, 06:31 AM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,289
Thanks: 13
Thanked 4,111 Times in 4,043 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Access FE user auto copy most recent file

My buddy Bill does that type of thing:

http://www.thatlldoit.com/Pages/howtosarticles.aspx

I use a version table in the front end. Users actually run a little exe I write that copies down the front end if newer, then starts it.
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Old 06-04-2013, 06:41 AM   #3
AccessUser4
Newly Registered User
 
Join Date: Jun 2013
Posts: 7
Thanks: 1
Thanked 0 Times in 0 Posts
AccessUser4 is on a distinguished road
Re: Access FE user auto copy most recent file

Wow - that is a lot to take in! I am still reading and re-reading but wanted to thank you for the quick reply. After I've digested it and tried it (a lot of unfamiliar there) I'll come back and let you know how I did or if I'm stuck.

Thanks again!

Lisa

AccessUser4 is offline   Reply With Quote
Old 06-04-2013, 06:47 AM   #4
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,289
Thanks: 13
Thanked 4,111 Times in 4,043 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Access FE user auto copy most recent file

No problem Lisa. Bob also has a utility, but his site seems to be down right now. The last post here has a link:

http://www.access-programmers.co.uk/...=111132&page=2
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Old 06-04-2013, 06:56 AM   #5
AccessUser4
Newly Registered User
 
Join Date: Jun 2013
Posts: 7
Thanks: 1
Thanked 0 Times in 0 Posts
AccessUser4 is on a distinguished road
Re: Access FE user auto copy most recent file

Thanks - I will check again later. Actually the link I was trying to include in my first post was from 'boblarson' and it had a click my signature to see the file downloads but I was new and hadn't hit the post requirement to view it.

AccessUser4 is offline   Reply With Quote
Reply

Tags
access , bat file , copy , file version

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to copy value from Access table to Excel file without losing number? sunzhoujian General 7 07-28-2007 09:25 AM
I need to copy a file...can I do this in Access VBA? odin1701 Modules & VBA 1 03-05-2007 03:42 PM
Can't read recent file names on File menu Dchall_San_Anto General 2 10-25-2006 10:59 PM
Auto-DB Copy - Access 2002 RonZ General 0 10-05-2006 08:41 AM
[SOLVED] Copy File in Access JesseH Modules & VBA 1 08-25-2005 12:53 PM




All times are GMT -8. The time now is 12:20 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World