Form on Intranet

[Madhup Thakur]

Win XPSP2 Access XP.
I have been using access for 6-8 Months.
I wish to post a "FORM" on Companies Intranet server where employees enter
certain details and then I can fetch/update it to my database "TABLE" on my
workstation in real time/offline. I am not an expert so please do not be too
short and cryptic. Thank you very much for trouble.

Madhup Thakur

 

[Douglas J. Steele]

It's not possible using Access.

 

[Madhup Thakur]

Thanks for the reply
M.

It's not possible using Access.

 

[Arvin Meyer [MVP]]

What you can do is to create an asp or asp.net form which writes to the
Access (JET) database. If all the employees are at 1 location, you can split
the database and put the data on the server, and a front-end on each
workstation. And if there aren't too many users in different locations, you
can use a Terminal Server or other thin client such as Citrix or WinConnect.

 

[Madhup Thakur]

What you can do is to create an asp or asp.net form which writes to the
Access (JET) database. If all the employees are at 1 location, you can
split the database and put the data on the server, and a front-end on each
workstation. And if there aren't too many users in different locations,
you

Thank you for your time. Could you please expand on "asp or asp.net form
which writes to the Access (JET) database" bit. If I could get the hang of
it then I could get back to you people if the thread is still available. The
employees are all in one location, but in different offices, connected to
the intranet by high speed LAN.
M.

 

[Arvin Meyer [MVP]]

Use the LAN. A rich client is much better than any web browser application
ever dreamed of. You will be able to do much more data validation, work
orders of magnitude faster, and build you application in 1/3 to 1/10 the
time. If everyone in your company doesn't have Access, you can build a
runtime distribution at a fraction of the cost of a web application.

Web browsers for applications are basically only good for WAN applications
where the number of users exceed that ability of a Terminal Server. It
should be the last choice of any database application strategy.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Madhup Thakur]

OK. Thanks once again. You have been helpful indeed
Regards.
M.