FagerbergDellby
asked on
Changes in Access 2010 (linked tables with multiple value fields)
I have upgraded to MO 2010 from MO 2007. In Access 2007 I have created a database which i split between a back-end and a front end. After migrating to 2010 I get an error message when updating links to tables which contain fields with multiple values:
"[table] is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long"
When I remove the fields which allow multiple values from the backend it is possible to update the links (but I don't want to remove these fields).
Is there anyway I can keep the multiple value fields and still refresh links?
"[table] is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long"
When I remove the fields which allow multiple values from the backend it is possible to update the links (but I don't want to remove these fields).
Is there anyway I can keep the multiple value fields and still refresh links?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<The disadvantage is that I now need to add two additional tables to my query>
Yes, but the advantagea are that it will:
Work flawlessly.
Be exportable
Not have any issue
Be easier to understand
Be Standardized
...ect
<I seem to recall there is a limitation in Access that limits a query to three steps/tables in order for it to remain updateable.>
Not exactly, the types of Joins, for the most part, determine if the query is updateable or not.
The attached database query has 4 tables, and it is quite updateable (can create an order)
(the Cust Name and Product Names even fill in automatically)
;-)
JeffCoachman
Database22.mdb
Yes, but the advantagea are that it will:
Work flawlessly.
Be exportable
Not have any issue
Be easier to understand
Be Standardized
...ect
<I seem to recall there is a limitation in Access that limits a query to three steps/tables in order for it to remain updateable.>
Not exactly, the types of Joins, for the most part, determine if the query is updateable or not.
The attached database query has 4 tables, and it is quite updateable (can create an order)
(the Cust Name and Product Names even fill in automatically)
;-)
JeffCoachman
Database22.mdb
ASKER
I have now rebuilt my old BE (I had to do this on a computer running Access 2007 in order for it to work). The disadvantage is that I now need to add two additional tables to my query - which is a problem as I seem to recall there is a limitation in Access that limits a query to three steps/tables in order for it to remain updateable. Anyway, I will try to work around this as well.
Best regards