Hi,
I have a MS Access db MDE which is linked to some SQL tables on a server.
Now in my company we are using a certain IP address.
The same MDE is given to external company to use, but they have a different
IP address, due to firewall restrictions. So in order for the external
company to use the table, they would need to create the DSN and re-link the
tables. But I do not want them to do that, because then they can direclty
access the table. On the other hand, I cannot re-link the table using their
IP address, again due to fire wall restrictions.
Now I am looking for ways to change the IP address directly without using
the
linked table manager? E.g. is there somewhere a property setting, where I
can change the IP address the table is located, without using linked table
manager?
Please advise.
Thanks.