Can not repair

**Peter Miller** · Nov 12 '05, 08:58 PM

Re: Can not repair

David,

On Thu, 26 Feb 2004 20:19:20 -0000, "David B"
<David@marleyco tenospam.fsnet. co.uk> wrote in
comp.databases. ms-access:
[color=blue]
>Have a user reporting some problems with my app on WinXP home edition + O97
>
>Talking him through a few things on the phone I tried Tools > Database Utilities[color=green]
>> Repair Database[/color]
>
>He got a message about already in use on machine Matthew.[/color]

More info would be nice. Is your user 'Matthew', for instance, or is
that machine unknown or known to be elsewhere? I infer from the fact
that your user is using WinXP Home Edition that it may well be a
stand-alone machine, and as such, he may indeed be Matthew, but it
would be nice to know for sure.

A database can appear to be locked by another user if a session fails.
Sometimes, if repair fails, renaming the file, or moving it to a
different folder can help. Also, if all known users are out of the
file, but the tiny ldb companion file is still present, it can be
deleted and then then mdb checked again.

Peter Miller
_______________ _______________ _______________ _______________
PK Solutions -- Data Recovery for Microsoft Access/Jet/SQL
Free quotes, Guaranteed lowest prices and best results
www.pksolutions.com 1.866.FILE.FIX 1.760.476.9051

**Barry Edmund Wright** · Nov 12 '05, 08:58 PM

Re: Can not repair

Sounds like the database is locked, i.e., the *.ldb file exists. This needs
to be deleted and to do it he may have to first reboot.

"David B" <David@marleyco tenospam.fsnet. co.uk> wrote in message
news:c1lkpq$uvt $1@news7.svr.po l.co.uk...[color=blue]
> Have a user reporting some problems with my app on WinXP home edition +[/color]
O97[color=blue]
>
> Talking him through a few things on the phone I tried Tools > Database[/color]
Utilities[color=blue][color=green]
> > Repair Database[/color]
>
> He got a message about already in use on machine Matthew.
>
> Any thoughts ?
> TIA
> David B
>[/color]

**David B** · Nov 12 '05, 08:58 PM

Re: Can not repair

Thanks for the reply.
Trouble is I`m 50 miles from this user who happens to be not the best at
describing what is happening.
He has been using my system on a pc and has just bought a laptop and has
transfered across to that.
Suspect part of the prob is he has not got his head round the wonders of XP. It
was my fault that XP opened with no icons on the desktop !! A quick search
revealed this is an XP thing.
It`s a single user set up. He is matthew but he says there is no log in at
start up so he is not sure who the machine thinks he is.
You say rename the file, is that fe or be you mean ?
David B

Peter Miller <pmiller@pksolu tions.com> wrote in message
news:u3ms30ll54 oe901jcdgpv9lmc bnpgmuqfa@4ax.c om...[color=blue]
>
> David,
>
> On Thu, 26 Feb 2004 20:19:20 -0000, "David B"
> <David@marleyco tenospam.fsnet. co.uk> wrote in
> comp.databases. ms-access:
>[color=green]
> >Have a user reporting some problems with my app on WinXP home edition + O97
> >
> >Talking him through a few things on the phone I tried Tools > Database[/color][/color]
Utilities[color=blue][color=green][color=darkred]
> >> Repair Database[/color]
> >
> >He got a message about already in use on machine Matthew.[/color]
>
> More info would be nice. Is your user 'Matthew', for instance, or is
> that machine unknown or known to be elsewhere? I infer from the fact
> that your user is using WinXP Home Edition that it may well be a
> stand-alone machine, and as such, he may indeed be Matthew, but it
> would be nice to know for sure.
>
> A database can appear to be locked by another user if a session fails.
> Sometimes, if repair fails, renaming the file, or moving it to a
> different folder can help. Also, if all known users are out of the
> file, but the tiny ldb companion file is still present, it can be
> deleted and then then mdb checked again.
>
> Peter Miller
> _______________ _______________ _______________ _______________
> PK Solutions -- Data Recovery for Microsoft Access/Jet/SQL
> Free quotes, Guaranteed lowest prices and best results
> www.pksolutions.com 1.866.FILE.FIX 1.760.476.9051[/color]

**Pavel Romashkin** · Nov 12 '05, 08:58 PM

Re: Can not repair

I have just yesterday fought this (on W2k). My db was in use by the
system account twice. I am not sure how that happens, but I traced it to
a call to open an external database to run a query in. I closed the
connection, undefined all objects and everything. I gave up in the end
and removed the opening of the external db, carried out the entire
update to it in SQL. No idea what it was.
50 miles is just an hour drive. Might be easiest to do it instead of
guessing. If you tell him to rename files, delete ldb etc, you never
know what he will rename and delete.
Pavel

