Hi,
I'm currently setting up a database using Access 2010 as a front end and have synced the data tables to Sharepoint 2013. The main front end form simply adds new records to one main table, whilst the other forms run SQL queries to update columns in the same table. I'm not using any relationships but I am using queries/reports reflecting data from this table.
It has been trialled with no issues yet occuring, with up to 30 users accessing at one single time and the table reaching up to 60k records.
Is this something Sharepoint lists will be able to cope with longer term or am I going about this the wrong way?
Thanks in advance
I'm currently setting up a database using Access 2010 as a front end and have synced the data tables to Sharepoint 2013. The main front end form simply adds new records to one main table, whilst the other forms run SQL queries to update columns in the same table. I'm not using any relationships but I am using queries/reports reflecting data from this table.
It has been trialled with no issues yet occuring, with up to 30 users accessing at one single time and the table reaching up to 60k records.
Is this something Sharepoint lists will be able to cope with longer term or am I going about this the wrong way?
Thanks in advance