DavidB
|
| Posted: 07/19/2002, 6:41 PM |
|
Has anyone else had problems running Studio with MS Access ? I find that my database creates an autolookup between two tables which have the same field names and the Studio maintenance page will not let me add a relationship. When I attempt to build that page, i see an error like "Insert allowed but datasource uses custom update"
I have attempted to get Access to ignore the autolookup by renaming one of the fields ie. status_id in one table and status__id in the 2nd table but studio still gives the same error when publishing
|
|
|
 |
fet
|
| Posted: 07/21/2002, 10:23 AM |
|
Try removing the underscores in the second status__ID, and remane it something like status2. I remember a problem like this a few months ago, seems the underscores are removed when the program handles an "_" , therefor both status vars look like "statusid"
fet
|
|
|
|
|
