Access 2003 sp3 problem with subforms

E

Eric Boggs

I have a serious issue with my Access ADP database that is connected to a SQL
2k backend after upgrading to office SP3.

A subform that uses a view to insert new records isn't allowing new records
to be inserted. I can modify any existing records but if I try to add a new
record I either get the following error or it just won't let me type in any
fields.

"Microsoft Office Access can't find the object 'SHAPE(SHAPE RS_1694 AS
reLevel0 COMPUTE rsLevel0, Sum(rsLevel0.[record]) AS C0) AS RS_1791." It
then goes on to say "You tried to open a linked table, but the file
containing the table isn't on the path you specified."

The only change made was the update to SP3. Testing the database on a
machine that is still SP2 the form works perfectly. This has seriously
broken my database and we were forced to roll back to SP2.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top