Go Back   Access World Forums > Microsoft Access Discussion > Access Web

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-06-2017, 12:54 PM   #1
abubasil
Newly Registered User
 
Join Date: Aug 2011
Posts: 29
Thanks: 1
Thanked 3 Times in 3 Posts
abubasil is on a distinguished road
windows iis server and Msaccess db

Hi all.How are you.
first of all excuse me for my bad English..
I've just made a way that might be useful in some circumstances like ours , in our small office, I have a friend who is registering lots of paper documents details and references into normal access mdb file and is often interrupted by people who ask him about this that document details.
the solution was one line code to OUTPUT the main table content -let its name be "names" - to names.htm file in acformatHTML this way
DoCmd.OutputTo acOutputTable, "names", acFormatHTML, "D:\accessweb\names.htm"

the folder "D:\accessweb" is serving as the location of a small website in the iis settings.
In case you do not know how to setup iis. here is an illustrated guide
http://www.dnnsoftware.com/docs/deve...et-up-iis.html

Now my friend can work and updates that names.htm file by single click on a button in the interface of his db to output the table(s) and overwrite the new updates to the names.htm whenever needed.

and others can reach that lan website in my friend's PC from their cellphones who are connected to the same router in the office. and lookup what they need. I added some functionality to this little website via javascript to add search feature ,I share this idea with you in the attachments.

thank you.
Attached Files
File Type: zip accessweb.zip (79.2 KB, 18 views)


Last edited by abubasil; 07-06-2017 at 07:10 PM.
abubasil is offline   Reply With Quote
Old 07-08-2017, 06:57 AM   #2
abubasil
Newly Registered User
 
Join Date: Aug 2011
Posts: 29
Thanks: 1
Thanked 3 Times in 3 Posts
abubasil is on a distinguished road
Re: windows iis server and Msaccess db

Few people care!
Okay .
I am not excel user or programmer , but I -after this post- discovered that excel can not only save data into webpage.htm but can also publish data in the meaning each time you edit and save the worksheet , new updates will be published into that webpage.
in my case that webpage was located in the iis folder which means I provide people with web interface for my data in excel format which is more powerful than any other javascript grid you may think of.
abubasil is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Upload records from MSAccess to SQL SERVER tom in houston SQL Server 3 11-28-2012 01:06 PM
Get windows loginID securely for MSAccess pkstormy Sample Databases 0 04-13-2008 10:39 PM
MSaccess.exe not quitting on the server cxu118 General 0 05-10-2005 10:01 AM
MSAccess & Client Server Configuration Beaula General 7 08-19-2004 12:51 PM
MSAccess Windows Date and Time Picker causing an error Zantar Forms 2 04-27-2001 01:00 PM




All times are GMT -8. The time now is 06:49 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World