Creating a database to store scores?

[paralinx]

Hey all,

I have created a game for 1st grade kids and I need a way to store the kid's highscores after they finish the game, so the other kids have something to shoot for when they play the game. I have see in other posts stuff about databases, but I know nothing about them. What would be the best way to store and then send back to my program about 600 "high scores" from 30 computers?

thanks

[si_the_geek]

For an intro to using DB's from VB, see the "ADO Tutorial" link below. The code isn't quite what you want, but is close enough to help you understand.

As long as the database is on the same network as the computers the program is being run on, you should have no problems working with it.

[paralinx]

thanks that helped a lot,

however I have one question.

Is there a way to clear all of the data of the fields, so I can rewrite them?

[ganeshmoorthy]

Yes, you can delete all the records and add new ones or you can edit the field values with the new ones...you can decide which you want to use...

Sql = "Delete From <TableName>
    'with a condition
    Sql = "Delete From <TableName> Where <FieldName> = <Value>
    'then perform the Delete
    Cn.Execute Sql
 
    'To Update/Edit
    Sql = "Update <TableName> Set <FieldName> = <Value> 
    Sql = Sql & " Where <FieldName> = <Value>
    Cn.Execute Sql

[Vishalgiri]

If you want to clear all the field then better option will be renaming the database file (if it is MDB) or you can backup the database and keep a empty database and copy it to your database whenever you want to do so..

I hope you got my idea