Re: newbie looking to sync access with MySQL

> I have a potential customer that just called and would like to create a web > site that would display secure info for their clients. Currently his > employees are using a flat Access database to add, edit and delete records > and he would like to keep it that way. > > Normally I would create a web manager for them to add, edit and delete the > MySQL database. Is there an easy, reliable way to sync up Access with MySQL. > Maybe a nightly script that could upload the contents of Access to MySQL. > > Would it be easier to start with ASP and SQL Server? If only the Access database can change, you could fairly easily schedule an export and then upload that to be sucked into MySQL. There also is at least one tool/product out there specifically to do this, but I dunno where it is... You really don't want Access behind your web-site. Too unstable. -- WARNING richard@zend.com address is an endangered species -- Use ceo@l-i-e.com Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Volunteer a little time: http://chatmusic.com/volunteer.htm