[Solved] Access is denied: Session is closed

Creating tables and queries

[Solved] Access is denied: Session is closed

Postby dpark29 » Sat Apr 20, 2019 7:32 pm

I copied the structure of a table to a new table and the used the Execute SQL Statement utility to change the Primary Key field of the new table to an Autovalue field. Now I cannot see any tables in the Database and when I try to run a "COMPACT SHUTDOWN" or other SQL in the Execute SQL Statement utility, I get a "Access is denied: Session is closed." message. How can I resolve this error?
Thank you.
Last edited by dpark29 on Sat Apr 20, 2019 8:47 pm, edited 1 time in total.
OpenOffice 4.01, Windows 7
dpark29
 
Posts: 14
Joined: Thu Mar 27, 2014 1:39 pm

Re: Access is denied: Session is closed

Postby Villeroy » Sat Apr 20, 2019 7:37 pm

COMPACT SHUTDOWN shuts down the database connection. Close and reopen the database document.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26728
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Access is denied: Session is closed

Postby Sliderule » Sat Apr 20, 2019 8:12 pm

Assuming you are using HSQL as your database back-end, you said you entered a command COMPACT SHUTDOWN . . . however . . . the correct command is SHUTDOWN COMPACT . NOT what you entered.

Whether there are other issues with your database, based ( pun intended ) on your limited description, I do not know.

Sliderule

Thanks to add [Solved] in your 1st post Subject (edit button top right) if this issue has been resolved.
User avatar
Sliderule
Volunteer
 
Posts: 1170
Joined: Thu Nov 29, 2007 9:46 am

Re: Access is denied: Session is closed

Postby dpark29 » Sat Apr 20, 2019 8:45 pm

AH...Entering the command correctly works much better....doesn't it! That seems to have solved the issue.

Thank you.
OpenOffice 4.01, Windows 7
dpark29
 
Posts: 14
Joined: Thu Mar 27, 2014 1:39 pm


Return to Tables & Queries

Who is online

Users browsing this forum: No registered users and 3 guests