Create Database from webpage

C

Chris

Hello

I was wondering if there is a way that I can create an Access Database (*.mdb) from a webpage? Im thinking like clicking a button and then a new access database is created that can be used as a normal DB. Can this be done

Thanks
 
T

Thomas A. Rowe

Only if the page is a form, then under Form Properties, you can FP create a database based on the
fields in the form.

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

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


Chris said:
Hello,

I was wondering if there is a way that I can create an Access Database (*.mdb) from a webpage? Im
thinking like clicking a button and then a new access database is created that can be used as a
normal DB. Can this be done?
 
C

Chris

Hello

What I was meaning, is If I am at another computer, filling out a form, if I have the form created right, can I create a Database form that remote computer? Is it possible to do that if I have the programming right

Thanks
 
T

Thomas A. Rowe

Not sure I understand.

If you have full access to the site via FP, then you can create a database from a form.

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

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


Chris said:
Hello,

What I was meaning, is If I am at another computer, filling out a form, if I have the form created
right, can I create a Database form that remote computer? Is it possible to do that if I have the
programming right?
 
C

Chris

If I was to create a Form usinf FP, what is the code or how do I create a form that can, without using FP, how can I get it that the Form itself, create a new Database. I want it to create a whole new .mdb file that it can use

I hope that clears the fo

Thanks
----- Thomas A. Rowe wrote: ----

Not sure I understand

If you have full access to the site via FP, then you can create a database from a form

--
=============================================
Thomas A. Rowe (Microsoft MVP - FrontPage
WEBMASTER Resources(tm
http://www.ycoln-resources.co
FrontPage Resources, WebCircle, MS KB Quick Links, etc
=============================================
To assist you in getting the best answers for FrontPage support see
http://www.net-sites.com/sitebuilder/newsgroups.as

Chris said:
right, can I create a Database form that remote computer? Is it possible to do that if I have th
programming right
 
T

Thomas A. Rowe

If you don't use FP, then you will have to manually create the database directly in Access.

If you create the form in FP, then you would right click in the form, form properties, and select
send to database...

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

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


Chris said:
If I was to create a Form usinf FP, what is the code or how do I create a form that can,
without using FP, how can I get it that the Form itself, create a new Database. I want it to create
a whole new .mdb file that it can use.
 
C

Chris

So, what you are saying is that I cannot have a form manualy create a database. That is my question, can I make a form that can manualy create a database? (without using Fp or access, but use the browser and the server to automatically create it

----- Thomas A. Rowe wrote: ----

If you don't use FP, then you will have to manually create the database directly in Access

If you create the form in FP, then you would right click in the form, form properties, and selec
send to database..

--
=============================================
Thomas A. Rowe (Microsoft MVP - FrontPage
WEBMASTER Resources(tm
http://www.ycoln-resources.co
FrontPage Resources, WebCircle, MS KB Quick Links, etc
=============================================
To assist you in getting the best answers for FrontPage support see
http://www.net-sites.com/sitebuilder/newsgroups.as

without using FP, how can I get it that the Form itself, create a new Database. I want it to creat
a whole new .mdb file that it can use
 
T

Thomas A. Rowe

Correct.

Browsers can't create files, they only request files from a web server.

Files can be created automatically with the proper scripts and/or components installed on the
server.

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

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


Chris said:
So, what you are saying is that I cannot have a form manualy create a database. That is my
question, can I make a form that can manualy create a database? (without using Fp or access, but use
the browser and the server to automatically create it)
 
J

John Jansen \(MSFT\)

Ack. I'm sorry but I have to jump in.

Create a new page in FrontPage
Insert > Form > Textbox
Right click this form and choose Form Properties
Put a bullet in "Send to Database"
Click "Options"
Click "Create Database"
After your done in here, save the page as foo.asp (this page will need to be
running on a server running ASP)
Browse to this page in IE and as you submit information through the text
field, that data will be added to your database.

This does not create a database from the browser, it creates one when you
create the form, but based on the back and forth here, I believe this is
what you want to do. If not, sorry for jumping in.
 
S

Stephen Travis

Neither of these is for the novice;

If you're using IIS and have MS-Access installed on your web server, you may be able to use MS-Access Automation to create a
database.
(http://support.microsoft.com/defaul...port/kb/articles/q147/8/16.asp&NoWebContent=1)
I've never tried this but it's possible in theory.

You could also create and empty database file on the server and use ASP to create a copy of it and then use SQL to create your
tables.

--

Stephen Travis,
Microsoft MVP - FrontPage

Chris said:
So, what you are saying is that I cannot have a form manualy create a database. That is my question, can I make a form that
can manualy create a database? (without using Fp or access, but use the browser and the server to automatically create it)
 
Top