2003 mdb in Windows 7

[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

 

[Lynn Trapp]

Try deleting the .ldb file. If you can't do that, then see if your system
administrator can kill the file.

 

[Peter Foldes]

Been a long time Lynn (Hungarian Office newsgroup George Moldova). Hope all is well
with you. Notice that no more title.

 

[Tony Toews [MVP]]

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.

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/

 

[Charlie Lou]

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!

 

[Tony Toews [MVP]]

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.

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]

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/

 

[Tony Toews [MVP]]

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/

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/