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 DB 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 finding ways to change the IP address directly without using the
linked table manager. Or any other way.

Please advise.

Thanks.