I need to know if there is some code that automatically link the table from SQL server Desktop Version. I am using FE as Access MDB.

I know the method of linking tables (dbo_tbl) which stays in db even it closes. I want to establish connection / re-link tables ONLY when db open so that db will not be heavy.

One more thing when I installed SQL Server Desktop Version, I had seleted windows authentication mode. So there is no restrictions in opening db direct from start up.

I want to know how can I set password to the db I created on server and re-link tbls with above fashion? Do anybody of you have code?

With kind regards,
Ashfaque