Hi,
Is anyone able to list CMS.DBF or STOCK.DBF in Microsoft Access?
Cheers,
David
ODBC from ACCESS TO MOMWIN
Started by Videoflicks2004, May 06 2005 04:53 PM
4 replies to this topic
#1
Posted 06 May 2005 - 04:53 PM
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.
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
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.
Works fine here.
Mom 5.2
Access 2002
I had to delete the un-named dbf file from the directory.
#4 Guest_deversm_*
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
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
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
nh
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users