Databse problem

[explode]

Can anybody help me? I'm trying to make a program that uses a access
database with VB 2005.I made one base table and by draging it to a form
(form2) VB made tableadapter,da taset,bindingso urce and tablenavigator. When
I try to change te name of the Table1 by clicking on a button on form1 and
open form2 everything is OK,but when I close form2 and try to reopen it,name
of the table changes back to Table1.
I tried dataset.acceptc hanges() and on the table also but nothing helps!

Also when I add a new table the same thing hapens it exists first time form2
opens nad then gone.

Can I change tableadapter query's in code?
How?
I wont to change the FROM Table1 statement to FROM newtable.
For access database in VB2005 i can only do it from the designer and for an
existing table!

I'm using Visual Basic 2005 Profesional edition and Access 2003 database.

Thanks!

[RobinS]

Re: Databse problem

It's not really clear what you are trying to do.

When you say you made a base table, what do you mean? You set up a
strongly typed dataset pointing at a specific table?

And I completely don't get what you mean about changing the name
of the table and the deal with the forms.

As for changing the table adapter's query in code, no, I don't think so.

Can you be more specific about what you're trying to do?

Robin S.
------------------------
"explode" <ured@mzos.hrwr ote in message
news:eojmlg$ibm $1@news1.carnet .hr...

Can anybody help me? I'm trying to make a program that uses a access
database with VB 2005.I made one base table and by draging it to a
form
(form2) VB made tableadapter,da taset,bindingso urce and tablenavigator.
When
I try to change te name of the Table1 by clicking on a button on form1
and
open form2 everything is OK,but when I close form2 and try to reopen
it,name
of the table changes back to Table1.
I tried dataset.acceptc hanges() and on the table also but nothing
helps!
>
Also when I add a new table the same thing hapens it exists first time
form2
opens nad then gone.
>
Can I change tableadapter query's in code?
How?
I wont to change the FROM Table1 statement to FROM newtable.
For access database in VB2005 i can only do it from the designer and
for an
existing table!
>
I'm using Visual Basic 2005 Profesional edition and Access 2003
database.
>
Thanks!
>
>
>