MS Access, moved to new coputer, do not open & run

[Nemo]

Dear All,

in my office, the IT Dept. changed an old computer with a new one and
since then all the MS Access Databases do not open and run.

In these databases some tables are linked each other and I am in a
condition to have a lot of useless data.

How can I fix this problem?

TIA

 

[Jeff Boyce]

Nemo

Not nearly enough information ...

Which version of Access?

How many databases?

Where's the data?

Are the tables linked or "imported"?

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Nemo]

Il Mon, 14 Jun 2010 15:07:14 -0700, Jeff Boyce ha scritto:

Nemo

Not nearly enough information ...

Which version of Access?

How many databases?

Where's the data?

Are the tables linked or "imported"?

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

Hi Jeff,
thank you for your reply!

In our department we have Windows XP and Office 2003.
I have several MS Access Databases.

In these Databases some tables are stored inside and some others are
linked externally towards other MS Access DBs.

For instance, the Electric Motors Database have tables linked externally,
and NOT imported, to the another DB towards the Plants and Areas tables.


DBMotors
--------------------
tblElectricMotors
tblAlfa
tblBeta
tblGamma
=>tblPlants
=>tblAreas

When all these Dbs where stored in the old computer, they worked fine,
but when I got the new coputer I started to have trouble in opening the
Dbs.

It seem like *the path C:/Documets and Settings/xxx/xxxx/, is changed*
and I do not know how to use them.

Bear in mind, that in our Dept., we are Users and not Administrators, so
we have limited privilegies.

TIA for any answer.
Kind rgds,

 

[Jeff Boyce]

Nemo

If you have separate tables for each manufacturer, your database has more
issues that locating the data. Usually, embedding meaning (i.e.,
manufacturer name) as part of the tablename is an indication that your data
is not well-normalized.

Before you proceed, consider revisiting your data structure with
"relational" and "normalized" in mind.

Have you tried using the Linked Table Manager to re-link to tables?

Have you tried deleting Linked tables (!ONLY THE LINKED TABLES!) then
re-Linking? (make sure you make backups before you do any deleting)

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Nemo]

Il Tue, 15 Jun 2010 08:30:36 -0700, Jeff Boyce ha scritto:

Nemo

If you have separate tables for each manufacturer, your database has
more issues that locating the data. Usually, embedding meaning (i.e.,
manufacturer name) as part of the tablename is an indication that your
data is not well-normalized.

Before you proceed, consider revisiting your data structure with
"relational" and "normalized" in mind.

Have you tried using the Linked Table Manager to re-link to tables?

Have you tried deleting Linked tables (!ONLY THE LINKED TABLES!) then
re-Linking? (make sure you make backups before you do any deleting)

Regards

Jeff Boyce
Microsoft Access MVP

Hi Jeff,
Thank you for the time in answering me.
I'll take into consideration your experienced suggestions and tomorrow,
on work, I'll make some trials.

Thanks again and best wishes!

Nemo

 

[Nemo]

Il Tue, 15 Jun 2010 18:00:35 +0000, Nemo ha scritto:

Il Tue, 15 Jun 2010 08:30:36 -0700, Jeff Boyce ha scritto:



Hi Jeff,
Thank you for the time in answering me. I'll take into consideration
your experienced suggestions and tomorrow, on work, I'll make some
trials.

Thanks again and best wishes!

Nemo

Hi Jeff,

I followed your advices and I got my databases!!
I renamed the linked tables (=>old_tblPlants....) and then *re-linked the
tables ....and everything works fine!!!!

Thank you for your useful support.
Best wishes from Italy,
Nemo

 

[Jeff Boyce]

Glad to hear it worked!

.... and thanks for posting back how you used the information. Someone in
the future may be looking for an answer and find yours!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.