Create ACCDE for network on a computer not on network.

alfranco17

Board Regular
Joined
Apr 14, 2013
Messages
197
Hi.

I created an Access database at home and took the ACCDE to work. I used SUBST to map my local path to the z: drive I use at work, and everything worked fine (the database is split between front and back-end). Any time I needed a new query or form, I would do it at home, change the front-end, create the ACCDE and email it to myself so I would get the changes right away, and then distribute it by email to the other 5 people who use it.

Recently, IT changed the path: instead of Z:\USERS\DATABASE now it has to be \\SHARED\USERS\DATABASE.

I can't find a way to solve this, and as I have been working so far, the database will not work.

A temporary solution was to place the database in my computer (at work), in a shared directory, and map that directory to the old path. However, this requires my computer to be always turned on and on the network for everybody who uses the database.

Any tips on how to solve this will be very appreciated. In summary:
a) Don't have access at work, where I use the database..
b) Don't have network at home, where I create the ACCDE file for the front end.
c) The path begins \\shared instead of z:.

Happy New Year!
Armando.
 
Last edited:

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

xenou

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,836
Office Version
  1. 2019
Platform
  1. Windows
Hi,
This is an odd question. The answer surely is to simply map \\SHARED\USERS\DATABASE to Z:\USERS\DATABASE Can you not just do that? I.e., since you can map *a* Z: drive, why not just map the right one? It's not really clear what it is that IT is saying to you here, but it's not adding up.

Otherwise, Boyd has some tips and links to various "table managers" at his site:
How to Manage Your Linked Tables

Possibly you can even just use the Linked Table Manager that you already have for you in Access.
 

alfranco17

Board Regular
Joined
Apr 14, 2013
Messages
197
Hi,
This is an odd question. The answer surely is to simply map \\SHARED\USERS\DATABASE to Z:\USERS\DATABASE Can you not just do that? I.e., since you can map *a* Z: drive, why not just map the right one? It's not really clear what it is that IT is saying to you here, but it's not adding up.

Otherwise, Boyd has some tips and links to various "table managers" at his site:
How to Manage Your Linked Tables

Possibly you can even just use the Linked Table Manager that you already have for you in Access.

Thanks, that was quick!

I tried and it did not work for some reason, which might be that I made a mistake. :) I 'll try tomorrow and let you know of the result. The link is great!
 

Forum statistics

Threads
1,137,300
Messages
5,680,699
Members
419,928
Latest member
dolincasting

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top