Mail Order Manager & Dydacomp Sitelink Tech Support Forums: ODBC from ACCESS TO MOMWIN - Mail Order Manager & Dydacomp Sitelink Tech Support Forums

Jump to content

Page 1 of 1

You cannot start a new topic
You cannot reply to this topic

ODBC from ACCESS TO MOMWIN STOCK AND CMS don't show up?

#1 Videoflicks2004

GLOBAL MODERATOR

Group: Moderators
Posts: 241
Joined: 29-September 04
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

dnarciso@cvsinc.ca

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

Member

Group: Members
Posts: 22
Joined: 05-January 05

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

Advanced Member

Group: Members
Posts: 52
Joined: 27-September 04

Posted 11 May 2005 - 08:14 AM

MerchantSmurf, on May 9 2005, 01:27 PM, said:

Hello David,

Works fine here.

Mom 5.2
Access 2002

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

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_*

Group: Guests

Posted 06 August 2005 - 09:55 PM

notehead, on May 11 2005, 11:14 AM, said:

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

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

Advanced Member

Group: Members
Posts: 52
Joined: 27-September 04

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