This is great. Thank you!

Thanks, I thought it was available for 2005 which is the version I'm working with. Is there something equivalent in 2005?

Thank you. It makes perfect sense now.

The MERGE statement that I came across seems to be quite useful. I tried to play around with it but came across...

I was thinking of adding an extra layer of security. When the front-end is initiallly loaded, then prompt for the password, but not every time that a linked table...

Thanks for the reply. I tried your suggestion, but it didn't work.

I did some more tests and discovered this:

- If I link using the "SQL Server" driver, timeout error...

I narrowed the problem to timeout issues. I can't open the linked table on the first try, but if I immediately try opening the table a second time, I...

Sorry for the late reply. I'm currently working on 3 projects and had to delay this one.

Now I have tried 1) adding the user to local Windows group, 2)...

Yes, I am able to connect from remote using my account. Surface Area Config is set up for remote and local connection. I am using the Enterprise edition....