Error Message Clarification

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I tried to compact a database.
In what circumstances would I get a message
Could not create; no modify design permission for table or query 'TempMSAccessObject

Many Thank
Jay
 
Jay, I came across this problem when I tried to compact a database while logged on as a user that is not member of Admins. Having said that I have no idea how to fix this, can someone out there help??? I assumed that assigning this user Database Administer permissions should have worked but evidently not. Thanks and lets hope somebody can help
 
Could you please post what the issue is? I can no longer see the message
you are replying to.

--
Joan Wild
Microsoft Access MVP

Paul said:
Jay, I came across this problem when I tried to compact a database while
Click to expand...
logged on as a user that is not member of Admins. Having said that I have no
idea how to fix this, can someone out there help??? I assumed that assigning
this user Database Administer permissions should have worked but evidently
not. Thanks and lets hope somebody can help.
 
----- Joan Wild wrote: ----

Could you please post what the issue is? I can no longer see the messag
you are replying to

--
Joan Wil
Microsoft Access MV

Paul said:
Jay, I came across this problem when I tried to compact a database whil
Click to expand...
logged on as a user that is not member of Admins. Having said that I have n
idea how to fix this, can someone out there help??? I assumed that assignin
this user Database Administer permissions should have worked but evidentl
not. Thanks and lets hope somebody can help
 
Paul said:
----- Joan Wild wrote: -----

Could you please post what the issue is? I can no longer see the message
you are replying to.

--
Joan Wild
Microsoft Access MVP

----------
Original message
I tried to compact a database.
In what circumstances would I get a message:
Could not create; no modify design permission for table or query 'TempMSAccessObject'
Click to expand...


In all my looking I have no reference for any such table. It's possible the
database is corrupt.
I suggest you copy the database first.

Try compacting your database using Jetcomp, available at
http://support.microsoft.com/?id=273956

If that fails, try creating a new database and importing objects from the
old.
 
I am not sure I understand why I need to repair the database since I have no porblems opening and accessing the data. My issue is simply that unless the current user is member of Admins, he cannot compact the database since that error message pops up. Now having said that I tried to run Jet Compact and that fails before it evens starts, I get: "Error compacting database" with no descriptions, I must be doing something silly??? My database is secured and I tried to enter a password via the Tools menu but that fails as well. Any ideas
Thanks!
 
The user compacting the database doesn't have to be a member of the Admins
group, they just need open exclusive permission on the database object, and
they must have it opened exclusively when they compact.

You may be having problems with Jetcomp because you are not specifying the
correct workgroup (and supplying a username/password). Look in the Tools
menu where you can specify the workgroup to use.

However you may be able to overcome the problem by just compacting using a
username that has open exclusive permission.

--
Joan Wild
Microsoft Access MVP

Paul said:
I am not sure I understand why I need to repair the database since I have
Click to expand...
no porblems opening and accessing the data. My issue is simply that unless
the current user is member of Admins, he cannot compact the database since
that error message pops up. Now having said that I tried to run Jet Compact
and that fails before it evens starts, I get: "Error compacting database"
with no descriptions, I must be doing something silly??? My database is
secured and I tried to enter a password via the Tools menu but that fails as
well. Any ideas?
 
I finally got JetComp to work by re-downloading it. Regret to say that it didn't solve my problem

To restate my problem; I have a user called "owner" that has open exclusive permission on the db and not a member of Admins. When I login as "owner" and try to compact I keep getting "Could not create; no modify design permission for table or query 'TempMSysAccessObjects' "

I tried a little experiment and created a new db from scratch. I opened this new db, assigned proper permissions to "owner" and re-opened it with my original mdw file and was able to compact it. Then I returned to my original db and made "owner" member of Admins and I was able to compact. I removed "owner" from Admins, loged back in as "owner" and got the error message again when I tried to compact

Hope this summary is clear, thanks!!

----- Joan Wild wrote: ----

The user compacting the database doesn't have to be a member of the Admin
group, they just need open exclusive permission on the database object, an
they must have it opened exclusively when they compact

You may be having problems with Jetcomp because you are not specifying th
correct workgroup (and supplying a username/password). Look in the Tool
menu where you can specify the workgroup to use

However you may be able to overcome the problem by just compacting using
username that has open exclusive permission

--
Joan Wil
Microsoft Access MV

Paul said:
I am not sure I understand why I need to repair the database since I hav
Click to expand...
no porblems opening and accessing the data. My issue is simply that unles
the current user is member of Admins, he cannot compact the database sinc
that error message pops up. Now having said that I tried to run Jet Compac
and that fails before it evens starts, I get: "Error compacting database
with no descriptions, I must be doing something silly??? My database i
secured and I tried to enter a password via the Tools menu but that fails a
well. Any ideas
 
Your experiment proves that the problem is with the mdb file, since you were
able to compact as 'owner' the new mdb.

I would create a new mdb and import all objects from your mdb.

You can use the dbUtilities at
http://www.daiglenet.com/MSAccess.htm
to script out your permissions and reapply in the new mdb.

--
Joan Wild
Microsoft Access MVP

Paul said:
I finally got JetComp to work by re-downloading it. Regret to say that it didn't solve my problem.

To restate my problem; I have a user called "owner" that has open
Click to expand...
exclusive permission on the db and not a member of Admins. When I login as
"owner" and try to compact I keep getting "Could not create; no modify
design permission for table or query 'TempMSysAccessObjects' "
I tried a little experiment and created a new db from scratch. I opened
Click to expand...
this new db, assigned proper permissions to "owner" and re-opened it with my
original mdw file and was able to compact it. Then I returned to my original
db and made "owner" member of Admins and I was able to compact. I removed
"owner" from Admins, loged back in as "owner" and got the error message
again when I tried to compact.
 
Joan just to follow up on this issue. I spent most of the weekend on this, long story short, I followed your advice and imported my objects into a new db and that seems to have cleared up my problem. It was tedious to reset permissions manually since that script didn't work for me. One thing of note however, my db was approx. 30 Mbytes and after this exercise it is 7 Mbytes. Should I be concerned about this

In any case thank you very much for following this through with me, I could not have done this alone

Pau

----- Joan Wild wrote: ----

Your experiment proves that the problem is with the mdb file, since you wer
able to compact as 'owner' the new mdb

I would create a new mdb and import all objects from your mdb

You can use the dbUtilities a
http://www.daiglenet.com/MSAccess.ht
to script out your permissions and reapply in the new mdb

--
Joan Wil
Microsoft Access MV

Paul said:
I finally got JetComp to work by re-downloading it. Regret to say that i didn't solve my problem
Click to expand...
exclusive permission on the db and not a member of Admins. When I login a
"owner" and try to compact I keep getting "Could not create; no modif
design permission for table or query 'TempMSysAccessObjects'this new db, assigned proper permissions to "owner" and re-opened it with m
original mdw file and was able to compact it. Then I returned to my origina
db and made "owner" member of Admins and I was able to compact. I remove
"owner" from Admins, loged back in as "owner" and got the error messag
again when I tried to compact
 
Paul said:
Joan just to follow up on this issue. I spent most of the weekend on
Click to expand...
this, long story short, I followed your advice and imported my objects into
a new db and that seems to have cleared up my problem. It was tedious to
reset permissions manually since that script didn't work for me. One thing
of note however, my db was approx. 30 Mbytes and after this exercise it is 7
Mbytes. Should I be concerned about this?

Not necessarily, given that you weren't able to compact before. Does all
your data appear to be there?
 
Back
Top