I am back at it with the security seminar. I have found a couple of solutions to my problem, but am intent on finding the cause.

I am kind of re-engineering the security seminar and it is a great learning experience. I have the log in form which uses login as an independent id (almost like a second password.) So they type in the UserName field and it opens the RS as in the seminar. It returns a Username which then gets plugged into the username field.

It repeats with the password and SQL as in the seminar, then if all is good; will import the tables.

Problem: for some reason, Access will not pass the password from global const to the backend db when importing the tables, so it prompts for the password. Particularly curious because it works beautifully on the previous parts. The only difference I can find is that on import, there are 2 DB/RS open. I have tried closing the first before the CreateDatabaseLinks call, but that doesnt help either. However, I can msgbox the Global Const and it returns it just fine.

Now I think the problem may have something to do with multiple recordsets running. I have tried to use differing variables, but that doesnt seem to help.

I have tried a couple of avenues with no luck. Can 2 recordsets run at the same time, and if so are there any special considerations? Finally, what does that have to do with a global constant (which is still there, I can return it to a message box anywhere I have tried?

As always, thank you for the help.

---

Reply from Richard Rost:

Generally you shouldn't have any problems running 2 recordsets at once... I do it all the time with input/output pairs (reading from one table to write in another). Just make sure none of your variables overlap. Can you HARDCODE the password into your connect string instead of sending it via a variable? That would at least get you one step closer to figuring out where the problem is.