I have a website with two independant databases with one table in each:- residential and commercial. These 2 databases store details on residential and commercial properties. I thought that rather than having 1 database with 2 tables, it would be better to have 2 databases with 1 table in each for maintenance purposes.

Users search these databases to find suitable properties matching their search criteria.

Customers have been advertising their property through either the residential or commercial submit form, which adds their property details to the correct database.

Problem:

Now I want to add a 3rd database to store customers (people who add properties to the databases) details. They will have a sort of members section where they can do various things, such as view properties which they have submitted, and add new properties.

I have added a CustomerID field to both the residential and commercial databases which I would like to link to the CustomerID in the Customers database.

However, using the DRW, I can include as many tables as I want in the query, but only within the one database. Is there a way to create a database connection in FrontPage which will include 2 databases?

I'd thought about linking tables, but don't know how well that will work, considering that the site is hosted by an ISP which I have no control over.

Are there any smart folk out there that can guide me in the right direction? I have spent a great deal of time on my site, and the thought of having to merge the 3 databases into the 1 with 3 tables makes me want to cry.

Thanks,

Mark.

Importing is REAL easy, so dont worry about it.

Just open one database, select file > get external data > import

Now just select the table you need. Viola!

As Access is file based, you cant link tables on the host, so use one where possible.

------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!

I know that getting the table from 1 database to the other is easy enough. What upsets me is that I have about 20 asp pages linking and custom querying the databases.

I guess, planning it properly from the start would have been better.

Thanks again,

Mark.

At the moment you have 3 connections (minimum)

Rename each DATABASE to the single database name you will use

------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!