473,320 Members | 1,862 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.

How do I setup a database for multiple users?

I have a database that I created that will be used by five seperate
people in my company. Everything else I have created in Access has
been for use by one person. I have never setup a database for a multi
user environment and need some help. Can somebody please explain what
steps are needed?

All help is greatly appreciated.

Sep 12 '07 #1
2 2944
On Wed, 12 Sep 2007 13:09:22 -0000, lucky33 <ki*******@bellsouth.net>
wrote:

You need to split your database between tables and everything else.
Then put the tables db on a server, and in the everything else db you
create links to the tables in that db. Give each user that second db.

Newer versions of Access have a wizard to help with this process, but
it really is as simple as I just said.

-Tom.

>I have a database that I created that will be used by five seperate
people in my company. Everything else I have created in Access has
been for use by one person. I have never setup a database for a multi
user environment and need some help. Can somebody please explain what
steps are needed?

All help is greatly appreciated.
Sep 12 '07 #2

"lucky33" <ki*******@bellsouth.netwrote
I have a database that I created that will be used by five seperate
people in my company. Everything else I have created in Access has
been for use by one person. I have never setup a database for a multi
user environment and need some help. Can somebody please explain what
steps are needed?
In addition to Tom's suggestion, there are many other useful items of
information on performance and avoiding corruption at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm and in Jeff Conrad's "Access Junkie"
subsite at http://www.accessmvp.com.

Larry Linson
Microsoft Access MVP
Sep 12 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: BadMan! | last post by:
Hi all, I'm trying to use sqlloader to import a database with multiple different tables which has been exported to one single plain text file. No fixed lenght. Let's say database.txt is...
9
by: Big Slim | last post by:
I'm working on a web application that makes heavy use of CSS, but I would like users to have a degree of control over some of the classes and attributes. To accomplish this, I want to store my CSS...
3
by: Ryan Muller | last post by:
I have a database that I designed for the production floor of my company. One of the problems that I have encountered is that 2 or more users will try to access the database to enter information...
0
by: James Redd | last post by:
Hi, I am looking for a good book or source of information on how to best setup a multiple printer gui. The application I'm working on runs on a server where each user has their own login. The...
2
by: William Herring | last post by:
I would like to set up a zope/database interface (using Postgres 7.4) with the following properties: - multiple users each with their own id and password - accessed via zope - they will enter and...
2
by: John | last post by:
Hi, What is best folder to put database (location of database)? This is because when administrator restricts user rights to read (read and execute), and doesn't give permissions to write in C:...
9
by: TC | last post by:
I need to design a system which represents multiple "projects" in SQL Server. Each project has the same data model, but is independent of all others. My inclination is to use one database to store...
3
by: Nubs | last post by:
I have read that using the database splitter is good because it allows multiple users to access the database simultaneously. However, is it trully necessary to have multiple FE MDE files or can...
3
by: =?Utf-8?B?ZGF2aWQ=?= | last post by:
Last week I asked a question about connection to database from client machine (developer machine). I have changed the database security setup for "SQL Server and Windows" under (local)Windows NT...
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...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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: 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.