I have built a database driven web site but I need to now automatically update the records when the office server database has new records added or amended. I am using access on both servers but the office service is only connected when online. They will be
getting broadband. The office server must be secure as it hold company data. Any ideas please
Access supports replication, and can securely update when the databases are reconnected. Sounds like it might be the perfect solution for you. Don
Don Kiely, MCP, MCSD
In the Last Frontier, Interior Alaska
Please post questions and replies to the forum! And remember to MARK AS ANSWER when someone definitively answers a question or resolves a problem!
Yep, sure does. You have pretty good flexibility in configuring it. Don
Don Kiely, MCP, MCSD
In the Last Frontier, Interior Alaska
Please post questions and replies to the forum! And remember to MARK AS ANSWER when someone definitively answers a question or resolves a problem!
I have no system access to the web server it is a hosting company the client uses. The database is in a system only access folder for security. Can I still setup replication without any admin rights on the web server. The only access is normal web client and
a ftp account cannot change permission on the folders either. John
Yikes. I don't know. The good news is that I believe that everything you need for Access replication is in the file, but I'd be surprised if you can set it up one one machine and deploy it to another, AND have it work. That's way deeper that I've ever gone
with Access replication. You might want to ask this question over on the Data Discussions/Access forum, where a lot more Access devs hang out. Don
Don Kiely, MCP, MCSD
In the Last Frontier, Interior Alaska
Please post questions and replies to the forum! And remember to MARK AS ANSWER when someone definitively answers a question or resolves a problem!
Thanks again for your reply I will try the access forum. I would have thought that this problem is a regular one where the office databases needs to update the web database which is hosted on a normal host with little access permissions. Have you any thoughts
on how else it could be done. Webservice ??? I just do not know how to achieve this securely and effectively, as without this method it would mean the clients would have to enter a lot of data twice. Thanks again for your help. cheers John
Hi John, Well, this certainly sounds like the ideal situation for replication. It takes some work to get set up and working, even in Access, but is what it's designed for. Any other solution you do yourself requires keeping track of what's been updated and
what hasn't. You can use a variety of mechanisms to do that via Web services or .NET remoting. How you do it depends on how complex the data relationship are that you need to keep track of. But almost anything is better than entering data twice. That becomes
a nightmare quickly. What kind of data is it? Don
Don Kiely, MCP, MCSD
In the Last Frontier, Interior Alaska
Please post questions and replies to the forum! And remember to MARK AS ANSWER when someone definitively answers a question or resolves a problem!
It is for a company that sells advert space on the net so the purchasers can either submit thier main details via the web ie people contact and advert description then be contacted for full details or telephone the company and supply all detains to the office.
Which ever way the data arrives it needs formatting and the data put back in the web database for the ASP pages to create web pages from. At the moment they go online and via admin pages update the database but then they need to update the company master database.
Does this help at all. I went to the access section and asked the question but had no joy with whether replication can be setup remotely without admin rights on both servers. I also asked if you can automate it with RJO but had no replies yet. many thanks
for your thoughts John
Hi John, Ah. So it's really only a single set of data that needs to be entered, updated or added to, and then put into a live database? In that case, replication would be over kill. It would be far easier to just put the Web-entered records into a table in
the first database. Then have an admin app that reads whatever records are there, call the client, use a form to add other data and do whatever business rule validation you need, then dump that all into the final destination database. With human or machine
interaction like you need, replication probably isn't the way to go. This make sense? Don
Don Kiely, MCP, MCSD
In the Last Frontier, Interior Alaska
Please post questions and replies to the forum! And remember to MARK AS ANSWER when someone definitively answers a question or resolves a problem!
johnshat
Member
40 Points
8 Posts
updating web server database from office database
Aug 09, 2003 06:56 PM|LINK
donkiely
All-Star
15929 Points
2518 Posts
ASPInsiders
Moderator
MVP
Re: updating web server database from office database
Aug 09, 2003 07:02 PM|LINK
In the Last Frontier, Interior Alaska
Please post questions and replies to the forum! And remember to MARK AS ANSWER when someone definitively answers a question or resolves a problem!
johnshat
Member
40 Points
8 Posts
Re: updating web server database from office database
Aug 10, 2003 09:06 AM|LINK
donkiely
All-Star
15929 Points
2518 Posts
ASPInsiders
Moderator
MVP
Re: updating web server database from office database
Aug 10, 2003 05:55 PM|LINK
In the Last Frontier, Interior Alaska
Please post questions and replies to the forum! And remember to MARK AS ANSWER when someone definitively answers a question or resolves a problem!
johnshat
Member
40 Points
8 Posts
Re: updating web server database from office database
Aug 11, 2003 12:30 PM|LINK
donkiely
All-Star
15929 Points
2518 Posts
ASPInsiders
Moderator
MVP
Re: updating web server database from office database
Aug 11, 2003 04:05 PM|LINK
In the Last Frontier, Interior Alaska
Please post questions and replies to the forum! And remember to MARK AS ANSWER when someone definitively answers a question or resolves a problem!
johnshat
Member
40 Points
8 Posts
Re: updating web server database from office database
Aug 12, 2003 12:13 PM|LINK
donkiely
All-Star
15929 Points
2518 Posts
ASPInsiders
Moderator
MVP
Re: updating web server database from office database
Aug 12, 2003 06:46 PM|LINK
In the Last Frontier, Interior Alaska
Please post questions and replies to the forum! And remember to MARK AS ANSWER when someone definitively answers a question or resolves a problem!
johnshat
Member
40 Points
8 Posts
Re: updating web server database from office database
Aug 14, 2003 04:59 PM|LINK
donkiely
All-Star
15929 Points
2518 Posts
ASPInsiders
Moderator
MVP
Re: updating web server database from office database
Aug 14, 2003 11:46 PM|LINK
In the Last Frontier, Interior Alaska
Please post questions and replies to the forum! And remember to MARK AS ANSWER when someone definitively answers a question or resolves a problem!