In the database I have, its split into front end screens and reports and
backend tables for data. Of course, this means the linked tables are
linked using the linked table wizard to the network drive mapping the server
is on.
since this database will be used by multiple people, it then means that each
user must have the same drive mapped to the same drive letter. The linked
table manager doesn't recognize UNC encoding.
The problem we run into is having so many shares available to various users
that we are running out of letters and getting everyone to use one drive is
difficult. To help that problem (and WAN traffic delays) we've opted to
run the database on a citrix server so users in multiple sites can access
the database. Once again, because of the linked tables we cannot publish
the mde file to the users desktop and instead we have to make the users log
into the citrix desktop then run the program.
I'm trying to find a "Better way". Any insight would be appreciated.