Can not repair

[David B]

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

Repair Database

He got a message about already in use on machine Matthew.

Any thoughts ?
TIA
David B

[Peter Miller]

David,

On Thu, 26 Feb 2004 20:19:20 -0000, "David B"
<Da***@marleycotenospam.fsnet.co.uk> wrote in
comp.databases.ms-access:

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

Repair Database

He got a message about already in use on machine Matthew.

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]

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" <Da***@marleycotenospam.fsnet.co.uk> wrote in message
news:c1**********@news7.svr.pol.co.uk...

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

Repair Database

He got a message about already in use on machine Matthew.

Any thoughts ?
TIA
David B

[David B]

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 <pm*****@pksolutions.com> wrote in message
news:u3********************************@4ax.com...

David,

On Thu, 26 Feb 2004 20:19:20 -0000, "David B"
<Da***@marleycotenospam.fsnet.co.uk> wrote in
comp.databases.ms-access:

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

Repair Database

He got a message about already in use on machine Matthew.

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

[Pavel Romashkin]

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:

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 <pm*****@pksolutions.com> wrote in message
news:u3********************************@4ax.com...

David,

On Thu, 26 Feb 2004 20:19:20 -0000, "David B"
<Da***@marleycotenospam.fsnet.co.uk> wrote in
comp.databases.ms-access:

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> Repair Database

He got a message about already in use on machine Matthew.

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

[Peter Miller]

On Thu, 26 Feb 2004 21:05:43 -0000, "David B"
<Da***@marleycotenospam.fsnet.co.uk> wrote in
comp.databases.ms-access:

Thanks for the reply.
No problem.
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.
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...
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.
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.
You say rename the file, is that fe or be you mean ?
David B

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]

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" <Da***@marleycotenospam.fsnet.co.uk> wrote in message news:<c1**********@news7.svr.pol.co.uk>...

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

Repair Database

He got a message about already in use on machine Matthew.

Any thoughts ?
TIA
David B

[Barry Edmund Wright]

Great response Roger!

"Roger" <le*********@natpro.com> wrote in message news:8c**************************@posting.google.c om...
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" <Da***@marleycotenospam.fsnet.co.uk> wrote in message news:<c1**********@news7.svr.pol.co.uk>...

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

Repair Database

He got a message about already in use on machine Matthew.

Any thoughts ?
TIA
David B

[David B]

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

Roger <le*********@natpro.com> wrote in message
news:8c**************************@posting.google.c om...

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" <Da***@marleycotenospam.fsnet.co.uk> wrote in message

news:<c1**********@news7.svr.pol.co.uk>...

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

Repair Database

He got a message about already in use on machine Matthew.

Any thoughts ?
TIA
David B

[Tony Toews]

"David B" <Da***@marleycotenospam.fsnet.co.uk> wrote:

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

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
http://www.granite.ab.ca/accsmstr.htm

[Roger]

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" <Da***@marleycotenospam.fsnet.co.uk> wrote in message news:<c1**********@news7.svr.pol.co.uk>...

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

Roger <le*********@natpro.com> wrote in message
news:8c**************************@posting.google.c om...

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" <Da***@marleycotenospam.fsnet.co.uk> wrote in message

news:<c1**********@news7.svr.pol.co.uk>...

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 > Repair Database

He got a message about already in use on machine Matthew.

Any thoughts ?
TIA
David B