The problem is that all sites by default ALWAYS have a table called UserInfo.
I mean, if you just going to create your own table, then just re-name the table and publish and you done in 10 seconds. So the issue here is I assume that you want to use the UserTable from the SharePoint site?
Keep in mind that all sites have that "userTable" by default. So, delete your local user table. You may very well have to delete your reports + queries based on that UserTable since they don't exist and you will NOT be able to publish those objects (so make a copy of your application, and then remove the reports + query with user table - you might not have to do this, but suspect you will).
Now, publish your application.
Next step is to simply now link in the user table.
You can "add" the user table back by linking to the site that Access just created by publishing your application.
On the ribbon External data, and then choose (usually from the dropdown called "more"), simply choose SharePoint list. When the link wizard starts, enter the SAME url of the web site you just published (you can cut + past that URL from backstage if you like me and don't like to type).
Now, in the list of available tables (lists), you will see the user table as a choice. Link it in
Now you can build your reports + queries etc. with that user table included. (just import the queries and reports in the above copy you made as I mentioned if you did have to delete them).
So, you cannot publish with a local copy of that UserTable. But, after you publish, you can link in the user table and then design + use that table from that point on in your application.
And as noted, if you have some reports + queries in the un-published app, then you may very well have to remove them before you able to publish (the compatibility checker will possbile complain).
