Sharepoint backend access database.

[mopey12345]

Hi

I have a small access database 100 -200 records. When I tried to spilt it, put the data table into a sharepoint folder, and distribute just the front end, started with integrity errors.
It was working ok up until then. I have put it back together so we can continue using it, Any ideas what I have done wrong? Thanks Phil

 

[jackd]

I am not a sharepoint user. However, Albert Kallal gave a presentation on Access and Sharepoint which may be helpful to you.

 

[mopey12345]

I am not a sharepoint user. However, Albert Kallal gave a presentation on Access and Sharepoint which may be helpful to you.

Thanks for replying. Appreciated.

 

[JonXL]

I don't believe you can just store the .accdb data file on SharePoint. It won't be able to lock it, etc. for folks to access properly.

When I want SharePoint as a backend, I create the table(s) as list(s) on SP and then link there using the external data settings in the Access FE. It looks like the video linked to may cover this but I'll confess to having not really watched it other than to skip around and get an idea of what was there.

 

[mopey12345]

I don't believe you can just store the .accdb data file on SharePoint. It won't be able to lock it, etc. for folks to access properly.

When I want SharePoint as a backend, I create the table(s) as list(s) on SP and then link there using the external data settings in the Access FE. It looks like the video linked to may cover this but I'll confess to having not really watched it other than to skip around and get an idea of what was there.

Thanks for responding.