Database editor help please

[Paul Milner]

Can the database editor be used to update another
database. for eg.

I have two databases(I am not sure if it's a good idea
to have two databases) projectforsubmission where new
projects are submitted and a database called Projects.

After checking the project in projectforsubmission I
would like to be able to enter it into the projects
database
I have noticed that the database editor has an asp file
called update.asp what is this used for?
Is there any documentation on the use of the database
editor.
Best wishes
Paul M

 

[Clark]

One possible solution is to make an append query in your Projects
database. This append query will append the data in your incoming New
Projects database into your Projects database.

If you are using Access, just go to the Projects database query design
tool and design the query there, call it something like
AppendNewProjects, and save it. It's easiest if you have the New
Projects database and the Projects database in the same folder.on your
hard drive.

Then just double-click on the AppendNewProjects query and it will add
the information there to your Projects database. Then ftp the new
version of the database up to the site if that's where you keep it.

 

[Paul M]

Hi
Is there no way that it can be done live. with some kind
of button because it will be someone else doing the
inputing and it seems a bit complicated.
Paul M

 

[Clark]

Maybe I misunderstood. I thought you indicated that you wanted to check
the new projects first before adding them to the database.

*IF* that were the case, then I would put a form on the site for
project submitters to fill out, and when they submit the form, have it
write to the New Projects database.

Then periodically, you would ftp the New Projects database to your pc
(and then imediatedly ftp back an empty version of the New Projects
database to the site) and review the projects. Delete from the New
Projects database any projects you dont like, save it, and then open
ther Projects database and run the append query.

That updates your Projects database, which you can ftp back to the site.

Now, if you didnt really mean you wanted to review the projects, you
could let the form that people fill out write straight to the Projects
database.

 

[Andrew Murray]

you need to run the wizard twice, and use a separate set of pages for each DB.
unfortunately you can't choose through the web page interface like "Open File for
Editing" etc etc....each database interface wizard page is unique to the db that
it's connected to.