Hi,
We have a split MS Access database, with the FE distributed to users local C drives and the BE on a shared folder accessed over a VPN. I know not recommended, but it worked well enough when the number of users was low. The problem is now there are 30+ concurrent users and we are getting corruption issues (database has a number of Memo fields) and speed/performance issues.
We are evaluating whether to move the BE to either a SQL server or Sharepoint Lists. I know SQL is the best solution, but this is only a short term database solution, so wondering if Sharepoint is more viable. The tables are large with 100+ fields, but relatively few records (2-3000), so the 5000 limit shouldn’t be a problem.
Can anyone give me any pointers as to the pros and cons of Sharepoint Lists? Is this a realistic solution?
Thanks for any help!
Jim
We have a split MS Access database, with the FE distributed to users local C drives and the BE on a shared folder accessed over a VPN. I know not recommended, but it worked well enough when the number of users was low. The problem is now there are 30+ concurrent users and we are getting corruption issues (database has a number of Memo fields) and speed/performance issues.
We are evaluating whether to move the BE to either a SQL server or Sharepoint Lists. I know SQL is the best solution, but this is only a short term database solution, so wondering if Sharepoint is more viable. The tables are large with 100+ fields, but relatively few records (2-3000), so the 5000 limit shouldn’t be a problem.
Can anyone give me any pointers as to the pros and cons of Sharepoint Lists? Is this a realistic solution?
Thanks for any help!
Jim