Jump to content


Photo

MOM 6 and Access XP (2002)


  • Please log in to reply
2 replies to this topic

#1 Nathan Freedman

Nathan Freedman

    Newbie

  • Members
  • Pip
  • 9 posts

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

Nathan Freedman

    Newbie

  • Members
  • Pip
  • 9 posts

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...

#3 ypf1258

ypf1258

    Advanced Member

  • Moderators
  • PipPipPip
  • 101 posts
  • Gender:Male
  • Location:ny

Posted 18 May 2008 - 07:38 PM

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...


Did you select " free table directory "




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users