homepage Welcome to WebmasterWorld Guest from 54.237.54.83
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
Access DB and webservices
RCDA Web master




msg:4285889
 7:21 pm on Mar 22, 2011 (gmt 0)

My company (The Catholic Diocese) has an access DB that they use to track happenings at the various parishes. This DB is tied to another access DB to insure that information such as parish names, priest names . . . can not be changed as users update the parish information. The forms that are used to update the DB are contained with in the access DB itself.

A request has come down that the database should be web enabled and use an InfoPath forms front end so that the parishes can themselves submit the DB updates directly to the DB rather than returning their entry data to a central person who must then enter the data for all 130 parishes.

In my research I've read about web services and am interested in generating a web service so that the InfoPath form can talk to the Access DB and submit/retreive data according to the InfoPath forms.

What I need to know is Since the DB I want to update is tied to a second DB, how will the web service interact with both DBs at the same time? can it even do that? the other thing to consider is that the second DB is setup with username and password access.

 

redhatlab




msg:4319545
 1:10 pm on May 30, 2011 (gmt 0)

Hi,

Since a modification from desktop to web based is required, why no use this opportunity to get away from ms access and migrate all data into MySQL that will still run in the same infrastructure you already have and that will be more user friendly for web base interfaces.

Once all the data is in MySQL you can use PHP you create the forms to input, update and view data. You can even use Drupal, a PHP framework to speed up the process while maintaining a high control in the security of the site.

The migration to MySQL and PHP will have another benefit and that is the reduction of cost for licenses of Microsoft products. There will no more need of MS Access on each computer to access the application as well as a change in your infrastucture from windows servers to Linux servers.

Thank you.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved