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,dataset,bindingsource 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.acceptchanges() 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]

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.