![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
![]() |
Sun, Jun 2 2013 5:56 PM | Permanent Link |
Owen | 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. |
Tue, Jun 4 2013 3:04 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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] |
Tue, Jun 4 2013 9:22 AM | Permanent Link |
Raul ![]() | 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 |
Tue, Jun 4 2013 6:03 PM | Permanent Link |
Owen | 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.
|
This web page was last updated on Monday, May 6, 2024 at 03:23 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |