[AccessD] Move to Internet

Dale,

I work for a small firm that currently has no formal "intranet".  

We wanted to create several reports (Based on Access 2007 Data) on a daily basis and keep them for historical purposes.

We created the reports in Access 2007 and pushed them out in HTML format.  We have a little
VBA code to build and put a date-time stamp in the file name.

Example    Sales_Report_Date_2010_04_08_Time_06_01_55.html

These reports were all stored in a single folder on our Windows Server.

We then wrote a little Windows Script to build an HTML "Index" page that simply lists each .HTML file in the folder.  

Example (each line is a hyperlink to an actual report)
~~~~~~~~~~~~~~~~~~~
Sales_Report_Date_2010_04_01_Time_05_01_11.html
Sales_Report_Date_2010_04_02_Time_07_04_12.html
Sales_Report_Date_2010_04_03_Time_03_02_33.html
Sales_Report_Date_2010_04_04_Time_09_07_34.html
Sales_Report_Date_2010_04_05_Time_03_03_23.html
~~~~~~~~~~~~~~~~~~~  

Granted, this is pretty basic, but we are now able to easily view our Access 2007 Reports in HTML format.  

Down the road, we may build a more sophisticated "Intranet", but for now, this is getting the
job done nicely and it did not incur any additional expenses.

I am not sure if this is what you had in mind.

Please feel free to ask any questions if I didn't explain things clearly.

Brad    

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dale_Anne Kalsow
Sent: Friday, April 09, 2010 11:51 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Move to Internet

Good Morning,
 
Does anyone have any experience taking an access 2007 database and converting it to be used on an intranet?  Is so I would appreciate knowing how to do it.
 
thanks!
 
Dale


      
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.