By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 838 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

Sharing ms access database offline

P: 8
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
Aug 11 '17 #1
Share this Question
Share on Google+
4 Replies

Expert Mod 15k+
P: 31,418
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.
Aug 11 '17 #2

P: 8
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
Aug 12 '17 #3

Expert Mod 15k+
P: 31,418
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.
Aug 12 '17 #4

P: 1

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.

Aug 12 '17 #5

Post your reply

Sign in to post your reply or Sign up for a free account.