Sharing an Access 2007 db with 70 users

[ohappyday]

Hello -

I need some advice on how to share a db with mutliple users across the WAN.

Each user will access the db to input their work hours and tasks. I am not sure of the best way to share without major issues.

I was thinking of splitting the db into FE and BE and placing the BE on a shared network drive.

Others have mentioned SQL, but I not familiar with coding in SQL.

Any advice would be appreciated.

Thanks!

 

[HiTechCoach]

Every database in production should be split. If use by multiple users it MUST be split.

I thing by "SQL" you are really meaning a SQL Server as the back end. Note: Access uses "SQL" for all queries.

TIP: Learning the correct terminology will make you life a lot easier when searching

See:

Using a wan with ms-access? How fast, how far?

 

[ohappyday]

HiTechCoach -

Thanks for the TIP, but I think I was using the correct terminology.
My reference to SQL was referring to the BE.

 

[ohappyday]

I think I found some dialogue with 'bob larson' and another user that may help with my question.

HiTechCoach - Thanks again for your response.