Importing Records into runtime

[drags]

Hello everyone!

I have been reading various topics on this forum but I can't seem to find the solution I'm looking for, so I'm hoping someone can help.

I have a runtime solution the opens with a certain password that does not allow importing and exporting of records, lets call this db1. It has over 124,000 records in it. I would like to have the users download an update called db2 which may have only 1800 new records that need to be imported into db1.

What I would like to happen is the user opens db2, clicks a button that runs a script that opens db1 (with a password that allows importing and exporting) then runs an external script within db1 to import the new records. I want to do this automatically because I don't want the user to mess it up by not matching the correct fields.

The tests I have tried are not working because db2 always has to be the same name because the script in db1 is looking for a certain file. Is there any way to from db2 "Export Records Into" a certain solution. This would be the most direct approach. The other problem I'm having is that I can't seem to open db1 from db2 with a special password.

I may be going about this the wrong way, how does anyone update runtime solutions?

Thank you

Kevin

[Kurt Knippel]

Here is the basic setup.

DB2 opens with password that allows DB1 to import/export. DB2 exports its records to a file that DB1 is looking for. DB2 closes DB1, then runs a script in DB1 (thus opening it with the proper password) which imports the records.

[drags]

Thank You Kurt

I try that now

Kevin

[drags]

I can't get it to work in Runtime.

When I run db2 as a filemaker file everything works fine, but when I try to run it as a Runtime Solution I get the following error:

"Update-1.fp5" could not be created on this disk. Use a different name, make more room on the disk, remove the write-protection or use a different disk.

Anybody have any clue as to why this is happening?

Thank you

Kevin

I'm using Developer 5.5 on Win98 SE

[Kurt Knippel]

Installing from a CD?

[drags]

No, I'm just testing this on my C drive.

What am I missing?

Thanks Kevin