Using Access tables linked to Sharepoint lists

[JamesN]

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

 

[liddlem]

As far as I am aware, Sharepoint is SQL Server - so FAR more robust than Access database.
Recently, I've been looking at doing this too. Am interested to know if you run into problems.

 

[JamesN]

Liddlem, we have been using sharepoint lists to store our data for around 6 months now. Before trialling this I had no idea if it would be effective but we've not ran into any issues. The only thing which can be a bit difficult at times is when you link your tables to the share point list you lose some functionality with some of the sharepoint limitations. Think it depends how complex you need it to be, for us it is simply data collection