David B wrote:[color=blue]
>
> Thanks for the reply.
> Trouble is I`m 50 miles from this user who happens to be not the best at
> describing what is happening.
> He has been using my system on a pc and has just bought a laptop and has
> transfered across to that.
> Suspect part of the prob is he has not got his head round the wonders of XP. It
> was my fault that XP opened with no icons on the desktop !! A quick search
> revealed this is an XP thing.
> It`s a single user set up. He is matthew but he says there is no log in at
> start up so he is not sure who the machine thinks he is.
> You say rename the file, is that fe or be you mean ?
> David B
>
> Peter Miller <pmiller@pksolu tions.com> wrote in message
> news:u3ms30ll54 oe901jcdgpv9lmc bnpgmuqfa@4ax.c om...[color=green]
> >
> > David,
> >
> > On Thu, 26 Feb 2004 20:19:20 -0000, "David B"
> > <David@marleyco tenospam.fsnet. co.uk> wrote in
> > comp.databases. ms-access:
> >[color=darkred]
> > >Have a user reporting some problems with my app on WinXP home edition + O97
> > >
> > >Talking him through a few things on the phone I tried Tools > Database[/color][/color]
> Utilities[color=green][color=darkred]
> > >> Repair Database
> > >
> > >He got a message about already in use on machine Matthew.[/color]
> >
> > More info would be nice. Is your user 'Matthew', for instance, or is
> > that machine unknown or known to be elsewhere? I infer from the fact
> > that your user is using WinXP Home Edition that it may well be a
> > stand-alone machine, and as such, he may indeed be Matthew, but it
> > would be nice to know for sure.
> >
> > A database can appear to be locked by another user if a session fails.
> > Sometimes, if repair fails, renaming the file, or moving it to a
> > different folder can help. Also, if all known users are out of the
> > file, but the tiny ldb companion file is still present, it can be
> > deleted and then then mdb checked again.
> >
> > Peter Miller
> > _______________ _______________ _______________ _______________
> > PK Solutions -- Data Recovery for Microsoft Access/Jet/SQL
> > Free quotes, Guaranteed lowest prices and best results
> > www.pksolutions.com 1.866.FILE.FIX 1.760.476.9051[/color][/color]

**Peter Miller** · Nov 12 '05, 08:58 PM

Re: Can not repair

On Thu, 26 Feb 2004 21:05:43 -0000, "David B"
<David@marleyco tenospam.fsnet. co.uk> wrote in
comp.databases. ms-access:
[color=blue]
>Thanks for the reply.[/color]

No problem.
[color=blue]
>Trouble is I`m 50 miles from this user who happens to be not the best at
>describing what is happening.
>He has been using my system on a pc and has just bought a laptop and has
>transfered across to that.
>Suspect part of the prob is he has not got his head round the wonders of XP.[/color]

If you are working remotely and your user is clueless, as Pavel says,
telling them to delete ldb files, rename other files, etc, may all
backfire badly...
[color=blue]
>It`s a single user set up. He is matthew but he says there is no log in at
>start up so he is not sure who the machine thinks he is.[/color]

The 'MATTHEW' in the error message relates to his Windows user (and
machine) name and not his Access login. The two are unrelated in
Access.
[color=blue]
>You say rename the file, is that fe or be you mean ?
>David B[/color]

Well, um, its the corrupted file. You didn't mention which file was
corrupted, but my comments refer to the corrupt file. If a fe/be
setup, you can easily tell which it is by simply attempting to open
the be directly. If it is fine, but you can't open the fe, the fe is
corrupt. If you can't open the be, then the be is corrupt, and most
likely, the fe is fine, and only shows problems because of the be
corruption.

Peter Miller
_______________ _______________ _______________ _______________
PK Solutions -- Data Recovery for Microsoft Access/Jet/SQL
Free quotes, Guaranteed lowest prices and best results
www.pksolutions.com 1.866.FILE.FIX 1.760.476.9051

**Roger** · Nov 12 '05, 08:59 PM

Re: Can not repair

if he's got xp and you've got xp
having him go to
computer properties -> remote -> allow users to connect remotely

then start -> run -> cmd -> ipconfig

then you go to start -> programs -> accessories -> communications ->
remote desktop connection

and now you've 'driven' 50 miles and you can solve the problem

