Help
Hi all,
Recently had MOM6 (UK version) installed, and I'm going to be responsible for customising it and making sure that all of the features that the old system had are possible using MOM.
Most of the bits that I'm going to have to do are reports and custom paperwork, and I was told by the chap who performed the installation that it was possible to get MS Access to talk to the MOM6 database (via OLE connection). Excellent, I thought as I am very familiar with Access, and could use it to create reports, populate other systems etc, etc. Now I've just spent the best part of 4 hours trying to get Access 2003 to talk to the FoxPro 9 database. I've got nowhere with it, so was wondering if anybody else had any ideas. I've tried on both my Vista laptop and my XP desktop (and sorted out the triedit.dll issue on the Vista machine) and get diddly from both.
Now I have a solid programing background so am happy to whip up a ASP front end, or a Visual Basic program, but without having some kind of Data Dictionary and a Relationship Diagram, am not going to have much luck.
My personal preference would be to stay with Access, as should I ever leave or not be available, another IT bod can come in and tackle it, but if I have to, I'll resort to ASP.
Page 1 of 1
Struggling - FoxPro9 and Access 2003
#2
DMC_UK_Paul 
- Newbie
-
- Group: Members
- Posts: 1
- Joined: 15-July 08
Posted 15 July 2008 - 04:51 AM
Did you ever resolve this post. I am a new UK MOM 6 user and have the same issue.?
MBA, on Apr 6 2008, 12:08 PM, said:
Hi all,
Recently had MOM6 (UK version) installed, and I'm going to be responsible for customising it and making sure that all of the features that the old system had are possible using MOM.
Most of the bits that I'm going to have to do are reports and custom paperwork, and I was told by the chap who performed the installation that it was possible to get MS Access to talk to the MOM6 database (via OLE connection). Excellent, I thought as I am very familiar with Access, and could use it to create reports, populate other systems etc, etc. Now I've just spent the best part of 4 hours trying to get Access 2003 to talk to the FoxPro 9 database. I've got nowhere with it, so was wondering if anybody else had any ideas. I've tried on both my Vista laptop and my XP desktop (and sorted out the triedit.dll issue on the Vista machine) and get diddly from both.
Now I have a solid programing background so am happy to whip up a ASP front end, or a Visual Basic program, but without having some kind of Data Dictionary and a Relationship Diagram, am not going to have much luck.
My personal preference would be to stay with Access, as should I ever leave or not be available, another IT bod can come in and tackle it, but if I have to, I'll resort to ASP.
Recently had MOM6 (UK version) installed, and I'm going to be responsible for customising it and making sure that all of the features that the old system had are possible using MOM.
Most of the bits that I'm going to have to do are reports and custom paperwork, and I was told by the chap who performed the installation that it was possible to get MS Access to talk to the MOM6 database (via OLE connection). Excellent, I thought as I am very familiar with Access, and could use it to create reports, populate other systems etc, etc. Now I've just spent the best part of 4 hours trying to get Access 2003 to talk to the FoxPro 9 database. I've got nowhere with it, so was wondering if anybody else had any ideas. I've tried on both my Vista laptop and my XP desktop (and sorted out the triedit.dll issue on the Vista machine) and get diddly from both.
Now I have a solid programing background so am happy to whip up a ASP front end, or a Visual Basic program, but without having some kind of Data Dictionary and a Relationship Diagram, am not going to have much luck.
My personal preference would be to stay with Access, as should I ever leave or not be available, another IT bod can come in and tackle it, but if I have to, I'll resort to ASP.
#3
notehead
- Advanced Member
-
- Group: Members
- Posts: 52
- Joined: 27-September 04
Posted 17 November 2008 - 11:28 AM
DMC_UK_Paul, on Jul 15 2008, 05:51 AM, said:
Did you ever resolve this post. I am a new UK MOM 6 user and have the same issue.?
The help files show the table structure for main tables. Other tables are not detailed. I'm happy to help if you have specific questions. Email or msn me as I don't check in here oo often.
Share this topic:
Page 1 of 1