Corrupt Database Locking??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LandesMD - 24 Aug 2006 23:59 GMT

Last week my company upgraded from Office 97 to Office 2003. Everything has
been working ok this week, but last night I was unable to update records in a
database. After looking at it today, I discovered that when I open the .ldb
file the only thing listed is "䅌䑎卅㉗K†††††††††††摁業n†††††††††††††", nothing
else. I can go to another computer and open the same file, check the .ldb
and it is as expected, username admin. What is going on???

Reply to this Message

LandesMD - 25 Aug 2006 06:32 GMT

Partially resolved, my tables are links to excel ranges wich I just found out
I can't update. Any ideas about the name in the lock file?
Thanks

> Last week my company upgraded from Office 97 to Office 2003. Everything has
> been working ok this week, but last night I was unable to update records in a
> database. After looking at it today, I discovered that when I open the .ldb
> file the only thing listed is "䅌䑎卅㉗K†††††††††††摁業n†††††††††††††", nothing
> else. I can go to another computer and open the same file, check the .ldb
> and it is as expected, username admin. What is going on???

Reply to this Message

Jerry Whittle - 25 Aug 2006 20:33 GMT

As far as the non-updateable links to Excel, MS is in a lawsuit about links
to Excel and Access and had to turn that functionality off recently. I don't
think that they went back as far as A97. Here's some info on it:

http://support.microsoft.com/kb/904953/en-us

Signature

Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> Partially resolved, my tables are links to excel ranges wich I just found out
> I can't update. Any ideas about the name in the lock file?
[quoted text clipped - 6 lines]
> > else. I can go to another computer and open the same file, check the .ldb
> > and it is as expected, username admin. What is going on???

Reply to this Message

LandesMD - 25 Aug 2006 21:44 GMT

Figured it out, for some reason Access 2003 is putting the data in the ldb
file in a different language or something. I opened the ldb file in MS Word
instead of Notepad and everything was as it should be.
Thanks

> As far as the non-updateable links to Excel, MS is in a lawsuit about links
> to Excel and Access and had to turn that functionality off recently. I don't
[quoted text clipped - 12 lines]
> > > else. I can go to another computer and open the same file, check the .ldb
> > > and it is as expected, username admin. What is going on???

Reply to this Message