Jump to content


Photo

ODBC from ACCESS TO MOMWIN


  • Please log in to reply
4 replies to this topic

#1 Videoflicks2004

Videoflicks2004

    GLOBAL MODERATOR

  • Moderators
  • PipPipPip
  • 241 posts
  • Gender:Male
  • Location:Canada
  • Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.

Posted 06 May 2005 - 04:53 PM

Hi,

Is anyone able to list CMS.DBF or STOCK.DBF in Microsoft Access?

Cheers,

David
David Narciso
Ecommerce Operations Manager CVS Inc

[email protected]

mobile: 4168238175

DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.

#2 MerchantSmurf

MerchantSmurf

    Member

  • Members
  • PipPip
  • 22 posts

Posted 09 May 2005 - 01:27 PM

Hello David,

Works fine here.

Mom 5.2
Access 2002

I had to delete the un-named dbf file from the directory.

#3 notehead

notehead

    Advanced Member

  • Members
  • PipPipPip
  • 52 posts

Posted 11 May 2005 - 08:14 AM

Hello David,

Works fine here.

Mom 5.2
Access 2002

I had to delete the un-named dbf file from the directory.

View Post


Occasionally I find I need to reindex before all tables will showup. I find the best way is to delete all of the .cdx files and restart MOM and they will be rebuilt.

j

#4 Guest_deversm_*

Guest_deversm_*
  • Guests

Posted 06 August 2005 - 09:55 PM

Occasionally I find I need to reindex before all tables will showup. I find the best way is to delete all of the .cdx files and restart MOM and they will be rebuilt.

j

View Post


I ftp'd the cust, cms, stock, & items tables to my SQL Server where I also have Access. Access "saw" cust, cms, & stock, but not items. So I rebuilt the Items index in MOM, ftp'd the table and index, and Access still can't see that table. Any suggestions?

Thanks,

Michael

#5 notehead

notehead

    Advanced Member

  • Members
  • PipPipPip
  • 52 posts

Posted 07 September 2005 - 08:31 AM

As mentioned above, delete the .cdx files in the MOM folder, open MOM and it will reindex all tables, then you should be able to see all of them. The indexing feature rebuids within the existing cdx file. If there is corruption in the index it doesn't fix it. The above process does.

nh




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users