UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Updating A Clients Database Remotely, Access 2016    
 
   
renovator99
post Jul 3 2017, 12:39 PM
Post#1



Posts: 17
Joined: 30-December 16



Hi,
How can I send an updated versions to a friend of the frontend and VBA code without wiping the datafiles?
Do I use splitting?
What happens if I delete or add fields or change the data type

Background
---------------------------
A friend has asked me to do a database and I will need to keep on sending him update
He lives about an hour away and he is very untech so remoting in would be an issue


thanks
Go to the top of the page
 
theDBguy
post Jul 3 2017, 12:45 PM
Post#2


Access Wiki and Forums Moderator
Posts: 71,196
Joined: 19-June 07
From: SunnySandyEggo


Hi,

Yes, the first step is to split the database, which would make it so much easier to update the front end. As for updating the back end, you can also use utilities available online to safely update the BE without messing with the data.

Cheers!

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
ScottGem
post Jul 5 2017, 06:38 AM
Post#3


UtterAccess VIP / UA Clown
Posts: 32,181
Joined: 21-January 04
From: LI, NY


Yes, the database NEEDS to be split. This way when the front end is updated, you only send the front end. The data remains intact.

If you do need to update the back end structure, you have several options.

1) Use a Remote Access tool like TeamViewer to remote into his PC and make the changes
2) Add ALTER TABLE queries to the Front end to update the back end tables. Set the Front end to check for a flag somewhere that the the queries have been run or run them if not.
3) Ask him to upload his back end to cloud storage and hold off data entry until you return it.

--------------------
Scott <>
Scottgem's Blog
Microsoft Access MVP since 2007
Author: Microsoft Office Access 2007 VBA
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    11th December 2017 - 06:15 AM