As you can see, I've been trying to sort this out for months... so long in fact that a new version of Office has now been released but I havent sorted out this one yet!!
Anyway, when trying to use an existing Access 2000 database on my new Access 2007 I get the following error when trying to load new information in a subform.
Doesnt matter whether I convert database to new format or not.
Only does it when I use data saved on a shared networked hard drive - is ok on local drive.
I have checked data properties on subform (Master & Child fields and both look fine to me, eg the same field which is linked in the database - which only has two tables by the way).
Error is:
The LinkMasterFields property setting has produced this error: 'Expected: list separator or)'
Any help most appreciated. We are the owners of a small private business and dont have a dedicated IT person, so its down to me to try & sort out.
Anyway, when trying to use an existing Access 2000 database on my new Access 2007 I get the following error when trying to load new information in a subform.
Doesnt matter whether I convert database to new format or not.
Only does it when I use data saved on a shared networked hard drive - is ok on local drive.
I have checked data properties on subform (Master & Child fields and both look fine to me, eg the same field which is linked in the database - which only has two tables by the way).
Error is:
The LinkMasterFields property setting has produced this error: 'Expected: list separator or)'
Any help most appreciated. We are the owners of a small private business and dont have a dedicated IT person, so its down to me to try & sort out.