Libre
been around a little
- Local time
- Today, 15:28
- Joined
- May 3, 2007
- Messages
- 660
I know there must be other threads about this - please allow me to start this discussion anew, so that I may restrict it to my concerns without poring over other possibly similar threads.
I have a fully developed Access db with 2-3 users. This db will be moved to another environment where there may be 20+ users. I've heard many times that Access is not "robust" enough for a "real" production environment, and that SQL Server is for the BIG BOYS, while just Access is for kids. More or less.
Is this true, in your opinion?
Does SQL Server offer more in terms of security, multiuser capability, stability...or what?
I would still want MS Access for the front end, user interface, stored procedures, functions, etc - um, right?
If not an Access GUI, what then?
Can anybody give me the lowdown, without getting into too many technicalities - sort of the 40,000 foot view? Am I going in the right direction?
I have zero experience with sql server, how to code instructions for it (I do know basic SQL and VBA) - where do I start?
Or even, SHOULD I start?
Thanks to all
I have a fully developed Access db with 2-3 users. This db will be moved to another environment where there may be 20+ users. I've heard many times that Access is not "robust" enough for a "real" production environment, and that SQL Server is for the BIG BOYS, while just Access is for kids. More or less.
Is this true, in your opinion?
Does SQL Server offer more in terms of security, multiuser capability, stability...or what?
I would still want MS Access for the front end, user interface, stored procedures, functions, etc - um, right?
If not an Access GUI, what then?
Can anybody give me the lowdown, without getting into too many technicalities - sort of the 40,000 foot view? Am I going in the right direction?
I have zero experience with sql server, how to code instructions for it (I do know basic SQL and VBA) - where do I start?
Or even, SHOULD I start?
Thanks to all