When I import from a file I am having trouble with the passord window popping up and having to enter the password as I import a file.

I have a file "multiple tables", I have a script that will import a file into my file. As it imports and then changes to another table it will ask for the user name and password.

Is there a way to get the file to import the file and not have the username and password dialog popping up on each table change.

The file is FM 7 and I have users in the file. I will put the username and password in at the launch of the file.

And it will ask me each time I import to a new table.

Thanks in advance

If the file is first opened, it will not ask for the password again when you try to import from it. But this can easily change the found set that gets imported since importing from a closed file will import all records, whereas importing from an open file (with only one window) will import the current found set(s)). To solve this, you should have a subscript in the source file setup each found set in each source table before attempting to import from it.

Are you saying that I need a script to open the file I am importing from and then have a script to set the found set and then import each table. That should allow the file to import and not ask for the user and password.