MOM 6 and Access XP (2002)

#1 Nathan Freedman

Newbie

Group: Members
Posts: 9
Joined: 21-August 07

Posted 25 April 2008 - 12:21 PM

Hi,

I am trying to make a simple connection to an offline copy of the mom 6 database with Access XP so I can merge data and export it in csv or any format access will allow. The problem is that I can't seem to just make a database connection to create relationships between the database tables.

Any thoughts?

Nathan...

#2 Nathan Freedman

Newbie

Group: Members
Posts: 9
Joined: 21-August 07

Posted 17 May 2008 - 05:09 AM

Ok after not having any success with Access and Mom I tried OpenOffice.org (a free program that competes with MS Office). Success! First backup your MOM database and copy it to a working location other than the LIVE database. This is a new connection and we want to test it first. Just download the Visual FoxPro driver at Download and then get the Open Office program at OpenOffice.org. Go to open a base database and connect to an ado source. Select Visual FoxPro Driver OLE DB and enter the necessary info and there you go. You have full access after putting in your user name and password. I hope to have full screen shots of the step by step soon.

Nathan...