A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I set up a an Access DB so users can open simultaneously



 
 
Thread Tools Display Modes
  #1  
Old November 16th, 2005, 04:33 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default How do I set up a an Access DB so users can open simultaneously

so I need to be on SQL server??
  #2  
Old November 16th, 2005, 05:49 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default How do I set up a an Access DB so users can open simultaneously

Access databases can be shared. The preferred method is to split the
application into two databases. One database, called the back end, will
contain ONLY tables. The other database, called the front end, will contain
all other objects plus links to the tables in the back end. The back end
database is placed on a network share and the front end is distributed to
each user although it is possible to share the front end also. It just
makes for a less stable setup.

"CeeCee" wrote in message
...
so I need to be on SQL server??



  #3  
Old November 16th, 2005, 06:14 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default How do I set up a an Access DB so users can open simultaneously

On Wed, 16 Nov 2005 08:33:32 -0800, CeeCee
wrote:

so I need to be on SQL server??


No. Access is multiuser, out of the box, by default.

What problems are you having?

John W. Vinson[MVP]
 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Visio Shortcuts [email protected] Visio 1 December 28th, 2006 11:28 PM
Allowing restricted users to open access databases [email protected] General Discussion 10 October 3rd, 2005 06:37 PM
slow to open Access XP over the network ngan General Discussion 11 August 2nd, 2005 05:58 PM
Open and filter a report from a control value on a data access pag Mona-ABE Setting Up & Running Reports 0 November 5th, 2004 01:45 PM
You do not have exclusive access... ERROR Robin General Discussion 1 July 6th, 2004 01:18 AM


All times are GMT +1. The time now is 12:27 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.