Good afternoon Access Forums,
My current configuration is Win7/Access 2010 with SharePoint 2007 lists as a back-end. We recently "upgraded" to Win10/Access 2013 and now Access will not hold the connection to SP. We have had a "premier ticket" with Micro$oft for about a month and all they have been able to tell me is that they "agree that there is a problem"
The silver lining to this story is that our IT department has agreed to host the tables on SQL - but no one on the staff has ever done anything with Access. To prepare myself, I have watched a series of videos on SQL Server setup and configuration (Steve Bishop - Advanced Programming in Access 2013) and ordered a book (SQL Queries for Mere Mortals).
My question to the forum is what pitfalls and/or guidance can I give to my IT when they are setting up my services? I realize this is a VERY broad subject, what I am interested in for now is to make sure they are set up properly - the other factors (stored procedures, pass thru queries, etc) can be worked out (I think) in time as long as the server set up is configured properly.
Thanks in advance!