Problems editing mdb

[Abbos]

Evening all,

I used to program access db's many years ago but it seems that I have forgotten my stuff and need some help.

I have 2 mdb's. One labelled client and one labelled server. They have been copied from an old workgroup network onto a new domain environment, but the problem was the plonker that moved the data did not think about the impact of the database.

Problem I have is when I open the client mdb now, I get the front form but none of the buttons work because it is looking for a network path for the server.mdb which doesn't exist. To add to this I don't know how I can edit the client mdb with the new network path as it removes the bar at the top so that I can't switch into desgin view etc.

Can anyone help?

Thanks in advance,
Abbos

 

[KenHigg]

If you go to Tools->Database Utilities->Linked Tables Manager, you should be able to re-establish these connections.

???

(Welcome to the forum!)

 

[Abbos]

Hi Ken,

Thanks for the quick reply.

Problem is, it removes Tools from the menu!

 

[KenHigg]

Have you tried holding down the shift key as it opens?

 

[Abbos]

Thanks Ken!

Is there an easy way of me finding all references to the old network part within the forms, reports etc?

 

[KenHigg]

Usually, after you go through the trouble of doing one table with the Linked Table Manager, if all the other tables are in the same .mdb, it'll relink the rest of the tables automatically...

 

[Abbos]

Thought so, but I was hoping I was wrong as it I hadn't installed that feature and the MS office cd is at my sisters, darn it.

Will try tomorrow.

Thanks for all you help.

 

[KenHigg]

If you're sure all the tables are in the server.mdb, I would just delete them in the client and do File->Get external data->Link tables. Takes two seconds.

Would this work?

 

[Abbos]

I'm not sure if all the tables are in the server.mdb. I wasn't involved in the design or putting together of the db. It's just that the company that did do it for my employer is now not around and unfortunately someone caught wind that I did do some Access stuff so I got roped into it.

I know that the two DB's are linked somehow becuase when I open the client.mdb, it opens, but when I click on any of the buttons on the form it just throws back an error to say it cannot find \\oldservername\server.mdb

I need to find these links and update them!

Oh well, see what happens I suppose.

Thanks again.