Warner

It does appear that the DBC file is the container for all of the tables, but the data still remains in the DBF files.

It works out that the DBC file is a giant data dictionary of all of the tables within MOM, something that Dydacomp was reluctant to release before.

But I am still looking for a way to query the DBC to get the information out of the DBF files, since I cannot access them directly (I get the response that is posted in the first post of this thread).

Would be great if someone shed some light on how we might be able to query the MOMDATA.dbc file so we can access the rest of our data.

Try the free download below from Microsoft. I'm not sure if it works because I'm not upgrading from MOM 5.4 to 6.0 until a fix for this problem is confirmed by someone other than Dydacomp.

Microsoft OLE DB Provider for Visual FoxPro 9.0
Brief Description
The Visual FoxPro OLE DB Provider (VfpOleDB.dll) exposes OLE DB interfaces that you can use to access Visual FoxPro databases and tables from other programming languages and applications.

http://www.microsoft...;DisplayLang=en

Hey guys, neat forum you have here!

I am new to MOM as the company I just began working for has it in production. I wanted to use DBUWin to update the ord_date field in the CMS table so I made a copy of the table, updated the copy and then renamed the current CMS tables and replaced it with the copy. This did not work due to the index not matching, or so it seems, and I wanted to know how I should have done this. Should I have just made a copy of the live table and then went on updating the live table, replacing it with the backup if anything went wrong?

I do not have much experience with FoxPro databases and I was wondering if there are any other ways to get into the database that are known to be ok with the MOM? I tried to copy a table and create an ODBC connection to link it to access but it failed. I would love a way to run SQL commands instead of having to use DBUWin. Thanks in advance, looking forward to being a member of the forum!

Josh

I'm using an ODBC connection and an Access database to query MOM tables. We use it for custom reporting, to create and print customized invoices with variable messaging based on customer and order data, and to update MOM tables based on specific criteria. I find Access easier and much more flexible than dbuwin, but I guess I'm biased because I know Access much better.

A funny thing is there was a small file in my momwin folder called .dbf (that's right, no file name, only extension) and the ODBC connection worked only after removing that file from the momwin folder. Try that, and if you still have problems, let me know.