I am preparing to develop a software application and am planning in using MS Access. It has been a few years since I developed in Access and I thought I could get some general questions answered and some initial guidance before I start.
#1) I want to distribute the application to all people in the company but not everyone has MS Access. Can that be done? What is required?
#2) The data already resides in MS SQL Server. In the old days you would create linked tables. Now I think they have an Access Project that connects to SQL Server intentionally. Is that correct or is there a better way to use SQL Server as the back end?
#3) Which version of Access would be best to use? I think I have Access 2003, 2007, 2010, and 2013.
#4) Any other words of wisdom?
Thank you for your help!