Cannot open *.mdb on new computer??

[deednets]

I want to transfer and old database used currently for quotes etc to a new computer. I transfered all files, but when I want to open the file an error message comes up referring to the old location on a small office network. How can I import, that is use the files on new computers??

Thanks! You help is greatly appreciated!
Deed, Auckland, NZ

 

[Moniker]

The DB has links in it to tables/queries still on the old computer. Update the links. Hold shift down when opening the DB to prevent anything trying to relink these. It sounds like there's a form automatically opening, and it's trying to use linked tables. Holding down shift will prevent that form from opening.

 

[deednets]

Tried that but nothing at all opens now. There are 2 mdb files in original folder, one I can open but has nothing to do with the second one (e.g. customers, products etc) the second one is called "quotes" and if I try to open this file, there is a message: \\server\data\tables.mdb is not a valid path. Make sure ...

When I click ok, I don't have access to "Linked Table manager" ??

When I press shift, nothing happens at all ... the file I am trying to open is calles quotes.mdb

Thanks!

The DB has links in it to tables/queries still on the old computer. Update the links. Hold shift down when opening the DB to prevent anything trying to relink these. It sounds like there's a form automatically opening, and it's trying to use linked tables. Holding down shift will prevent that form from opening.

 

[deednets]

found a file called quotes.ldb ??? the type is access lock file ?? Am pussled, you you know what this means??

Thanks!

 

[Moniker]

An LDB file opens with the MDB file. It should be created and destroyed each time you open/close the main DB file. If the quotes.mdb file is not open but there's still an ldb file there, delete the LDB file. (Backup your stuff before doing this.)

When you hold shift down while opening, you shouldn't get any messages, but you should have all your tables there (including the linked tables). Right clicking on a linked table should make the Linked Table Manager option visible (the last option in the menu). That's what you need to get to.

 

[boblarson]

You need to relink to the tables in the new location. See these screenshots to see how you can set the UNC path to the backend tables from the front end where you are linking from.

First, open the Linked Table Manager (Tools > Database Utilities > Linked Table Manager)

 

[Bob Miller]

If you don't see the db window when opening with the shift key, hit F11.