<div>
Yes, this project is a combination of tables and linked SharePoint list. &nbsp; &nbsp;Just to confirm I understand on the backend will be the tables and on the front end will be the linked tabled and the linked SharePoint list<br />
<br />
Thanks for your help
</div>


<div>
Yes - the Backend should contain only the Access tables, and nothing else. All links, including those to your SharePoint lists, would be in the FrontEnd.<br />
<br />
Be sure to make a copy of your database before you do this, just in case.
</div>


<div>
Thank you for you guidance working great
</div>


<div>
<div class="content wysiwyg-content">
I am preparing to rollout to the staff. &nbsp;I have split a database before with no issue but this database is different in that I have linked SharePoint List.<br />
<br />
When I try and split the database I get the following message &quot;Subscript out of range&quot; and it does no complete the task<br />
<br />
What does this mean and how do I fix so I can split the database and push out to the end users.<br />
<br />
Thanks for your guidance
</div>
</div>


I am preparing to rollout to the staff.  I have split a database before with no issue but this database is different in that I have linked SharePoint List.

When I try and split the database I get the following message "Subscript out of range" and it does no complete the task

What does this mean and how do I fix so I can split the database and push out to the end users.

Thanks for your guidance

Database Split

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.