Re: Creating Shareware Database App in VB 6
From: Jim Carlock (anonymous_at_127.0.0.1)
Date: 05/01/04
- Next message: Suzette: "Re: Passing date value to Access database"
- Previous message: The Bit Bandit: "Re: Creating Shareware Database App in VB 6"
- In reply to: The Bit Bandit: "Re: Creating Shareware Database App in VB 6"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 30 Apr 2004 21:55:42 -0400
You could use Access 1 if you'd like. Access 1 is fully
supported by MDAC/Jet/ADO/DAO. It's all backward
compatible. The only thing that you'll have a problem with
is using a newer version of access to open the database.
This won't happen but you can gain full access to the older
version by setting up links in a newer version.
As far as size goes, MDAC will probably be bigger than
everything else. CR files will amount to about 3 to 10 MB
uncompressed. MDAC will be about 5MB compressed.
I'm not sure about what comes with CR 9, but CR 4.6 or 6
amounts to approx. 3 MB uncompressed. Maybe 4 MB if
I were to include some of the extras that CR provides.
Hope that helps.
-- Jim Carlock http://www.microcosmotalk.com/ Post replies to the newsgroup. "The Bit Bandit" <bitbandit@ureach.com> wrote in message news:346d6664.0404301535.56968777@posting.google.com... Thanks very much, Michael, for your suggestions; I found them very useful. To answer some of your questions: "Michael Cole" <someone@microsoft.com> wrote in message news:<#r#JdkNLEHA.2100@TK2MSFTNGP10.phx.gbl>... > One major question that requires an answer - what are the security > requirements for the data? Do you have a problem if people access the data > directlt without going through your front end. There are really no security requirements. My app is a database to keep track of a person's hobby (think of a database for stamp collectors). > MDAC is a group of technologies that include ADO and DAO, not a seperate > technology. Note that MDAC is available from MS as a download, so you could > simply say in your installation that it requires MDAC, and the users should > get it themselves, if required, from the MS website. That's a possibility, although my users tend to be fairly clueless and so I want to make installation as easy as possible (my typical user is a grandmother who is new to computers). > Another possibility is to simply use text files as your data storage > mechanism. DAO and ADO can both read and write to text files. This would > depend upon the amount of data and your requirements in updating and > modifying such at your end. Hmm, that's an interesting idea. The number of records may reach the low thousands (i.e. probably no more than 2000). And I don't need to store any binary data in the files. But I do need to store memo fields which may contain new-line characters. Is this a problem with text files? > > I'm looking at using Crystal Reports 9 to handle my reporting, so > > obviously CR has to be able to access the database files, either > > directly or via ODBC. > > No issues. CR has its own set of database drivers, seperate to MS drivers. Do you have any idea of the size of the CR run-time files? I'm just wondering how much weight CR will add to my distribution file. Most of what I've read while I've been researching this has assumed that the app was being developed for in-house use and therefore considerations regarding distribution size, updating the app, etc aren't a problem. I've found a book called "Visual Basic 6 Database How-To" by Sams, hopefully that will give me some ideas.
- Next message: Suzette: "Re: Passing date value to Access database"
- Previous message: The Bit Bandit: "Re: Creating Shareware Database App in VB 6"
- In reply to: The Bit Bandit: "Re: Creating Shareware Database App in VB 6"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
