Hi

I have an existing Access DB that consists of tables, forms, queries and
reports. I need to get it online and into SQL server, what is the quickest
and best way to do this? Is there a magical export procedure to turn the
forms into webpages with the data driving it and also export the reports and
queries? or do i need to upsize the data and build the forms and reports by
again online?

Thanks for your help

L

leonaisse wrote:
> Hi
>
> I have an existing Access DB that consists of tables, forms, queries and
> reports. I need to get it online and into SQL server, what is the quickest
> and best way to do this? Is there a magical export procedure to turn the
> forms into webpages with the data driving it and also export the reports and
> queries? or do i need to upsize the data and build the forms and reports by
> again online?
>
> Thanks for your help
>
> L
>

You can't convert the forms into web pages automatically, as a web page
works differently than an application form. A web page is a
client-server application where the communication is performed by the
client requesting a new page from the server, while an application form
is just a client application communicating directly with the data layer.

The tables can quite easily be imported into the database, and the
queries can be turned into stored procedures, but the forms and resports
has to go somewhere else, as a database is not a tool to create a user
interface.

--
Göran Andersson
_____
http://www.guffa.com

moving to dotnot is _NOT_ an upgrade

dotnot does not run anywhere; go elsewhere please




On Feb 8, 12:05 pm, "leonaisse" <leonru...@hotmail.com> wrote:
> Hi
>
> I have an existing Access DB that consists of tables, forms, queries and
> reports. I need to get it online and into SQL server, what is the quickest
> and best way to do this? Is there a magical export procedure to turn the
> forms into webpages with the data driving it and also export the reports and
> queries? or do i need to upsize the data and build the forms and reports by
> again online?
>
> Thanks for your help
>
> L

yeah it sure would have been nice is MS did something practical like
this for us.. but no; they PROMISED this functionality with the
release of Office 2007

but that feature is called 'vaporware'-- nowhere to be seen





On Feb 8, 12:05 pm, "leonaisse" <leonru...@hotmail.com> wrote:
> Hi
>
> I have an existing Access DB that consists of tables, forms, queries and
> reports. I need to get it online and into SQL server, what is the quickest
> and best way to do this? Is there a magical export procedure to turn the
> forms into webpages with the data driving it and also export the reports and
> queries? or do i need to upsize the data and build the forms and reports by
> again online?
>
> Thanks for your help
>
> L

and for the record

a) use Dreamweaver
b) FUK microsoft; they betrayed us all in 2002; it is time for a holy
war





On Feb 8, 12:05 pm, "leonaisse" <leonru...@hotmail.com> wrote:
> Hi
>
> I have an existing Access DB that consists of tables, forms, queries and
> reports. I need to get it online and into SQL server, what is the quickest
> and best way to do this? Is there a magical export procedure to turn the
> forms into webpages with the data driving it and also export the reports and
> queries? or do i need to upsize the data and build the forms and reports by
> again online?
>
> Thanks for your help
>
> L

"The tables can quite easily be imported into the database, and the
queries can be turned into stored procedures..."

Would you mind telling a newbe what this process would be?
--
Terry


"Göran Andersson" wrote:

> leonaisse wrote:
> > Hi
> >
> > I have an existing Access DB that consists of tables, forms, queries and
> > reports. I need to get it online and into SQL server, what is the quickest
> > and best way to do this? Is there a magical export procedure to turn the
> > forms into webpages with the data driving it and also export the reports and
> > queries? or do i need to upsize the data and build the forms and reports by
> > again online?
> >
> > Thanks for your help
> >
> > L
> >
>
> You can't convert the forms into web pages automatically, as a web page
> works differently than an application form. A web page is a
> client-server application where the communication is performed by the
> client requesting a new page from the server, while an application form
> is just a client application communicating directly with the data layer.
>
> The tables can quite easily be imported into the database, and the
> queries can be turned into stored procedures, but the forms and resports
> has to go somewhere else, as a database is not a tool to create a user
> interface.
>
> --
> Göran Andersson
> _____
> http://www.guffa.com
>