"Do you want FP to create a db connection for this db" ??

T

tmb

- have a mdb on server
- have the mdb in My Webs on my compute marked "Do not update" so it won't
over write the mdb on the server... which is an ecommerce db.
- used ftp client to download mdb from server & compact
- used FrontPage 2003 to 'import' it back to the folder in My Webs
- Wanted to then remove "do not update' so I could get the compacted version
back on the server

But FP2003 first reminds me the file I'm importing is about to replace an
existing file with the same name... I say OK

THEN It ask me if I want it to create a db connection for the data base...

Well, all that stuff is in the commercial ASP code I already have on the
server...

I said NO to front page and it then put a red x on the mdb file ???

Have I broke it? If so, how can I fix it?

thanks for any info.
 
K

Kevin Spencer

All you need to do is double-click it in FrontPage to export and open it in
Access locally. When you close Access, the file will be re-imported back to
the remote web site. By using FTP to download, and then importing, you
fooled FrontPage into thinking you were adding a NEW database.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Neither a follower
nor a lender be.
 
T

tmb

Kevin,

1 - How can I un-fool it?

Now the mdb file has a red x on it when I see it in My Webs using Front
Page.

I just want to get back to where I was.

2 - What does FP do if I tell it to create a new db connection? Does it
create code?

3 - What if that db connection code has already been created as in an off
the shelf shopping cart package?

thanks - tmb
 
T

Thomas A. Rowe

Downloading the database: Open the live site in FP on the remote server, select the database, and
export to your desktop and do whatever is needed.

Uploading the database, Open the live site in FP and import the database.

NOTE: However import or upload the database to a live site with active visitor will overwrite any
new update made to the database while you working on the local copy. However it is not a good idea
to open the database via FP on the live site, as this can corrupt the database, and you will loose
everything. You really need to be able to stop or disable any pages that update the database, before
working on it.



--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
K

Kevin Spencer

1 - How can I un-fool it?

You probably don't need to do anything.
2 - What does FP do if I tell it to create a new db connection? Does it
create code?
Click to expand...

Yes. It creates a global.asa file that contains the Connection String, or
adds it to the existing global.asa file. It really shouldn't affect anything
if you don't use it (the Connection).
3 - What if that db connection code has already been created as in an off
the shelf shopping cart package?
Click to expand...

Shouldn't affect it.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Neither a follower
nor a lender be.
 
Top