473,382 Members | 1,583 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

Sharing Access database In a Office network

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
3 1640
n8kindt
221 100+
what kind of changes? design changes? or just changing data in a table? be a little more specific please.
Mar 13 '08 #2
Hii,

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

Pramod
Mar 13 '08 #3
n8kindt
221 100+
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

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

Similar topics

0
by: Mark Reed | last post by:
Compaq P4, 512mb Ram, XPPro, Office 2002 Pro. 1. Before MS SQL 2000 Client install MS Access 2002 properly created a new database in MYDOCUMENTS which is redirected to h:\users\%username% via...
10
by: MHenry | last post by:
Hi, We were going merrily along for 6 years using this database to record all client checks that came into our office, including information about what the checks were for. Suddenly, network...
5
by: elieli_132 | last post by:
Hi, My problem is the following: Made changes to code in form and closed the form. Now unable to open / design the form. - Tried copying and pasting - the new one does not open /display....
11
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on...
56
by: Raphi | last post by:
Hi, I've been using an Access application I wrote for an office with the front-end stored on all computers and the back-end on one of them serving as an Access file server. Now we're moving...
17
by: Mell via AccessMonster.com | last post by:
Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting...
21
by: nihad.nasim | last post by:
Hi there, I have a database in Access that I need on the web. The web page should connect to the database and write records for certain tables and view records for others. I want to know a...
1
by: Technicalprob | last post by:
Problem: I designed a small access database and created tables and relationship between them. The database works fine and have no problem. I have stored the database in My Documents on my hard disk...
3
by: Earl Anderson | last post by:
One of the users in our departmental db has Read/Write permissions to a particular form. He was able to access and edit the form at will until 2 weeks ago. His current problem was that he was not...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.