about renaming the table ..

20 Sep 2005 8:04 PM

angelito tan

hi ! i'm creating about record system of a school using vb(6), and i
make a table by table to each student .. everytime i add a new student
her/he record go to a new table .. i did it almost perfect, but
unfortunately a little confusion came in me ..

LIKE .........

>> how many table can i put in a database ????.. coz sometimes a school of consist of a thousand student .. and if there's a thousand student my work should capable in holding a thousand table which has the record of a student ..

>> AND the second is ....
>>how can i edit the table ???. can anyone teach me even the basic of it .. i'm using a DAO 3.5 ..

pls.. give a code of editing the table ...

thnx in advance ..

20 Sep 2005 8:18 PM

Bob Butler

Show quote Hide quote

"angelito tan" <diamond_shoe1***@yahoo.com> wrote in message
news:1127246670.483670.72100@g44g2000cwa.googlegroups.com
> hi ! i'm creating about record system of a school using vb(6), and i
> make a table by table to each student .. everytime i add a new student
> her/he record go to a new table .. i did it almost perfect, but
> unfortunately a little confusion came in me ..
>
>
> LIKE .........
>>> how many table can i put in a database ????.. coz sometimes a
>>> school of consist of a thousand student .. and if there's a
>>> thousand student my work should capable in holding a thousand table
>>> which has the record of a student .. AND the second is .... how
>>> can i edit the table ???. can anyone teach me even the basic of it
>>> .. i'm using a DAO 3.5 .. pls.. give a code of editing the table
>>> ...

I can't imagine a database design that uses a new table for each student. I
think you *really* need to re-think this approach.

--
Reply to the group so all can participate
VB.Net: "Fool me once..."

20 Sep 2005 9:50 PM

angelito tan

BTW: yah , i think i have to re-design my work and re-think ... actually
it's my comrade defense in school .. my last question >> how many table
can input in one database ??

*** Sent via Developersdex http://www.developersdex.com ***

20 Sep 2005 10:34 PM

Bob Butler

"angelito tan" <diamond_shoe1***@yahoo.com> wrote in message
news:eSLRk1ivFHA.2808@TK2MSFTNGP10.phx.gbl
> BTW: yah , i think i have to re-design my work and re-think ...
> actually it's my comrade defense in school .. my last question >> how
> many table can input in one database ??

Access (Jet), SQL Server, Oracle, MSDE, Foxpro, DBase, other? What version?

The specific answer is likely to vary. The general answer is "many more
than would be reasonable to create under most circumstances".

--
Reply to the group so all can participate
VB.Net: "Fool me once..."

20 Sep 2005 8:24 PM

alpine

On 20 Sep 2005 13:04:30 -0700, "angelito tan"
<diamond_shoe1***@yahoo.com> wrote:

Show quoteHide quote

>hi ! i'm creating about record system of a school using vb(6), and i
>make a table by table to each student .. everytime i add a new student
>her/he record go to a new table .. i did it almost perfect, but
>unfortunately a little confusion came in me ..
>
>
> LIKE .........
>>> how many table can i put in a database ????.. coz sometimes a school of consist of a thousand student .. and if there's a thousand student my work should capable in holding a thousand table which has the record of a student ..
>
>>> AND the second is ....
>>>how can i edit the table ???. can anyone teach me even the basic of it .. i'm using a DAO 3.5 ..
>pls.. give a code of editing the table ...
>
>
>thnx in advance ..

It sounds like you need to back up and do some redesign of your
database. Rather than having each student as a table, each student
should be a record in a "STUDENTS" table. You should probably further
normalize the associated student data as well.

You might do well to purchase a book on database design to help you
get an idea of where to go with this.

HTH,
Bryan
____________________________________________________________
New Vision Software                   "When the going gets weird,"
Bryan Stafford                      "the weird turn pro."
alpine_don'tsendspam@mvps.org     Hunter S. Thompson -
Microsoft MVP-Visual Basic     Fear and Loathing in LasVegas