I have an application I've been developing in Access 2010. I should start by saying that when I started this project in January, I was a raw beginner with Access. I've taken a few on-line courses, read some books, gotten a
lot of help from folks on the forums, learned a lot about code over the past 6 months, and as a result have a pretty nice little application.
Now, however, it's time to go online with it. The application will have about 30 users who will upload small amounts of data once or twice a week, and 4 to 6 admin folk who will be running reports and down-loading data. However, the users are spread over
3 counties and the back end will be mounted on a web-based server. I've been told that Access will not perform as a back end under these circumstances and I need to migrate the back end to SQL Server.
Since we're only talking a dozen or so tables and nothing else, I expected this to be reasonably simple. I downloaded SQL Server Express 2010, ...
Go to the complete details ...