Re: JRO Compact/Repair not working anymore

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: No search results from non-portal content
    ... Central Administration and under Server Configuration, ... Have the customer add a user account with Local Administrator ... Roles Tab check off Systems Administrator, Security Administrator, Database ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Whitepaper on win2003 DNS performance ?
    ... That sounds more of an NT4 ... I recommend anyone to use this tool who needs to estimate database size, ... (because of less attributes per user account and mail-enabled group ... So Herb, please check YOUR math. ...
    (microsoft.public.win2000.dns)
  • Re: OLEDB database connection from ASP.NET
    ... ASP.NET applications run under the user account ASPNET by default. ... permissions to your database. ... > the database in ASP. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Only one user can log in at a time problem.
    ... I have an Access database splitted into FE & BE. ... workgroup are placed in the same folder in a network drive. ... I created an user account called "mfg" ...
    (microsoft.public.access.security)
  • Re: ODBC network connection failing
    ... >> but when the ODBC setting is changed to point to a database on another ... > under a network user account, then give that user account access. ...
    (microsoft.public.data.odbc)