Database (Spreadsheet) Help.

[GameDesigner]

Let's say 10,000 at most then if anything a little more but not overly massive.

[droberson]

OK, Excel will be fine. Do you have Excel installed on your system? Are the other computers that will access the Excel file on the same network or is this connect to be via the internet? Will the other systems be adding records, deleting records, modifing records???

[GameDesigner]

The excel wile will be shared on an internal network. All PC's will be on this network. If possible it would be nice to be able to create the records/test cases via the MMF program but if not I can always alter it in Excel myself. Same goes for deleting if possible then yes. I can always set permissions later if I don't want them too. Other then that the only thing that for sure will be updated is the Pass/Fail option (Can be a radio button or drop down list) If they select that option and save I would like that to be reflected in the Excel file as a pass or fail as I plan to have the excel file linked to a webpage so that current results will always be visible.

Is that enough info?

Thanks.

[droberson]

Ok, Will more than one person be wanting to edit the data in the excel file AT THE SAME TIME? This is not possible with the excel odbc driver.
Also, you can add and edit the records with sql statements but to delete records you have to open the file in Excel to do so I believe.

On the windows pc you need to first set up the odbc data source. If you are going to use Excel and Excel is installed on the computer you should be able to go to the ODBC data source administrator and create the system data source. Are you using XP or Vista. ODBC data manager is part of the Administration Tools in Vista.

You need to see if you have an Excel driver. (If the restriction above may cause a problem then I suggest using MySQL database.)

Open Excel and create a spreadsheet and in the first row add your column headings. The Excel ODBC driver requires this.

Save the spreadsheet in a folder that you will share on the network.

Let me know when this done or if you have further questions.
Once done we will need to see if you can create a simple MMF2 app that connects to the excel file and add a record.