Click here to Skip to main content
12,554,005 members (60,425 online)
Rate this:
Please Sign up or sign in to vote.
See more: MFC database
Do I want to let the MFC serialize method store my data in a binary file, create an SQL solution or do I want to create my own method using CFILE to read/write data?

The application will consist of a customer base file with inventory control. Files will most definitely become large quickly. I need it to be multi-user, which makes me lean toward SQL server or maybe MS Access.

Anyone have a specific process that they prefer?
Posted 16-Jul-12 15:57pm
Wes Aday 16-Jul-12 22:27pm
Why would you even consider Access for a multi user situation?
DrBones69 16-Jul-12 23:20pm
It's just another method that I could use, I don't particularly care for the backend/frontend seperation of the database, but it's just a thoughht.

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

For inventory control, I would definitely go towards an actual database. You said it yourself, it's going to get large fast, so relational databases are the best method of storing, recalling, and searching through large amounts of data. It might complicate things up front but it's definitely the right approach.
SoMad 16-Jul-12 22:35pm
I agree. Especially if you are going to be doing any database operations.
I will advice against binary serialization - once you start making changes in your data model the backwards compatibility handling becomes very nasty. Serializing to XML is a step up and compatibility is easier to handle, but can still require non-trivial updates to the code.

Soren Madsne
DrBones69 16-Jul-12 23:24pm
Would it be in my best interest to write the code in a network approach (ie. Internet compatible/capable)?
Albert Holguin 16-Jul-12 23:48pm
Yes, that way your database doesn't have to be in the same computer as your client software. If you want a good model software package, see Bugzilla. They store everything to a database and allow the clients to access via internet browser, you don't have to necessarily do it via a browser but it does have a lot of advantages (platform independence, no need for client side installation, plus just about everyone knows how to use a browser).

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.161021.1 | Last Updated 16 Jul 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100