So, a single user application, all data is local, no remote access ....
If a go with an Access file (DB), from the user's perspective, they simply install the app and they are good to go.
Is it the same if I go with a SQL DB, or do they have to have SQL or SQL Express installed?
I ask because I'd rather go with a SQL simply because the potential for exceeding the 4GB limitation of Access is a remote possibility. However, I know if I require my mates to install SQL or SQL Express ... many will pass on it.
I'm aware of techniques to get creative with Access DB splitting, and using multiple Access DBs ... but that's not relative to the question. :)