Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-14-2018, 02:00 AM   #1
MicD95
Newly Registered User
 
Join Date: Jun 2018
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
MicD95 is on a distinguished road
Way to share Access database with multiple computers?

Hello!

I have a database that I use for work, that was made around 15 years ago on Access 2003.

After a lot of messing about I finally have it running on my computer now on Access 2010. Is their any way I can share this database to be viewed by other staff?

I have read guides here and there about splitting the database into front end and back end, and have tried with no luck.

I'm sure there are details I have missed out, if anyone has any questions please let me know.

Thanks in advance,
Michael

MicD95 is offline   Reply With Quote
Old 06-14-2018, 02:11 AM   #2
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,136
Thanks: 54
Thanked 1,968 Times in 1,881 Posts
arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough
Re: Way to share Access database with multiple computers?

Split it first.
place the BE in shared folder.
Make sure ti give all Rights to this folder.
Use the FE and relink the table again.
Use Unc path when linking, eg:
\\yourComputer\SharedFolderName\

Distribute the FE.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 06-14-2018, 03:40 AM   #3
MicD95
Newly Registered User
 
Join Date: Jun 2018
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
MicD95 is on a distinguished road
Re: Way to share Access database with multiple computers?

Quote:
Originally Posted by arnelgp View Post
Split it first.
place the BE in shared folder.
Make sure ti give all Rights to this folder.
Use the FE and relink the table again.
Use Unc path when linking, eg:
\\yourComputer\SharedFolderName\

Distribute the FE.
Thanks for the quick response.
How do I relink the table?

MicD95 is offline   Reply With Quote
Old 06-14-2018, 03:44 AM   #4
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,136
Thanks: 54
Thanked 1,968 Times in 1,881 Posts
arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough
Re: Way to share Access database with multiple computers?

On the Ribbon, link manager.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 06-14-2018, 03:48 AM   #5
ridders
Newbee moderator
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 5,301
Thanks: 77
Thanked 1,294 Times in 1,209 Posts
ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough
Re: Way to share Access database with multiple computers?

The BE should be shared BUT do NOT allow users to share the same FE.
If you do so, corruption will occur.

You need to ensure each member of staff has their own copy of the FE database on their own computer.
__________________
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.


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

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.
ridders is offline   Reply With Quote
Old 06-14-2018, 09:02 PM   #6
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,123
Thanks: 13
Thanked 1,350 Times in 1,286 Posts
Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light
Re: Way to share Access database with multiple computers?

Once you have linked the master copy on hte server using UNC naming as arnelgp suggested (mapped drives work but they REQUIRE that all users have identical mapping whereas, UNC name is the common name for a server on your network), you can distribute copies of the FE to other users and they should all be connected to the same BE database and share data. If user1 updates a record, all the other users will see the change once the record has been saved.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to Share access 2007 database on team-site Manu1986 Queries 3 07-28-2017 09:56 AM
Question Share Access Database Marlena General 2 03-17-2014 05:45 AM
Question how to share ms-access database on internet fawad0301 General 2 09-18-2012 07:03 AM
Access 2007 Computers Lock Up on Split Database chaddiesel Tables 3 08-18-2009 07:06 AM
Share Problems with MS Access 2000 Database Darrkelf General 2 05-18-2007 08:46 PM




All times are GMT -8. The time now is 11:01 PM.


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