Database name change

  • Thread starter Thread starter mpwelsh
  • Start date Start date
M

mpwelsh

Need to change the name of a database.

Have a table and form setup at ABC company.

Need to change the name to XYZ company.

I can change the name of the table from ABC to XYZ but when I go to
forms I get an error 'The Microsoft Jet database engine cannot find the
input table or query 'ABC'. Make sure that it exists and that its name
is spelled correctly.

So where/how do I change ABC to XYZ so the database engine can find its
way?

thanks
 
Need to change the name of a database.

Have a table and form setup at ABC company.

Need to change the name to XYZ company.

I can change the name of the table from ABC to XYZ but when I go to
forms I get an error 'The Microsoft Jet database engine cannot find the
input table or query 'ABC'. Make sure that it exists and that its name
is spelled correctly.

So where/how do I change ABC to XYZ so the database engine can find its
way?

thanks
Click to expand...

Open the Form in Design View and either right-click on the little box at
the upper-left corner of the window, or choose menu item View-->Properties.

On the "Data" tab, change the "Data Source" field to XYZ. Close the
Properties window and the Form Design View window.

Better than "XYZ", however, would I think be a name (a noun phrase)
which concisely describes the contents of the table. Surely it doesn't
contain a collection of "XYZ Companies". If it contains product
information, for example, you might call it [Products].

For suggestions of table names, you might look at the Northwind
database, or try using the Access "Table Wizard".

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Need to change the name of a database.

Have a table and form setup at ABC company.

Need to change the name to XYZ company.

I can change the name of the table from ABC to XYZ but when I go to
forms I get an error 'The Microsoft Jet database engine cannot find the
input table or query 'ABC'. Make sure that it exists and that its name
is spelled correctly.

So where/how do I change ABC to XYZ so the database engine can find its
way?

thanks
Click to expand...

You're paying the penalty for a flawed database design. You should
NEVER EVER store data - such as the name of a company - in a tablename
(or for that matter in a fieldname). The name of the company should be
stored *as text, in a field in the table* - and you should use a Query
to select the company from that table, rather than using the table
name itself.

My guess is that you have the Form's Recordsource property still
referencing ABC. Open the Form in design view and change its
Recordsource. Or... better... correct your database design!

John W. Vinson[MVP]
 
Back
Top