As in an offline copy instead of just Linking to the live data?

Could you please expand?

My question was more for you to expand on what you needed.

Did you follow Lesson 3 and transfer your Access Table to SharePoint, then link it back to your db?

Is that what you're having trouble with?

I have no problem so far. I just convert my tables to Share Point now the database table will be updated in the share point tables I wonder what to do for download tables from share point to access?  I went to share point and the table has an expot but in CVS and Excel not access.  Any thoughts?

That's the linking part, did you do that step?

Are you asking to return the SharePoint tables back to Access tables? If so, you can right click the linked table and make it a local table again. But this would defeat the use of SharePoint. I use SharePoint but I have both linked sp tables and local tables. That is possible if that is what you need.

Responding your firs question.  I glad to speak with somebody have experience working with SP and Access.  My concern is what to do when I continue to expand the database with new tables  the front end file is not the problem is new tables or change in old tables that is more easy to work in access.  I understand you will refer me to the linked but can you be more specific on this?  There is a YT video that can guide me to stablish those link?  Gracias por toda la ayuda.

If you have linked the SharePoint Table (List) any changes you make to that can be updated when the link is refreshed.
If you create a new table just (re)link like you have with another table.

Was the Seminar not clear on those steps?

Hi Leo,

I've started using SP about 1 month ago, and there working fine, this is the way i update sharepoint lists
1. create a new database and link this only to the lists you want to update.
2. convert then to local tables
3. add/update fields in the tables and add some new tables if needed
4. upload all the tables back to sharepoint from the new database
5. reopen you original database remove the linked tables (SP lists)
6. relink the updated/new lists

BEWARE, if you have missing ID autonumbers,  they are renumberd on reupload to sharepoint
Link the old lists/tables and the new lists/tables and use update query's to update the referenced ID's in other lists.
see my post on "tables to SharePoint"  from Eileen Blake (10days ago)