i need some help with a game database program

Ok this is a long one guys... ok, i am making this program for my brother to catalog all of his games, movies, and applications, he wants the catagoreys like (I'm attaching the source code, FYI) name, serial no, version, company, publisher, company web, publisher web, and so on. So obiously i'm thinking access database, and so things go pretty well.. for a while... then he says he wants to be able to add new catagoreys (tables in the terms of databases)... from the code.. he doesnt want to have to ask me to make it, and then recompile it and so on, so finally i find this code to make a table in the code but now i've run into another problem. the fields, to make perfect sense of the problem you should d/l the source code (its only 1 meg so).

in any case i was wondering if you guys could take a look at it and make some suggestions. i'm now thinking of reprogramming the whole thing and using ini files for the records and stuff, but i dont know... i mean thats still a lot a code to just abandon :confused:... but take a look at it and make some suggestions please.

BIG THANKS TO YOU GUYS!

PS
Sorry i didnt notice the other database devolpment section.. although this post isnt THAT out of place ;)

-----


ok the attachment has a limit (i feel really dumb) so i am uploading it to my personal website:

Source Code

Hey there!
Sounds very interesting. Your challange is to create the forms and tables on the fly. Creating new table can be done by using SQL's CREATE statement:

selcri = "Create table [tb1]([text1] TEXT (255),[text2] TEXT (155))"
adocon.execute selcri

You'll need to get the fieldname, fieldtype and size info from the user, use these parameters in your CREATE statement as fields.

The real challange is this to create dataentry and query system on run time, very challanging but achievable. It might take a couple of rounds but I think we can do this. Lets invite others also to chip in (so hey all you guys, this can be a good online teamwork job!!!). You game for this Aurther_Dent251?

Diban

hey that sounds like a good idea, i'm game for it. if you have hotmail, add me to your buddy list ([email protected]) and the same to anyone else who wants to help out! just remember to identify yourselves by saying ur from the vb forum, or else i'll think your an internet stalker ;)