Databse problem

  • Thread starter Thread starter explode
  • Start date Start date
E

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!
 
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.
 
Back
Top