D
Dean Simpson
Can anyone help here. I have created a simple/complicated query and tried
to then create the pivot table winthin Access 2003. All that happnes is the
screeen seems to refresh and no Pivottable or PivotChart can be created. So
I tried to use the form wizard to create my pivottable. No Luck. When the
wizard completes I get an error mesage saying
"The wizard is unable to open your form in form view or datasheet view,
possibly because another user has the source table open in exclusive mode.
Your form will be open in design view"
I have doubled check that the database is open in sharded mode and no other
users are using the dbase. I have searched through the newsgroups and
microsoft knowledge base to find a cure but there seems to be very little
knowledge around. Can anyone help at all.
I have even created a new dbase from scratch and it still does the same.
But when I copt the dbase onto another machine with the same version of
access(2003) it works fine I will post this message under forms aswell to
see if anyone there can help.
to then create the pivot table winthin Access 2003. All that happnes is the
screeen seems to refresh and no Pivottable or PivotChart can be created. So
I tried to use the form wizard to create my pivottable. No Luck. When the
wizard completes I get an error mesage saying
"The wizard is unable to open your form in form view or datasheet view,
possibly because another user has the source table open in exclusive mode.
Your form will be open in design view"
I have doubled check that the database is open in sharded mode and no other
users are using the dbase. I have searched through the newsgroups and
microsoft knowledge base to find a cure but there seems to be very little
knowledge around. Can anyone help at all.
I have even created a new dbase from scratch and it still does the same.
But when I copt the dbase onto another machine with the same version of
access(2003) it works fine I will post this message under forms aswell to
see if anyone there can help.