Re: JRO Compact/Repair not working anymore

Hey Bob,

I still have the problem.
It doesn't look like it's permission problems.
Anyways, thanks for your help.

Kucho

Kucho wrote:
Hi Bob,

Thanks for the answer.
I've checked the permissions and everything but the ownership (which I
changed then) is similar to the other places where my application
successfully runs.
I'll need to wait till the next cycle in order to know if it will make
a difference or not.

Thanks again

Kucho

Bob Barrows [MVP] wrote:
Under which user account context is the JRO running? That user account
requires Modify permissions for the folder containing the database in
order for multi-user activity to occur.

Can you open the database in Access and compact it?

Kucho wrote:
Hi Victor,

Thanks for your answer.
Actually, I'm doing thatalready even though there's no ldb file when
I'm trying to compact/repair.
I did some tests already and I'm sure the database was not in use and
still I got the message.


Thanks

Kucho

Victor Koch (arroba punto punto punto) wrote:
Hi Kucho

Search and erase *.ldb file if exist.

--
Víctor Koch.


"Kucho" <marco_lima@xxxxxxxxxxx> escribió en el mensaje
news:1156782549.106644.287150@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi there,

I use the JRO to run a Compact/Repair on one my databases.
It was working fine but now I can't run the process anymore
because the database shows as already opened, even though
I'm 100% sure it's closed and it can be open to perform the
Compact/Repair.
I have several other databases on my network that uses the same
application and they work just fine.

Any idea on what could be preventing the application to open the
database on exclusive mode ?

Thanks

Kucho

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

.

Relevant Pages

  • Re: JRO Compact/Repair not working anymore
    ... I've checked the permissions and everything but the ownership (which I ... Can you open the database in Access and compact it? ... Victor Koch (arroba punto punto punto) wrote: ... I use the JRO to run a Compact/Repair on one my databases. ...
    (microsoft.public.data.ado)
  • Re: DB Compact causes loss of Windows file permissions
    ... You need to look at the default permissions for new files. ... Note that ldb files will also get the default permissions ... > I have an Access 2000 database program with a frontend and backend. ... The compact/repair is executed by setting the 'Compact on ...
    (microsoft.public.access.security)
  • Re: List Users Permissions down to table.column action
    ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- FIXED PROBLEMS WITH STATEMENT LEVEL PERMISSIONS GRANTING. ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- GRANT USER ACCESS TO SERVER ROLES ...
    (microsoft.public.sqlserver.security)
  • Re: User access on a company intranet
    ... Yes they need full permissions on the folder where the backend is. ... You wouldn't need to do this in your copy of the database. ... However you can toggle the shiftkey bypass from another mdb file. ... When you want to implement security, you create a new mdw file, ...
    (microsoft.public.access.security)
  • Re: Active directory corruption
    ... During an installation of PHP I accidentally changed permissions for the ... Active Directory database is unavailable because it is damaged, ... Open a command prompt and run NTDSUTIL to verify the paths for the ...
    (microsoft.public.windows.server.sbs)