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

centralized database

P: n/a
i have made a database in ms access,now i want to centralized this data
base on my network,i want that actual database'll reside on the server
the clients can access that database n can make changes n changings'll
store on the server,is it possible that i can do it in ms access?

May 20 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
bsn

"Mehreen" <me************@yahoo.com> skrev i en meddelelse
news:11**********************@i40g2000cwc.googlegr oups.com...
i have made a database in ms access,now i want to centralized this data
base on my network,i want that actual database'll reside on the server
the clients can access that database n can make changes n changings'll
store on the server,is it possible that i can do it in ms access?

Yes...
You ll have to make a backend((all tables)server) and x
frontends((queries,forms)clients)...
Try the guide in "Functions-Databasefunctions-Split Database" - remember
backup before going on...
Bjarne
May 20 '06 #2

P: n/a

Mehreen wrote:
i have made a database in ms access,now i want to centralized this data
base on my network,i want that actual database'll reside on the server
the clients can access that database n can make changes n changings'll
store on the server,is it possible that i can do it in ms access?


Yes, that can be done with Access and thats the way to go. Clients can
link/import tables; database can be replicated and lots of other stuffs
can be done. Access is a neat little database for simple stuffs. And
well mentioned - backup the database file all the time. Now and then,
do compact/repair also.

Chirag Shukla.

May 21 '06 #3

P: n/a
"Mehreen" <me************@yahoo.com> wrote:
i have made a database in ms access,now i want
to centralized this data base on my network,i want
that actual database'll reside on the server the
clients can access that database n can make
changes n changings'll store on the server,is it
possible that i can do it in ms access?


What you describe: Access front-end (the User Interface: queries, forms,
reports, macros, and modules) and Jet Database Engine back-end (tables and
relationships), is called "multiuser" in the Access community.

There's an introductory presentation on Access in a Multiuser Environment
that I did for my user group that you can download from
http://appdevissues.tripod.com. It will identify topics that I thought
worthwhile to discuss, and a bit more. The best collection of detailed
information and links on the subject of Access in the multiuser environment
is at MVP Tony Toews' site, http://www.granite.ab.ca/accsmstr.htm.

Larry Linson
Microsoft Access MVP
May 22 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.