I am a long-standing (if occasional), Access developer (started dabbling in v1.1 !) and despite some frustrations, generally love the environment - particularly when married to a SQL server back end.
Access VBA allows me to do what I need to do and, in the SME environment in which I operate, the built-in report designer means that I can build wall-to-wall solutions for my clients within the same development environment.
However, a new project is forcing me to consider moving away from Access. The initial stage of the project seems ideal for an Access/SQL Server solution - input data from a (paper) application form and then, after processing the data, print out a quotation to be posted back out .
To start with, input will be done solely at our client's HQ and they already have SBS 2008 Premium (so SQL Server 2005) and Access 2010 on the desktop - great.
HOWEVER, moving forward, it is "likely" that input will additionally be done by a sales team in the field and/or by the end client themselves. Clearly, using Access in such a distributed environment would be 'interesting' to say the least !
So, the short question is, what would anybody recommend, bearing in mind my current skill set and the short and (likely) long term requirements ?
As always, any help or guidance appreciated.