-
Hi,
I have written a program in VB that I want to distribute (shareware). My problem is that it heavily uses SQL Server for it's database.
What would you recommend I use instead because I obviously can't rely on people having SQL Server 7 on their machines! :rolleyes:
Is there like a free database anywhere or shall I use some sort of flat file system?
Any suggestions welcome.
Thanks
Totally :confused:
-
A lot of people of Access, how much data are we talkin' here? You can use the registry for small amounts of data or some form of flat file.
-
hmm, it's quite a lot of data. I use SQL because it is so fast and the Stored Procedures really help.
I have considered moving to Access but there are still issues with that:
1) Which version should I use? (I use Access 2000.)
2) Am I allowed to distribute Databases made with Access?
3) If the person hasn't got Access am I allowed to ship the Dlls with my program to use it? (Not the whole Access of course!!)
Thanks
Totally :confused:
-
Definately Access doesn't have the functionality that SQL does but a client should be able to access the data via your program regardless of whether they have access or not. And yes you can distribute Access databases. As for versions 2000 should be backwards compatible.