Data base web design

A

Albert D. Kallal

Jeff said:
Can I use Access 2007 as database for my web site as I use MySQL
Click to expand...

I think you're confusing the term database, and MS access.

MS access is a tool that lets you build an application, and that application
can connect to a database engine such as JET, or MySql.

so it's not the MS access side that has anything to do with a web based
system, it is the database engine you choose to use with MS access.

if you're asking can you use MS access on a website? ... no you can not, and
they they have nothing to do with each other.

However if you're asking can use the same database engine that we use in MS
access for web site, the answers most certainly yes.

in other words a good number of providers do accept and allow you to use an
access database or so called mdb database file on your website, and your web
site can connect to that data. However keep in mind this is exactly the same
thing when you use MySql, and that means you're talking about connecting to
a data store, and that has nothing to do with reports, forms, writing code
etc. So keep in mind that a access database, or my SQL database does NOT
allow you to build the user interface such as forms etc. MySql, or a "jet"
based ms-access database does not the week why are you to install MS access,
or even use MS access to grab the data.

In fact each windows computer actually ships with the jet based database
engine, and you don't even really need to install MS access, and the same
goes when using access database on a website --> you do not have to install
MS access on the target machine , but simply ensure that it has the jet
database engine installed.

Since when you use the jet database side, or the MS access database, there's
really little advantage to using MS access over SQL server, or my SQL
because you're not use or building software with the interface part of MS
access. it is the rich forms ability and report parading ability is why most
of us developers use an asset to us, and that has no relationship to using
just the database engine itself.

So the answer's most certainly yes you can use an MS access database for
your web site, but the database really has nothing to do with MS access the
development tool itself, and you'll not be using the rich development tools
of MS access to build forms etc.
 
J

Jeff

Thank you for your answer,
So what is microsoft solution to build forms and report for web site
designers?
is "Share Point Designer 2007" can do the job?

Jeff
 
A

Albert D. Kallal

The ".net" tools, and specifically asp.net is a good starting point.....

Share point is a pre-built solution in which you can share documents, and
collaborate work flow type environments.
 
Top