Hi, all experts,

I create a VB project that use access database to store data, everything works fine.

But if I store the .mdb file in a burn CD and open the project that read .mdb from CD, I get error in line:

rs.Open strSql

The error message is:
run-time error '-21471217904(80040e10), No Value Given To One or More Required Parameters.

But if I copy the db from CD to C:/, works fine, no problem.

Can anybody told me what causes this problem? How can I solve this issue?

Thank you very much!

Hi there..

I don't know if this is the case, but access create another file (.ldb) with the same name as the database.. that could be the problem. Also, another idea is that your query needs to make the database grown, and in the CD it can't...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

What is the value of strSQL?

Gonzalo,

LDB stands for Locking, Database. .ldb files are created at the time the .mbd is accessed, but unfortunately, they are never deleted.

They are not part of the database project, and Access will create them in \Temp if the current folder is read-only.

thanks for clarify it Brian.. what about if the database needs to grown (because the query?) that's probably the problem...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========