Read RMS data via ODBC

We have 5 franchise retail stores and 1 central office. Our franchisor is migrating from apropos in Unix/Linux to RMS. I have an extensive administator database in MS Access reading the current apropos tables via a vpn and ODBC connection using informix at our central office (off site from the stores). I only need to read information at the central office.

Working with the RMS demo (we go live in stores next week), I can odbc to the sample database but cannot see any of the table that hold actual data. As usual, it is like pulling teeth to get conncect information from the franchisor even though they say, "Sure, we'll give it to you."

Can anyone give me a hint as to how to get to the actual data tables so I can convert my Access front end to read them? I am fairly knowledgeable with ODBC and VB, etc. Not so with sqlServer. Sorry for the long post....just need help quickly before the go live date. Thanks in advance.

Reply to
Rusty F
Loading thread data ...

Send me your email address. I'll send you instructions.

snipped-for-privacy@rochester.rr.com

Reply to
Rick Brown

Thanks Rick,

I cut and pasted your email and it bounced back. You can contact me at snipped-for-privacy@birch.net

Thanks again

Reply to
Rusty F

It's on it's way. I can't type that fast - it's already there.

Rick

Reply to
Rick Brown

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.