![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 5 of 5 total |
![]() |
Fri, May 24 2013 4:14 PM | Permanent Link |
John Taylor | New to the database server, so bear with me...
How does one empty table, alter table, etc. from DBSys, ie functions required Exclusive access ? I have DBsys open, the DBSrvr shows only one connection so I know there are no other connections, I'm getting access denied when I try to empty table, or any other function requiring Exclusive access. What have I missed ? Thanks JT |
Fri, May 24 2013 7:13 PM | Permanent Link |
Raul ![]() | As long as you're the only connection to the table it should just work -
is OK here. i can empty or alter a CS table just fine. Make sure you don't have any tables or queries open in the DBSYS when you do empty/alter - dbsys maintains a single connection to DBSRVR but you can still have multiple query/table windows active in dbsys. Same applies to make any non-CS (meaning direct file system) connections to table. Raul On 5/24/2013 4:14 PM, John Taylor wrote: > New to the database server, so bear with me... > > How does one empty table, alter table, etc. from DBSys, ie functions > required Exclusive access ? > > I have DBsys open, the DBSrvr shows only one connection so I know there > are no other connections, > I'm getting access denied when I try to empty table, or any other > function requiring Exclusive access. > > What have I missed ? > > Thanks > JT |
Sat, Jun 1 2013 11:36 AM | Permanent Link |
John Taylor | Yes, you are correct, it *should* work. But I can consistently get access
denied when the DBServer shows only 1 connected session which is DBSys. There are no other processes running that use dbisam, just the IDE and there are no active sessions within the Datamodule JT "Raul" <raul@removethis.raul.ca> wrote in message news:4D14B908-38EC-42E3-995C-8998522169C3@news.elevatesoft.com... > As long as you're the only connection to the table it should just work - > is OK here. i can empty or alter a CS table just fine. > > Make sure you don't have any tables or queries open in the DBSYS when you > do empty/alter - dbsys maintains a single connection to DBSRVR but you can > still have multiple query/table windows active in dbsys. > > Same applies to make any non-CS (meaning direct file system) connections > to table. > > Raul > > > > On 5/24/2013 4:14 PM, John Taylor wrote: >> New to the database server, so bear with me... >> >> How does one empty table, alter table, etc. from DBSys, ie functions >> required Exclusive access ? >> >> I have DBsys open, the DBSrvr shows only one connection so I know there >> are no other connections, >> I'm getting access denied when I try to empty table, or any other >> function requiring Exclusive access. >> >> What have I missed ? >> >> Thanks >> JT > |
Sat, Jun 1 2013 12:21 PM | Permanent Link |
Raul ![]() | JT
I'm not saying it should but that it works for me OK - dbisam 4.35b2. Just to simplify the issue: - close IDE to eliminate it completely - run dbsys and make sure there is only 1 query window open in dbsys (since all the dbsys windows share the single session) Are you still getting the error ? Do you have anti-virus running - any chance its locking the tables? you could use somethign like Sysinternals Process Monitor (http://technet.microsoft.com/en-us/sysinternals/bb896645) to all file access attempts against the table(s) in question just to confirm only dbsrvr is accessing the tables. Raul On 6/1/2013 11:36 AM, John Taylor wrote: > Yes, you are correct, it *should* work. But I can consistently get > access denied when the DBServer shows only 1 connected session > which is DBSys. There are no other processes running that use dbisam, > just the IDE and there are no active sessions within the > Datamodule > > JT |
Wed, Jun 12 2013 9:06 PM | Permanent Link |
Adam H. | Hi John,
Another suggestion that I'll throw forward is: 1) Close all users out of the application. 2) Stop the DBSRVR service/application. 3) delete any .lck files in the database location. (These may be hidden, so you may need to do something to deal with these first). I normally use the command prompt and execute the following in the database location attrib *.lck -r -a -s -h del *.lck /s 4) Just for good measure, reset the permissions on the directory, and set to apply to all subfolders and files. 5) Restart, and see how you go. Cheers Adam. |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |