Access DB Upgrade

  • Thread starter Thread starter leonaisse
  • Start date Start date
L

leonaisse

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 said:
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
Click to expand...

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.
 
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
 
and for the record

a) use Dreamweaver
b) FUK microsoft; they betrayed us all in 2002; it is time for a holy
war
 
"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?
 
Back
Top