Microsoft Access Password ???

Dear Friends,

When I am trying to choose a database file using crystal report I was asking to enter the Microsoft Access Password to enter. Actually there is no password set for this database. What is the problem? Please help.

I am using Data File Button (not SQL/ODBC) Button to show path.


Seema_S

What version of CR and Access? If you just accept a blank password does it go away?

Quote:

---

Originally Posted by RobDog888

What version of CR and Access? If you just accept a blank password does it go away?

---

No, it doesn't work when I accept the blank password. Just it shows the attached errors.

Ok, sounds like either the DB is corrupt (check by manually opening. If it opens fine then no) or your using the wrong connectionstring or driver.

Quote:

---

Originally Posted by RobDog888

Ok, or your using the wrong connectionstring or driver.

---

Quote:

---

Originally Posted by RobDog888

sounds like either the DB is corrupt (check by manually opening)

---

Manually it works fine.

[/QUOTE]your using the wrong connectionstring or driver.[/QUOTE]

How can I check this?

What version of CR are you running?

Quote:

---

Originally Posted by RobDog888

Ok, sounds like either the DB is corrupt (check by manually opening. If it opens fine then no) or your using the wrong connectionstring or driver.

---

Full information is available in THREAD # 3 (JPG File contains all the details.

Ah, so it is. Version 4.6 ouch. Does it work on any other Access db you have?

Quote:

---

Originally Posted by RobDog888

Ah, so it is. Version 4.6 ouch. Does it work on any other Access db you have?

---

Yes, it works with Access 97. And doesn't ask for password also.

But the reason it asks for passwords is that it probably doesnt recognize the 2000 format.