Way to share Access database with multiple computers? (1 Viewer)

M

MicD95

New member

Local time

Today, 07:44

Joined

Jun 14, 2018

Messages

2

• Jun 14, 2018

• #1

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

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 22:44

Joined

May 7, 2009

Messages

19,233

• Jun 14, 2018

• #2

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.

 

M

MicD95

New member

Local time

Today, 07:44

Joined

Jun 14, 2018

Messages

2

• Jun 14, 2018

• #3

arnelgp said:

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.

Click to expand...

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

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 22:44

Joined

May 7, 2009

Messages

19,233

• Jun 14, 2018

• #4

On the Ribbon, link manager.

 

isladogs

MVP / VIP

Local time

Today, 15:44

Joined

Jan 14, 2017

Messages

18,209

• Jun 14, 2018

• #5

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.

 

P

Pat Hartman

Super Moderator

Staff member

Local time

Today, 10:44

Joined

Feb 19, 2002

Messages

43,224

• Jun 15, 2018

• #6

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.