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

Sharing Access database In a Office network

P: 13
Dear All,

I want to share my access database in my office for 4 others also to use it & make changes in it, how to do it? plss help.

Pramod
Mar 13 '08 #1
Share this Question
Share on Google+
3 Replies


n8kindt
100+
P: 221
what kind of changes? design changes? or just changing data in a table? be a little more specific please.
Mar 13 '08 #2

P: 13
Hii,

No need for design changes Just to enter, Update Recors in a Table.

Pramod
Mar 13 '08 #3

n8kindt
100+
P: 221
Hii,

No need for design changes Just to enter, Update Recors in a Table.

Pramod
assuming u have a network connecting all the computers in the first place, you need to share the directory folder that contains the access file you want them to use. now, also assuming all the computers have access installed on them, find the shared folder on the network (it will usually appear when you click on your network places icon). now, if you don't want to have to purchase and install access for all 4 computers, you can download a program called microsoft access runtime off of microsoft's website and everytime you open an access file it will not allow you to make design changes--but will still allow you to change data contained in the database. now, you're still not done yet if you choose to take this path b/c access runtime will show a blank screen when you open the file unless you set up a macro or code to open a specific form, table, or report whenever access is opened. alternatively, there is also a property you can set in the database options (in the actual access program-not runtime) to open a form, table, or report that you specify. i haven't tried this in runtime yet, but i also believe you can set up a switchboard (which is similar to a toolbar) that is visible at all times and you can put links to forms, tables, and reports that need to be accessed.hope this answers most of your questions.
Mar 14 '08 #4

Post your reply

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