Create ACCDE for network on a computer not on network.

[alfranco17]

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.

 

[xenou]

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]

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!