Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-13-2018, 11:18 PM   #1
Rakesh935
Newly Registered User
 
Join Date: Oct 2012
Posts: 53
Thanks: 4
Thanked 0 Times in 0 Posts
Rakesh935 is on a distinguished road
Sharing MS Access database (2016 Version)

Hi Guys,

I have developed an MS Access database (2016 Version) consisting of tables, sqls, vba and macros for my team. The next challenge is, my team is consisting of about 40 associates and they need to update this database on a daily basis.

So far, my thought process is to split the database, keep the primary file in the shared drive and share the front end through email so that all of my associates have their own front end copy.

Please advise me if my approach is right and if not, then what could be an alternative best method to make this file shared for multiple users.

Thanks in advance for all your suggestions.

Regards,
Rakesh

Rakesh935 is offline   Reply With Quote
Old 08-13-2018, 11:30 PM   #2
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,071
Thanks: 19
Thanked 850 Times in 835 Posts
GinaWhipp will become famous soon enough GinaWhipp will become famous soon enough
Re: Sharing MS Access database (2016 Version)

Yep, backend on Server and frontend to individual Uses is the only way. For some help have a look at...


http://www.kallal.ca/Articles/split/index.htm

http://allenbrowne.com/ser-01.html

http://www.utteraccess.com/wiki/index.php/Sharing


You may also want to take a look at MVP Tom Wickerath's article…

http://www.accessmvp.com:80/Twickera.../multiuser.htm


To handle the update of multiple front ends see…

http://www.autofeupdater.com/
https://regina-whipp.com/blog/?p=184
http://www.btabdevelopment.com/ts/freetools
__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by GinaWhipp; 08-13-2018 at 11:31 PM. Reason: correction
GinaWhipp is offline   Reply With Quote
The Following User Says Thank You to GinaWhipp For This Useful Post:
Rakesh935 (08-14-2018)
Old 08-14-2018, 12:07 AM   #3
ridders
Part time moderator
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,207
Thanks: 83
Thanked 1,532 Times in 1,427 Posts
ridders is just really nice ridders is just really nice ridders is just really nice ridders is just really nice ridders is just really nice
Re: Sharing MS Access database (2016 Version)

I haven't checked Gina's links so apologies if this is repeating what those say.

To add to Gina's comments, make sure your associates do not try to run the front end from the email attachment. It won't work properly and could cause issues. It needs to be installed to their hard drive.

A better method for distribution would be to have a network folder where the latest copy of the FE is stored. Next get IT support to copy the file itself and a desktop shortcut to the hard drive of each user.

Do NOT give users write permission to that folder to ensure the FE isn't run from the network.

When the FE is opened, code is used to check if a newer version exists on the network. If so, that is downloaded and used to overwrite the old version. Otherwise the file opens normally.
Look up FE Updater in this forum and online. There are many free examples including the links given by Gina

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

New example databases:

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

-----------------------------------------------------------------------------------
nil illegitimi carborundum est
ridders is offline   Reply With Quote
Old 08-14-2018, 01:35 AM   #4
Rakesh935
Newly Registered User
 
Join Date: Oct 2012
Posts: 53
Thanks: 4
Thanked 0 Times in 0 Posts
Rakesh935 is on a distinguished road
Re: Sharing MS Access database (2016 Version)

Thanks Gina and Ridders for your help ....

@ ridders - Just 1 question out of curiosity if I do not give users, write permission to that folder located in shared drive then would my users be able to update or add a new record to database through the FE?

Thanks,
Rakesh
Rakesh935 is offline   Reply With Quote
Old 08-14-2018, 03:19 AM   #5
ridders
Part time moderator
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,207
Thanks: 83
Thanked 1,532 Times in 1,427 Posts
ridders is just really nice ridders is just really nice ridders is just really nice ridders is just really nice ridders is just really nice
Re: Sharing MS Access database (2016 Version)

Quote:
Originally Posted by Rakesh935 View Post
Thanks Gina and Ridders for your help ....

@ ridders - Just 1 question out of curiosity if I do not give users, write permission to that folder located in shared drive then would my users be able to update or add a new record to database through the FE?

Thanks,
Rakesh
I was talking about the folder containing the latest version of the FE.
The idea is to prevent anyone opening the FE from the shared drive.

Obviously the BE file needs to be editable (via the FE).
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

New example databases:

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

-----------------------------------------------------------------------------------
nil illegitimi carborundum est
ridders is offline   Reply With Quote
The Following User Says Thank You to ridders For This Useful Post:
Rakesh935 (08-14-2018)
Old 08-14-2018, 04:44 AM   #6
psyc0tic1
Access Moron
 
Join Date: Jul 2017
Posts: 264
Thanks: 134
Thanked 2 Times in 2 Posts
psyc0tic1 is on a distinguished road
Re: Sharing MS Access database (2016 Version)

If any of my experiences on this matter mean anything... the folder where the back-end is stored... the users will need READ and WRITE access to that folder or they will not be able to access it from their front-end
__________________
Richard
Access 2013, Windows 7 64 bit
psyc0tic1 is offline   Reply With Quote
Old 08-14-2018, 05:15 AM   #7
ridders
Part time moderator
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,207
Thanks: 83
Thanked 1,532 Times in 1,427 Posts
ridders is just really nice ridders is just really nice ridders is just really nice ridders is just really nice ridders is just really nice
Re: Sharing MS Access database (2016 Version)

Thanks for clarifying the point I was making. Much clearer now.


__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

New example databases:

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

-----------------------------------------------------------------------------------
nil illegitimi carborundum est
ridders is offline   Reply With Quote
Reply

Tags
access , forms control , share access with users , sql , vba access automation

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
New features in Access 2016 version 1710 ridders General 9 11-16-2017 09:34 AM
[SOLVED] Access 2016 Database to Java Clepto General 2 09-04-2016 11:05 AM
MS Access Database Sharing JDCD201 General 5 05-28-2014 05:34 AM
Sharing an Access Database Hey Lucy General 1 11-08-2012 08:18 PM
Sharing an Access Database lebelerc General 2 06-11-2005 08:45 PM




All times are GMT -8. The time now is 08:48 AM.


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

Sponsored Links

How to advertise

Media Kit


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