473,320 Members | 2,000 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,320 software developers and data experts.

centralized database

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
3 3454
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

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
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Cherrish Vaidiyan | last post by:
sir, The following are the steps that i followed in setting up standby database on Red hat Linux 9. i am using Oracle 9i. i have followed the steps in this site : ...
2
by: Hifni Shahzard | last post by:
hi, I was using Borland delphi earlier and it was realy easy when it comes to Database oriented application Development. In delphi, it got a centralized table handling module called "Data Module"....
1
by: ss | last post by:
Hi, Could anyone tell me like, how do i do centralized Error Handling, What are all the things I need to take care while Error Handling? How Can I have my own messages instead of system...
0
by: rshekhtm | last post by:
Hi everyone, I would like to get your opinion on a technique I came up with when faced with the problem of redundant code in every web method (authentication, logging, exception handling)....
1
by: vecozo | last post by:
Centralized resource files Hi, We are considering to migrate our custom asp.net localization procedure, to one that stored .Text properties of controls in a SQL database, towards the usage of...
1
by: Lucas Davenport | last post by:
I have the task of creating several one-page websites for our subsidiaries. I would like to use the MasterPage concept with this task. The sites will all be separate site, located in their own...
8
by: PreethiParkavi | last post by:
Dear Friends, We are developing an inventory maintenance project in C#.net 2005 with MSDE as back end.Data can be accessed by multiuser at the same time, because they are from a single...
3
by: shobhitguptait | last post by:
How to Run C#.NET Windows App on N/W with centralized DB using SQL SERVER 2000 Hello All...i m really grate full to c such a website where developers try to help people like us who face problems...
4
by: snfctech | last post by:
I have a project to create a dashboard that will connect to existing systems as well as create new features based on combining data from the existing systems. For example, the dashboard will be able...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.