2003 mdb in Windows 7

  • Thread starter Thread starter Charlie Lou
  • Start date Start date
C

Charlie Lou

We have a new computer with new Windows 7. For some reason, I am unable to
open one of the databases I created. I click on the shortcut icon and
nothing happens. The strange thing is, when I go into the folder, I see that
the .ldb file has been created. But, the database has not opened. The
database files are on a network. Also, I have another database program that
opens up fine.

Access 2003 database in Windows 7
 
Try deleting the .ldb file. If you can't do that, then see if your system
administrator can kill the file.
 
Been a long time Lynn (Hungarian Office newsgroup George Moldova). Hope all is well
with you. Notice that no more title.
 
Charlie Lou said:
We have a new computer with new Windows 7. For some reason, I am unable to
open one of the databases I created. I click on the shortcut icon and
nothing happens. The strange thing is, when I go into the folder, I see that
the .ldb file has been created. But, the database has not opened. The
database files are on a network. Also, I have another database program that
opens up fine.
Click to expand...

You may have a hidden copy of Access running on your system. Exit all
your copies of Access and run taskmgr and see if there are any
msaccess.exe's in the processes screen. Or run Microsoft Office
Application Recovery.

Tony


--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
Thank you for your response. I wasn't able to resolve my issue. I was able
to delete the .ldb file, but it would just do the same thing again on
opening. Wasn't able to 'see' the database, even though the .ldb was
created. My solution was to take a backup copy of the database and that one
worked. So, I don't know... ??

Another problem I have had in opening a database report in Win7 is that I
get a "#Error" in a field that previously worked, and still works on WinXP
machines.

The field control source is "=Left([LAST/COMPANY],1)"

(I am asking it to print the first initial of the person's last name).

I don't know if you can help me -- I will repost if I don't get a reply so
that my question subject is updated. Thanks again!
 
Charlie Lou said:
Another problem I have had in opening a database report in Win7 is that I
get a "#Error" in a field that previously worked, and still works on WinXP
machines.
Click to expand...

That sounds like a references problem. Run the following code and
paste back the results.

Sub ViewReferenceDetails()

Dim ref As Reference

For Each ref In Access.References
Debug.Print ref.Name & " - " & ref.Major & "." & ref.Minor & "
- " & ref.FullPath
Next ref

End Sub

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
wangdong said:
Check your mdb files first. I think you can try a utility called
Advanced PDF Repair to repair your PDF file. It works rather well for
my corrupt PDF files. Its web address is http://www.datanumen.com/apdfr/
Click to expand...

1) You are an employee of such a company

2) You should be disclosing that fact more openly.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
Back
Top