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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Read Write File
I currently have a database on Excel, the problem is that
it is a spreadsheet on a network and that not more than one user can access it at a time. They end up in a read write file. If I purchase access will I be able to have the same set up but it will run in real time and We all can make changes to it? |
#2
|
|||
|
|||
Read Write File
As long as the users are not trying to use the same record at the same time, they should be able to make changes to records in the same table.
Corrina Burnley Burnley Data Solutions www.burnleydatasolutions.com |
#3
|
|||
|
|||
Read Write File
Yes. You put the back-end (database with the tables) on a server and
the front-end (database with the forms, queries, etc.) either on everyone's workstation OR also on the server. Assuming you are using a "BOUND" database, if someone has Jack Jones' record open, then that record will be "locked" until his record is closed. But users will will able to add/edit any other record. Also, you will omit a LOT of duplication! (The last thing you want to do is treat Access tables like the flat-file of Excel. For example, if you have a customer with many purchases, you will need to enter his name, etc. only once, rather than multiple time on each purchase, as in Excel.) ---Phil Szlyk " wrote in message ... I currently have a database on Excel, the problem is that it is a spreadsheet on a network and that not more than one user can access it at a time. They end up in a read write file. If I purchase access will I be able to have the same set up but it will run in real time and We all can make changes to it? |
#4
|
|||
|
|||
Read Write File
On Tue, 11 May 2004 08:55:46 -0700, "
wrote: I currently have a database on Excel, the problem is that it is a spreadsheet on a network and that not more than one user can access it at a time. They end up in a read write file. If I purchase access will I be able to have the same set up but it will run in real time and We all can make changes to it? As noted elsethread, yes... IF you migrate your data into Access. Storing the data in Excel will - by the nature of Excel - keep it single-user; Access Tables are inherently multi-user. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|