Read Write File

  • Thread starter Thread starter shawna
  • Start date Start date
S

shawna

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?
 
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
 
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?
Click to expand...

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.
 
Back
Top