PC Review


Reply
Thread Tools Rate Thread

Can Access database be accessed by multiple users at the same tim

 
 
=?Utf-8?B?U2hhcm9u?=
Guest
Posts: n/a
 
      29th Jun 2006
I wish to create a database for use by many users in input data. Can
multiple users access the database at the same time and input data?
 
Reply With Quote
 
 
 
 
Allen Browne
Guest
Posts: n/a
 
      29th Jun 2006
Yes, Access is a multi-user program.

The standard way of doing this is to split the database. If that is a new
concept, see:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Sharon" <(E-Mail Removed)> wrote in message
news:F3922E68-479F-4E4D-930C-(E-Mail Removed)...
>I wish to create a database for use by many users in input data. Can
> multiple users access the database at the same time and input data?



 
Reply With Quote
 
=?Utf-8?B?SmVycnkgV2hpdHRsZQ==?=
Guest
Posts: n/a
 
      29th Jun 2006
Yes. With a well designed database, 20-25 users are usually no problem. By
'well designed' you need to know about normalization and splitting a database.

Here's one resourse on splitting a database.
http://www.databasedev.co.uk/split_a_database.html
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Sharon" wrote:

> I wish to create a database for use by many users in input data. Can
> multiple users access the database at the same time and input data?

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Users of an Access Database Patricia O''Donnell SSJ Microsoft Access 2 20th Mar 2009 03:57 PM
Multiple users on an Access database AlanK Microsoft Access Security 6 5th Mar 2008 08:27 AM
Re: Access 2003 - Timesheet Form to be accessed by multiple users John Nurick Microsoft Access Forms 0 22nd Dec 2006 01:49 PM
multiple users in access database =?Utf-8?B?RmVobg==?= Microsoft Access 0 24th Oct 2005 12:05 AM
access database for multiple users =?Utf-8?B?bWVnYW4=?= Microsoft Access 8 8th Dec 2003 09:08 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:03 PM.