UNC Path issues - Beginner

[sybrix]

Hi All,

I have joined this company as System Admin, one of the problems that I come across is finding out they have an in-house Microsoft Access database that reside on the server. That was developed a few years ago by the external company. Now from my understand is that there a Back end and Front end database to it

My goal is to decommission this server and hosted onto another VM server with another name. When I moved the database to another server, the Windows 7 client access get denied due to the path is incorrect/ name not found.

I'm not a programmer nor a Access designer. Could anyone out there that can help me or guide to where to changed the path. Where to go, what files I need to open in-order to change the coding?

Please help...

Ps. I had looked at the search in this forum, but I'm very confused as it's does not make sense

Kind Regards,


Jack

[pbaldy]

You're looking for the Linked Table Manager. I don't have 2000 on this machine, but if I remember correctly it's in Tools/Database Utilities.

edit: that would be in the front end file by the way.

[sybrix]

Thanks for that, it's help.

What about a front-end FORM, the option tools --> Database Utilities is not there, seem to be very locked down. How to change it's.

[ssanfu]

Try holding the shift key down while opening the mdb.

And you are correct Paul - Tools/ Database Utilities/ Linked Table Manager

--------------------------------------------
Maybe the attached mdb example will help you. I have a form that opens hidden and checks if the BE tables are connected. If the BE was renamed or moved, the form "_See_BE_Links" opens and allows you to reselect a BE and relinks it. This form will also allow you to check the BE path anytime - just open the form.

USE A COPY OF YOUR FE THE FIRST TIME. Get familiar with it BEFORE adding it to your production (real) FE.

You will need to have a reference set to Microsoft DAO 3.6 Object Library
Import the form and the Module to your mdb (I did warn you about using a copy....right???)

[sybrix]

Try holding the shift key down while opening the mdb.

And you are correct Paul - Tools/ Database Utilities/ Linked Table Manager

--------------------------------------------
Maybe the attached mdb example will help you. I have a form that opens hidden and checks if the BE tables are connected. If the BE was renamed or moved, the form "_See_BE_Links" opens and allows you to reselect a BE and relinks it. This form will also allow you to check the BE path anytime - just open the form.

USE A COPY OF YOUR FE THE FIRST TIME. Get familiar with it BEFORE adding it to your production (real) FE.

You will need to have a reference set to Microsoft DAO 3.6 Object Library
Import the form and the Module to your mdb (I did warn you about using a copy....right???)

I downloaded the files and ran it, when I double click on the "Select Different BE" , I selected my BE access database file *.mdb. But nothing seem to show up. What do I supposed to see?

[sybrix]

Here is screenshot of what the FE - FORM look like

[pbaldy]

That's not 2000, looks like 2007. Did you try opening holding down the Shift key? Can you post it here?

[ssanfu]

That is NOT an Access 2000 form.

You IMPORTED the form and the MODULE from my example mdb into your dB?
You set a reference to Microsoft DAO 3.6 Object Library?
You opened the form "_See_BE_Links"?


IF you open your FE and look at the tables, you should see (some) linked tables.
There has to be tables already linked for this form to work.

[sybrix]

That's not 2000, looks like 2007. Did you try opening holding down the Shift key? Can you post it here?

I now installed MS office 2000. When trying again with Left shift key holding now until the database open, the result the same.

[sybrix]

That is NOT an Access 2000 form.

You IMPORTED the form and the MODULE from my example mdb into your dB?
You set a reference to Microsoft DAO 3.6 Object Library?
You opened the form "_See_BE_Links"?


IF you open your FE and look at the tables, you should see (some) linked tables.
There has to be tables already linked for this form to work.

Sorry for my ignorance as I am not a programmer, my main duties as system admin. So I do not understand 95% of your request. Could you steps me through what I need to do, please.

[pbaldy]

Looks like the shift bypass has been disabled. My buddy Bill has a free tool here that will let you reset that feature, the property setter:

http://www.thatlldoit.com/Pages/utilsaddins.aspx

[sybrix]

Thanks you for all your kind effort and support. Such a great forum !!!

Follow on after installing MS Access 2000, holding down the left hand side shift key until the database FE form open, I went to Tools --> Startup... the following options has been ticked
- Allow full menus
- Allow default short menus
- Allow built-in toolbars
Allow toolbar/menu changes

After that click OK --> Close down the program and re-open it. To change the UNC path
I went to Tools --> Database ultilities --> Linked table manager, and I was able to change the UNC path

To lock down the form and other menu/features revert the untick box from the above steps.

Thank you once again....

[pbaldy]

Glad you got it sorted out.