VB/Access : Building a new Table
Quote:
>I have a Database in MSAccess and a program in VB with Datacontrols to some
>tables.
>One of the query's is a Table Make Query. I want to run that one from Visual
>Basic. Not a problem I thought. But when the query starts the computer
>starts to cry that the table already exist.
>So what ?
>I know this !
>And it's nice that my computer knows this !
>But why it's necesary that the computer tells me about this by a message ?
>And why doesn't he just his job and build the table anyway ?
>Now I have to shut down the form where the datacontrols are in. Drop the
>Table and build a new one with a table make query. And open the form with
>the data controls again. Very user friendly ??
>The solution to delete the data in a table is not a sollution.
>If you can solve this problem in a better way, please answer.
Sounds like you want to use an Append query rather than a make-table
query for adding records to an existing table.
Peter L Reader, posting from Portland, Oregon where the weather is lousy.
-----
