 |
| Access VBA Discuss using VBA for Access programming. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
February 12th, 2009, 05:29 AM
|
|
Friend of Wrox
|
|
Join Date: Apr 2007
Posts: 110
Thanks: 1
Thanked 2 Times in 2 Posts
|
|
Make Access Front End Web based
Hi
I have Access data based application (mdb File), with some local and link tables with MSSQL.
Now I want to run few forms on browser Or In other words making few forms web based But not the complete application.
Any suggest and advice
Regards
Ayaz Hoda
|
|
February 12th, 2009, 08:19 AM
|
|
Friend of Wrox
|
|
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
|
|
Since the back end is SQL, you have a lot of options. Do a search in Access Help for "Publish web pages" and it will show you how to make data access pages out of Access forms and reports.
HTH
__________________
mmcdonal
Look it up at: http://wrox.books24x7.com
|
|
The Following User Says Thank You to mmcdonal For This Useful Post:
|
|
|
February 19th, 2009, 06:22 AM
|
|
Friend of Wrox
|
|
Join Date: Apr 2007
Posts: 110
Thanks: 1
Thanked 2 Times in 2 Posts
|
|
Did try to find as much as possible but with access 2007 there is'nt much available with out sharepoint
I dont want to use Sharepoint as solution.
Still confused
Regards
Ayaz
|
|
February 21st, 2009, 05:25 PM
|
|
Authorized User
|
|
Join Date: Jul 2008
Posts: 38
Thanks: 1
Thanked 2 Times in 2 Posts
|
|
Quote:
Originally Posted by ayazhoda
Did try to find as much as possible but with access 2007 there is'nt much available with out sharepoint
I dont want to use Sharepoint as solution.
|
Access is currently not a "web solution" unless you use SharePoint. So, you will need a different frontend (ASP.NET comes to mind).
And, since Data Access Pages (which were never that good anyway) have been deprecated by Microsoft (and aren't available in 2007 and beyond), you can't use them.
Access is just not ready for web "Prime-time" and so you will likely need to rethink your situation.
|
|
February 21st, 2009, 05:27 PM
|
|
Authorized User
|
|
Join Date: Jul 2008
Posts: 38
Thanks: 1
Thanked 2 Times in 2 Posts
|
|
Oh, and I said "Access is currently not a web solution" and that also means you can't write a form and have it run in a browser - even if you use SharePoint. You still would be using the desktop version of the program or Access Runtime.
|
|
February 22nd, 2009, 07:28 AM
|
|
Authorized User
|
|
Join Date: Feb 2005
Posts: 47
Thanks: 2
Thanked 0 Times in 0 Posts
|
|
Possible solution
You could use JavaScript. Now this will require a knowledge of ADO.NET and utilizing this as an ActiveX Object. The only caveat to this is that I am not sure if this object is marked safe for scripting. Your users will have to allow scripts not safe for scripting within IE. Basically you would use HTML forms and then JavaScript would walk the DOM and tie the controls to data through that ActiveX Object.
Chris
|
|
February 24th, 2009, 01:08 AM
|
|
Authorized User
|
|
Join Date: Jul 2008
Posts: 38
Thanks: 1
Thanked 2 Times in 2 Posts
|
|
Quote:
Originally Posted by kuznickic
You could use JavaScript. Now this will require a knowledge of ADO.NET and utilizing this as an ActiveX Object. The only caveat to this is that I am not sure if this object is marked safe for scripting. Your users will have to allow scripts not safe for scripting within IE. Basically you would use HTML forms and then JavaScript would walk the DOM and tie the controls to data through that ActiveX Object.
Chris
|
Yes, that is a possible solution. It does not make the Access frontend web-based however as that is something nothing can do. You need to create a web-based frontend to attach to an Access BACKEND if you want real web functionality (in a browser).
|
|
February 24th, 2009, 01:52 AM
|
|
Authorized User
|
|
Join Date: Feb 2005
Posts: 47
Thanks: 2
Thanked 0 Times in 0 Posts
|
|
Using Access as a backend
boblarson brings up a very good point. When dealing with the Office data programs like excel and access these are very good at just that....data. For front end capability you should really turn to either JavaScript or something like InfoPath if this solution if for your intranet. Not only do you get an intuitive front end with InfoPath but you also get a workflow solution pretty much out of the box. Not to mention that you could InfoPath forms available in the browser, with a few restrictions.
|
|
|