"David B" <David@marleyco tenospam.fsnet. co.uk> wrote in message news:<c1lkpq$uv t$1@news7.svr.p ol.co.uk>...[color=blue]
> Have a user reporting some problems with my app on WinXP home edition + O97
>
> Talking him through a few things on the phone I tried Tools > Database Utilities[color=green]
> > Repair Database[/color]
>
> He got a message about already in use on machine Matthew.
>
> Any thoughts ?
> TIA
> David B[/color]

**Barry Edmund Wright** · Nov 12 '05, 08:59 PM

Re: Can not repair

Great response Roger!

"Roger" <lesperancer@na tpro.com> wrote in message news:8c7a509f.0 402270403.10f04 e09@posting.goo gle.com...
if he's got xp and you've got xp
having him go to
computer properties -> remote -> allow users to connect remotely

then start -> run -> cmd -> ipconfig

then you go to start -> programs -> accessories -> communications ->
remote desktop connection

and now you've 'driven' 50 miles and you can solve the problem

"David B" <David@marleyco tenospam.fsnet. co.uk> wrote in message news:<c1lkpq$uv t$1@news7.svr.p ol.co.uk>...[color=blue]
> Have a user reporting some problems with my app on WinXP home edition + O97
>
> Talking him through a few things on the phone I tried Tools > Database Utilities[color=green]
> > Repair Database[/color]
>
> He got a message about already in use on machine Matthew.
>
> Any thoughts ?
> TIA
> David B[/color]

**David B** · Nov 12 '05, 08:59 PM

Re: Can not repair

Prob is I havn`t got XP
Is that a good enough reason to u/g to,it ?
DB

Roger <lesperancer@na tpro.com> wrote in message
news:8c7a509f.0 402270403.10f04 e09@posting.goo gle.com...[color=blue]
> if he's got xp and you've got xp
> having him go to
> computer properties -> remote -> allow users to connect remotely
>
> then start -> run -> cmd -> ipconfig
>
> then you go to start -> programs -> accessories -> communications ->
> remote desktop connection
>
> and now you've 'driven' 50 miles and you can solve the problem
>
> "David B" <David@marleyco tenospam.fsnet. co.uk> wrote in message[/color]
news:<c1lkpq$uv t$1@news7.svr.p ol.co.uk>...[color=blue][color=green]
> > Have a user reporting some problems with my app on WinXP home edition + O97
> >
> > Talking him through a few things on the phone I tried Tools > Database[/color][/color]
Utilities[color=blue][color=green][color=darkred]
> > > Repair Database[/color]
> >
> > He got a message about already in use on machine Matthew.
> >
> > Any thoughts ?
> > TIA
> > David B[/color][/color]

**Tony Toews** · Nov 12 '05, 09:00 PM

Re: Can not repair

"David B" <David@marleyco tenospam.fsnet. co.uk> wrote:
[color=blue]
>Prob is I havn`t got XP
>Is that a good enough reason to u/g to,it ?[/color]

VNC also works.quite well. And it's free. http://www.realvnc.com/

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at

Tony's Main Microsoft Access Page

http://www.granite.ab.ca/accsmstr.htm

Tony's Microsoft Access Hint's, Tips and FAQ

**Roger** · Nov 12 '05, 09:00 PM

Re: Can not repair

do you have 'terminal server client' from an earlier windows OS...
that will connect to an XP remote desktop too..

XP pro upgrade is $300 cdn ... is that worth not having to drive 50 miles ?

"David B" <David@marleyco tenospam.fsnet. co.uk> wrote in message news:<c1nmg7$al b$1@news7.svr.p ol.co.uk>...[color=blue]
> Prob is I havn`t got XP
> Is that a good enough reason to u/g to,it ?
> DB
>
> Roger <lesperancer@na tpro.com> wrote in message
> news:8c7a509f.0 402270403.10f04 e09@posting.goo gle.com...[color=green]
> > if he's got xp and you've got xp
> > having him go to
> > computer properties -> remote -> allow users to connect remotely
> >
> > then start -> run -> cmd -> ipconfig
> >
> > then you go to start -> programs -> accessories -> communications ->
> > remote desktop connection
> >
> > and now you've 'driven' 50 miles and you can solve the problem
> >
> > "David B" <David@marleyco tenospam.fsnet. co.uk> wrote in message[/color]
> news:<c1lkpq$uv t$1@news7.svr.p ol.co.uk>...[color=green][color=darkred]
> > > Have a user reporting some problems with my app on WinXP home edition + O97
> > >
> > > Talking him through a few things on the phone I tried Tools > Database[/color][/color]
> Utilities[color=green][color=darkred]
> > > > Repair Database
> > >
> > > He got a message about already in use on machine Matthew.
> > >
> > > Any thoughts ?
> > > TIA
> > > David B[/color][/color][/color]

Can not repair

Can not repair

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment