It appears that I am going to have to make the jump to SQL Express for my Access back end, for my growing Access DB file in order to share it with my co workers. Although I know what SQL is, I have zero experience with SQL code and servers. Thus I have many know questions let alone more questions that will pop along the way. Some of the questions I have are:
1. SQL Express is a stripped down version of the full blown program. How do I know SQL Express is good enough for my Access needs? I do not want to necessarily go through all the hubbub of downloading, take a figurative crash course to find out SQL is not enough
2. Is SQL is enter level enough for me? I know my way around enough Office to fill in the unknown blanks but I'm totally a newbie with SQL.
3. Presuming I can clear the first two questions, will SQL Express be all I need or do I need separate server space?
4. Can more than one authorized user access the SQL file via SQL Express
5. Since it is web base, will it run on both Windows and OS?
6. AM I biting off too much as a Green horn?
Thanx in Advance