can an Access DB and a SQLce DB be used by multiple people simultaneously ?
-
I always assumed that accessing the same Access database by multiple users somehow just works, i.e. many users can read and write to an Access database in a shared folder on the network. I assumed the same functionality with SQLce. However, I've never been able to test it. Does it work as I assumed ?
-
I always assumed that accessing the same Access database by multiple users somehow just works, i.e. many users can read and write to an Access database in a shared folder on the network. I assumed the same functionality with SQLce. However, I've never been able to test it. Does it work as I assumed ?
abiemann wrote:
I always assumed that accessing the same Access database by multiple users somehow just works, i.e. many users can read and write to an Access database in a shared folder on the network.
Happens way too often and although Access provides locking-mechanisms and the likes, you'll find that it fails to perform adequately. SQL Express is also available free, and you can easily upsize your Access-database to SQL Express.
I are Troll :)
-
I always assumed that accessing the same Access database by multiple users somehow just works, i.e. many users can read and write to an Access database in a shared folder on the network. I assumed the same functionality with SQLce. However, I've never been able to test it. Does it work as I assumed ?
Yes, it works as you assumed... However, in both cases, each user needs to have their own front end installed (whether that's an Access DB, VB, whatever) You don't want a bunch of users opening the same file at the same time (ie: a single access database containing both tables as well as queries, forms and reports....)
I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!
-
Yes, it works as you assumed... However, in both cases, each user needs to have their own front end installed (whether that's an Access DB, VB, whatever) You don't want a bunch of users opening the same file at the same time (ie: a single access database containing both tables as well as queries, forms and reports....)
I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!
the Access DB is used to only store data and it will be located in some shared folder on the network. There's about 10 client apps (which is probably what you meant by "front end") that will, at any point of time, read data from the database and also write data to the database. Forms will not be implemented in the database directly.
-
the Access DB is used to only store data and it will be located in some shared folder on the network. There's about 10 client apps (which is probably what you meant by "front end") that will, at any point of time, read data from the database and also write data to the database. Forms will not be implemented in the database directly.
Access and SQL Server will both be fine as a back end then...
I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!