Another Access Question

[will07]

Hi Everyone,

Is it possible to place the front end (forms) of an Access Databse on a web
page, so that users can log on via the net and enter data into the forms. I
am guessing that the front end would have to stand alone but not sure !

Any advice would be great

Thanks

 

[Tony Toews [MVP]]

Is it possible to place the front end (forms) of an Access Databse on a web
page, so that users can log on via the net and enter data into the forms. I
am guessing that the front end would have to stand alone but not sure !

Can't be done using Access unless you went with a Terminal Server
solution.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[will07]

Thanks Tony, this however opens up a whole new set of problems. maybe
another type of database is the solution.

 

[Tony Toews [MVP]]

Thanks Tony, this however opens up a whole new set of problems. maybe
another type of database is the solution.

Likely but what you want to do is make the app available to users on
the web. So you need to choose a web based system to do that. (Or use
Terminal Server.) Said app will take you a lot longer to develop in
C#, VB.Net, etc, etc. than in would in Access.

In which case you probably want to use SQL Server to store the data as
it doesn't do well with any kind of update/insert load on a web
server. Access does quite well if you're doing a lot of reads
though.

What you also might want to consider is how much of your app needs to
go onto the web. If only a small part then consider putting only
those forms on the web and leave the rest of your app in Access all
hitting the same SQL Server backend.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/