I have some issues with Dataase System Utility I wonder if someone can give me some direction.

DBSRVR is running on our server.  Our database tables are on our server.  I can do backup from the server just fine.  I can look at tables, data etc.,  things seem fine.  But if I try to optimize a table, I get a 11013 Access denied error.  But it does not happen on all table.  The majority yes, but there are some tables that I can do an optimize and a repair and it works.  When I try to get into Server Administration it asks me for a userID and password.  Database System Utility does not have that.  It does have a security tab under file-options-security where you have two option, table passwords for the current local session or remove session.  I have no idea what that means.  I have tried to do the optimize and repair locally and remotely with same results.

What might be going on in that  I can optimize some tables but not all.   When the Utility is executed, what userid and password is it using?  Is there a way to fix this?  What is that security tab for and what does it mean - table passwords for the current local session.  

Owen


11013 means that the table is open elsewhere and an exclusive lock can not be acquired.

The best approach would be to shut the server down and carry out the optimisations using DBSys in local mode.

Roy Lambert [Team Elevate]

On 6/2/2013 5:56 PM, Owen wrote:
> But if I try to optimize a table, I get a 11013 Access denied error.  But it does not happen on all table.  The majority yes, but there are some tables that I can do an optimize and a repair and it works.  When I try to get into Server Administration it asks me for a userID and password.  Database System Utility does not have that.  It does have a security tab under file-options-security where you have two option, table passwords for the current local session or remove session.  I have no idea what that means.  I have tried to do the optimize and repair locally and remotely with same results.

There likely is another session that has the table open (or query
against the table(s) in question).


> When the Utility is executed, what userid and password is it using?  Is there a way to fix this?  What is that security tab for and what does it mean - table passwords for the current local session.

It's not using anything by itself and that means it's using a local
table access (not dbsrvr) which does not require login. To use dbsrvr
you need to use remote connection type and then it will prompt you for
username/password to use.

This might be related to your error when optimizing since your dbsys
clearly is using local access while maybe your app is using access thru
dbsrvr.

Security tab stores encryption passwords for encrypted table(s) - unless
you have such a table you dont need to use it.

Raul

Boy do I feel like a dummy.  I should have looked it up.  It was Sunday afternoon and I was tired and frustrated with another issue.  Sorry.