Sharing ms access database offline

[aym2u2]

Good day, pls is't possible for me to share my ms access database between two or more computers offline? if yes please how are my going to go about it. I seriously need your help. Thanks

[NeoPa]

I'm not sure I understand your requirement clearly enough for a good answer.

If offline means away from the internet then yes. Files can be shared across any network. If not networked at all then they can be shared, but not simultaneously.

It would help if we had a much clearer explanation of exactly what you want help with.

[aym2u2]

@NeoPa
Thanks for ur responds.
What i want is that i want to two or more people to share one ms database file. What are my going to do. thanks

[NeoPa]

It's impossible to answer that question unless you explain how these people are related (as far as IT goes at least.) Will they be using the same physical computer but at different times? Maybe separate computers connected by a network; Separate computers with no network connection? That's a critical part of the question, without which no answer will be sensible.

[paulwmt]

Hi,

If I understand what you are describing, you want to have your MS Access code to be able to access a data file on a network or another PC?

If so, you need to have the data file ("thedata.accdb") to reside only on one location (it can be one one PC or on a network server) and the code ("thecode.accdb") to be on every workstation/PC that will use that data.

To do that, you must have your data and code separated into two files (front end = code and back end = data) and then link the tables that are in the back end to the front end. If you are not using an executable/secure front end ("accde") then all you need to do is select "External Data" from the tab at the top of Access after opening your code file, then "Access" then the radio button "Link to the Data Source..." after you point/browse to where the data file is located. That is it.

If you cannot see your network then that is another problem.

-paulw