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 » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Using my database



 
 
Thread Tools Display Modes
  #1  
Old February 6th, 2006, 09:29 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Using my database

You have two options.

1. Have all the users on the same network and put the database out on a
shared drive. Make sure that each user has full permissions for the folder
where the mdb file resides. Your best bet is to split the database with the
tables out on the network and the forms, reports, etc., on each user's
computer.

2. If the users can't be on the same network, such as salespeople out in
their cars, then there is replication which is a lot of work.

Cutting and pasting, importing spreadsheets, or any other similar workaround
is a private heck that I wouldn't wish on you.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Miguel Vivar" wrote:

Pretty soon I'll be using my database, and I want several users to work on my
database at the same time. How can I make the information entered in my
database from all these users to go to only one database if they would be
working in different computers but same database? or Do I need to create a
network? or should I use the copy and paste feature to transfer all the data
from the tables of these users once they finish working, and transfer to a
database in my computer?

Miguel

 




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
Report based on rst in other database swedbera Setting Up & Running Reports 5 October 6th, 2005 11:41 AM
Access can't open database Scott B General Discussion 1 June 28th, 2005 04:16 PM
Converting 97 database to 2003 database and implications John Database Design 1 November 22nd, 2004 05:23 AM
cannot change password Richard General Discussion 13 November 14th, 2004 10:00 PM
What is MDE Charlie General Discussion 4 August 24th, 2004 04:15 PM


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


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