What do you mean by "secure"? When that term is used in conjuction
with Access, the word "oxymoron" usually follows :-) First of all, the
DSNs are not secure, and if you are saving the linked tables between
sessions, neither are they because Access caches schema and connection
information locally. The recommend course of action is to write code
that links the tables dynamically for each session, passing the
connection string information directly, not using DSN's. then delete
the tabledef objects when the app shuts down (and also when it starts
up prior to relinking). Even when you do that, the data is still not
encrypted, but at least it's a start.

--Mary