Hi guys, I am newbie who are extremely low-tech.
I am currently building up a MS Access database with Tables, Forms, Queries, Reports for a team of around 6-8 people. We are working in a new office with no shared networks, no Microsoft Office Enterprise yet. Each of us is using our own individual MS Office. Now that I want to create this database and will split BE and FE so that all of us can work simultaneously. Could you please correct me if I am wrong, I now understand that I need to move the BE to either a shared network or a SQL Server, and leave the FE on each of our own PC to make it work, theoretically.
Now after some considerations, I think I would go for a SQL Server as we already have a shared Dropbox folder so we would not probably need one more shared net work. In this case, could you please advise me what package of SQL Server should we buy so that we could all use this database? I did a little research but I was confused by the amount of terminology thrown at me :'( Do we only need 1 SQL Server Account or 6-8 of them to make it work? And what are CALs in this case?
Thanks for your time to enlighten me folks!
I am currently building up a MS Access database with Tables, Forms, Queries, Reports for a team of around 6-8 people. We are working in a new office with no shared networks, no Microsoft Office Enterprise yet. Each of us is using our own individual MS Office. Now that I want to create this database and will split BE and FE so that all of us can work simultaneously. Could you please correct me if I am wrong, I now understand that I need to move the BE to either a shared network or a SQL Server, and leave the FE on each of our own PC to make it work, theoretically.
Now after some considerations, I think I would go for a SQL Server as we already have a shared Dropbox folder so we would not probably need one more shared net work. In this case, could you please advise me what package of SQL Server should we buy so that we could all use this database? I did a little research but I was confused by the amount of terminology thrown at me :'( Do we only need 1 SQL Server Account or 6-8 of them to make it work? And what are CALs in this case?
Thanks for your time to enlighten me folks!