Access2003

[Shakeel Ahmad]

I am using Access2003. I have a network of about 150 computers attached
through LAN.

Now I have a database about the record of all the clinets of this network.
i.e.

Their IPs
Computer Names
Monthly (Fee paid or not yet for the current month)
and some other information.

I want to use this database with my web site.. this web site will work only
on this NETWORK... I mean i want to use my computer as web server.

Is it possible through windows xp's default IIS or i will have to install a
new server and i will i attach this database through webpages....?

Please help...

Shakeel Ahmad.

 

[Daniel]

Sadly, access does not port itself to be a web database. You can check
numerous previous posts on this site discussing exactly this. You would need
to look at web databases for this type of setup such as MySQL or ORACLE
Express.

 

[Jobob]

You could use IIS in conjunction with FrontPage

 

[Larry Linson]

Sadly, access does not port itself to be a web database.
You can check numerous previous posts on this site
discussing exactly this. You would need to look at web
databases for this type of setup such as MySQL or ORACLE
Express.

Generally, when people ask about Access databases on the Web, they are not
making a distinction between Access (the user interface and application
development software) and the Jet database engine (which is distributed with
Access and installed by default). This response is partly true, partly
false, but somewhat misleading.

The Access user interface (forms, reports, macros, modules, and queries)
can, indeed, not be automatically converted to a web application. However,
the Jet database (tables, data, and relationships) itself can, indeed, be
used in a Web application, provided the server runs Windows. That Jet
database can be accessed via Front Page with the Database Interaction
Wizard, some third-party applications, or Microsoft's ActiveX Server Pages
(.asp), or ASP.NET.

With some strict limitations, Access versions from 2000 - 2003 can generate
Data Access Pages for this purpose, but they are primarily useful on
intranets in an environment where all users' software configuration is
controlled.

Neither MySQL nor Oracle Express is, in fact, a "web database," so that
statement is also misleading. Also, neither MySQL nor Oracle Express has an
application development facility comparable to Access, so the "web front
end" would still have to be developed using one of the approaches I
described earlier.

Larry Linson
Microsoft Access MVP

 

[Daniel]

A very valid precision!

Daniel P

Generally, when people ask about Access databases on the Web, they are not
making a distinction between Access (the user interface and application
development software) and the Jet database engine (which is distributed with
Access and installed by default). This response is partly true, partly
false, but somewhat misleading.

The Access user interface (forms, reports, macros, modules, and queries)
can, indeed, not be automatically converted to a web application. However,
the Jet database (tables, data, and relationships) itself can, indeed, be
used in a Web application, provided the server runs Windows. That Jet
database can be accessed via Front Page with the Database Interaction
Wizard, some third-party applications, or Microsoft's ActiveX Server Pages
(.asp), or ASP.NET.

With some strict limitations, Access versions from 2000 - 2003 can generate
Data Access Pages for this purpose, but they are primarily useful on
intranets in an environment where all users' software configuration is
controlled.

Neither MySQL nor Oracle Express is, in fact, a "web database," so that
statement is also misleading. Also, neither MySQL nor Oracle Express has an
application development facility comparable to Access, so the "web front
end" would still have to be developed using one of the approaches I
described earlier.

Larry Linson
Microsoft Access MVP