Unlocking of file on server

[Guest]

Archived from groups: microsoft.public.win2000.advanced_server (More info?)

I am not a LAN administrator and I am seeking some
instructions to direct the administrator. Is there a way
to release and delete the MS Access .LDB file, thus
releasing the .MDB without having to reboot?

I have an application in MS Access 2002 split in Front End
and Back End. The back end resides on a Win 2000 server.
Occasionally, the back end .MDB has locked up with
the .LDB file remaining open.

When the .LDB file is open nothing can be done to
the .MDB, e.g Copying it or Compacting it.

The only way I know of to release the LDB and MDB files is
to reboot. That is not always convenient for a server.

many thanks

george

 

[Guest]

Archived from groups: microsoft.public.win2000.advanced_server (More info?)

You would need to determine what has the file locked, there is a sysinternals
tool that might help that will tell you what has a "handle" to an open file.

Note that this is only ONE of the reasons you shouldn't backend services to
Access. Access is a great little personal database, using it as a backend for
apps and web pages is a stretch, at the very least look at using MSDE.

--
Joe Richards Microsoft MVP Windows Server Directory Services
www.joeware.net



GeorgeMar wrote:
> I am not a LAN administrator and I am seeking some
> instructions to direct the administrator. Is there a way
> to release and delete the MS Access .LDB file, thus
> releasing the .MDB without having to reboot?
>
> I have an application in MS Access 2002 split in Front End
> and Back End. The back end resides on a Win 2000 server.
> Occasionally, the back end .MDB has locked up with
> the .LDB file remaining open.
>
> When the .LDB file is open nothing can be done to
> the .MDB, e.g Copying it or Compacting it.
>
> The only way I know of to release the LDB and MDB files is
> to reboot. That is not always convenient for a server.
>
> many thanks
>
> george
>

 

[Guest]

Archived from groups: microsoft.public.win2000.advanced_server (More info?)

Thank you Joe.

I have SQL Server 2000 Developer Edition for 5 users and
have not used it yet. A few questions if I may?
1. Is MSDE similar to the Access run-time version? Is
there any additional cost to me as the developer and to my
clients?

2. Does MSDE provide the full functionality of SQL? MS
Access run-time had some limitations placed on it so that
the users had to have the full version on their machines
for my applications to work?

3. What would my clients need to do if I migrate their
backend from MDB to MSDE?

4. Is there a site that lists the pros and cons of
migrating from Access to MSDE?

Thanks for your help
George

>-----Original Message-----
>You would need to determine what has the file locked,
there is a sysinternals
>tool that might help that will tell you what has
a "handle" to an open file.
>
>Note that this is only ONE of the reasons you shouldn't
backend services to
>Access. Access is a great little personal database, using
it as a backend for
>apps and web pages is a stretch, at the very least look
at using MSDE.
>
>--
>Joe Richards Microsoft MVP Windows Server Directory
Services
>www.joeware.net
>
>
>
>GeorgeMar wrote:
>> I am not a LAN administrator and I am seeking some
>> instructions to direct the administrator. Is there a
way
>> to release and delete the MS Access .LDB file, thus
>> releasing the .MDB without having to reboot?
>>
>> I have an application in MS Access 2002 split in Front
End
>> and Back End. The back end resides on a Win 2000
server.
>> Occasionally, the back end .MDB has locked up with
>> the .LDB file remaining open.
>>
>> When the .LDB file is open nothing can be done to
>> the .MDB, e.g Copying it or Compacting it.
>>
>> The only way I know of to release the LDB and MDB files
is
>> to reboot. That is not always convenient for a server.
>>
>> many thanks
>>
>> george
>>
>.
>

 

[Guest]

Archived from groups: microsoft.public.win2000.advanced_server (More info?)

Here are a couple of links for you to check out. Watch for URL wrapping.


http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnMSDE/html/MSDEforvs.asp?frame=true


http://msdn.microsoft.com/vstudio/downloads/addins/msde/default.aspx


http://www.teratrax.com/articles/msde_vs_sql_server.html


http://www.betav.com/Files/Content/Whitepapers/msde_files/msde.htm



--
Joe Richards Microsoft MVP Windows Server Directory Services
www.joeware.net



GeorgeMar wrote:
> Thank you Joe.
>
> I have SQL Server 2000 Developer Edition for 5 users and
> have not used it yet. A few questions if I may?
> 1. Is MSDE similar to the Access run-time version? Is
> there any additional cost to me as the developer and to my
> clients?
>
> 2. Does MSDE provide the full functionality of SQL? MS
> Access run-time had some limitations placed on it so that
> the users had to have the full version on their machines
> for my applications to work?
>
> 3. What would my clients need to do if I migrate their
> backend from MDB to MSDE?
>
> 4. Is there a site that lists the pros and cons of
> migrating from Access to MSDE?
>
> Thanks for your help
> George
>
>
>>-----Original Message-----
>>You would need to determine what has the file locked,
>
> there is a sysinternals
>
>>tool that might help that will tell you what has
>
> a "handle" to an open file.
>
>>Note that this is only ONE of the reasons you shouldn't
>
> backend services to
>
>>Access. Access is a great little personal database, using
>
> it as a backend for
>
>>apps and web pages is a stretch, at the very least look
>
> at using MSDE.
>
>>--
>>Joe Richards Microsoft MVP Windows Server Directory
>
> Services
>
>>www.joeware.net
>>
>>
>>
>>GeorgeMar wrote:
>>
>>>I am not a LAN administrator and I am seeking some
>>>instructions to direct the administrator. Is there a
>
> way
>
>>>to release and delete the MS Access .LDB file, thus
>>>releasing the .MDB without having to reboot?
>>>
>>>I have an application in MS Access 2002 split in Front
>
> End
>
>>>and Back End. The back end resides on a Win 2000
>
> server.
>
>>>Occasionally, the back end .MDB has locked up with
>>>the .LDB file remaining open.
>>>
>>>When the .LDB file is open nothing can be done to
>>>the .MDB, e.g Copying it or Compacting it.
>>>
>>>The only way I know of to release the LDB and MDB files
>
> is
>
>>>to reboot. That is not always convenient for a server.
>>>
>>>many thanks
>>>
>>>george
>>>
>>
>>.
>>