Help Wanted: MS Access conversion?

[stephenmchugh]

We are stuck with an exisiting MS Access app/database with accounts and contacts. Upgrading to Sugar is NOT an option. However we would like to use the Sugar interface to allow field sales people to view/edit/delete this Access data through a web interface. Is it possible/legal to re-code open source Sugar so that the database queries use the existing MS Access db instead of MySQL? If so, how much?!

Some caveats:
1) The Access tables do not match the Sugar Mysql tables, so you would need to modify all queries.
2) We are not yet convinced this can be done (we tried getafreelancer.com but all we got back was "we do PHP" and no-one seemed to really understand the scope of the problem.)
3) Less than 5 users at any one time, so record locking issues (between sugar and access) can be ignored.
4) Again, altering the Access tables in any way is impossible because an existing app uses the tables.

Rgds

Stephen McHugh

[chuckd0138]

Steve,
I have a utility that will convert AccessDB to MySQL. I am not sure where we would go from there. I am also an ASP programmer so have put AccessDB's up to have online updates through either local LAN or WAN through the internet.
Let me know what you think and what you would be willing to reward me for my efforts.

Chuck Downs
chuckd0138@hotmail.com

[mtjeffe]

We are stuck with an exisiting MS Access app/database with accounts and contacts. Upgrading to Sugar is NOT an option. However we would like to use the Sugar interface to allow field sales people to view/edit/delete this Access data through a web interface. Is it possible/legal to re-code open source Sugar so that the database queries use the existing MS Access db instead of MySQL? If so, how much?!

Some caveats:
1) The Access tables do not match the Sugar Mysql tables, so you would need to modify all queries.
2) We are not yet convinced this can be done (we tried getafreelancer.com but all we got back was "we do PHP" and no-one seemed to really understand the scope of the problem.)
3) Less than 5 users at any one time, so record locking issues (between sugar and access) can be ignored.
4) Again, altering the Access tables in any way is impossible because an existing app uses the tables.

Rgds

Stephen McHugh

Stephen,

Were you able to locate a solution to your AccessDB request? ~Marius