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    
post Jul 3 2017, 12:39 PM

Posts: 17
Joined: 30-December 16

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

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

Go to the top of the page
post Jul 3 2017, 12:45 PM

Access Wiki and Forums Moderator
Posts: 73,749
Joined: 19-June 07
From: SunnySandyEggo


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.

Go to the top of the page
post Jul 5 2017, 06:38 AM

UtterAccess VIP / UA Clown
Posts: 32,213
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.
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    18th November 2018 - 08:35 PM