This is a multi-part message in MIME format.



------_=_NextPart_001_01C1A026.26678A71

Content-Type: text/plain;

	charset="us-ascii"

Content-Transfer-Encoding: quoted-printable



Internet versus Intranet

I have a production access database on a website (lets say 5 tables are

included on this one).  I also have an separate and different access

database on my local domain network (8 different tables).  2

questions...

1....Is there a way of taking one table from the local network and

importing it to the website mdb?

2...Later once the table is built on the website, I would like to

monthly just delete and re-insert the 250 records from my local pc to

the website

MessageHi!



You could build a web page that uses Office Automation to read the local

database using an installed OCX on the browser. It could then populate

fields in a form, and submit itself to another page on your server that

would apply the "updates" to the server's database. (i.e. step 1, delete

existing records, Step 2, iterate through the supplied form values,

inserting them into the server's database.)



Sloan





"Drew, Ron" <RDrew@B...> wrote in message news:137327@a..._databases...

Internet versus Intranet

I have a production access database on a website (lets say 5 tables are

included on this one).  I also have an separate and different access

database on my local domain network (8 different tables).  2 questions...

1....Is there a way of taking one table from the local network and importing

it to the website mdb?

2...Later once the table is built on the website, I would like to monthly

just delete and re-insert the 250 records from my local pc to the website