Xtreme Visual Basic Talk

Xtreme Visual Basic Talk (http://www.xtremevbtalk.com/)
-   .NET Database and Reporting (http://www.xtremevbtalk.com/-net-database-and-reporting/)
-   -   best database platform for simple application (http://www.xtremevbtalk.com/-net-database-and-reporting/328786-database-platform-simple-application.html)

AlanS 10-02-2017 04:01 PM

best database platform for simple application
 
I'm designing a new application that requires basic database functionality (about a dozen tables, fairly simply queries, CRUD operations, etc.). The end users will be non-technical folks, and remotely located, so everything has to be as idiot-proofed as possible. I have extensive experience designing, coding and supporting an application with similar requirements using VB 6 (and an Access database created by the application during its initial run), and could easily use those old technologies, but for obvious reasons I would like to move up to VB.Net under VS 2017.

Some additional requierments for the application:
1. The application must NOT rely on any component or library (reporting tools, database access objects, MS office libraries, any particular version of the Dot Net Framework, etc.) being already present on the end user's machine, and the installation package must include and automatically install whatever's needed.
2. The application must run on Windows XP and all later versions of Windows (which I assume means it must target Dot Net Framework version 4.0).
3. The database used must require zero administration by the end user, and be royalty-free.
4. The application must include some basic reporting functionality, and be royalty-free.

I've got lots of experience using VB.Net with SQL Server in an enterprise environment, but that's not appropriate for this application. I've played around a bit with SQL Server Express 2014 (I'm developing on a Windows 7 machine, so the 2016 version is not an option), an Access database created via OLEDB, an Access database created via DAO, etc., but have run into problems with all of them.

So, my questions are:
1. What database platform would be the most appropriate?
2. Which reporting tool would be best?

Thanks in advance.


All times are GMT -6. The time now is 04:37 PM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Optimisation provided by DragonByte SEO v2.0.15 (Lite) - vBulletin Mods & Addons Copyright © 2017 DragonByte Technologies Ltd.
All site content is protected by the Digital Millenium Act of 1998. Copyright©2001-2011 MAS Media Inc. and Extreme Visual Basic Forum. All rights reserved.
You may not copy or reproduce any portion of this site without written consent.