Installing a program

I created a program using the Date reserved word. When I install it on another computer, it says "Can't find object librairies or modules". I installed VB to see what's the problem, and it's crashing on the line using Date. I compared and they both have the same references.

That's weird, each time I try to open a table in MS Access, it pop up an "Unknown" error. So I can't access my DB with my program.

is ms access installed on the other machine? and the same version as yours?

pete

When you say you "installed" it are you saying that you created an installation package? If not then that is what you need to do.

Quote:

---

Originally Posted by Gensor

...I installed VB to see what's the problem, and it's crashing on the line using Date. I compared and they both have the same references.

---

If the other system now has vb installed, did you also install the service pack too?
But like Martin suggested, create an installation package using the P&D Wizard or other installer program. ;)

If Date is used in a query as the name of a field, surround it with brackets [Date] and it should still work.

Quote:

---

Originally Posted by dglienna

If Date is used in a query as the name of a field, surround it with brackets [Date] and it should still work.

---

Did you read the question? How could the value of a date cause the app to crash on one PC but not another?

How about it's a bad practice, that warrants trouble?

Yes it can be considered bad practice. But you still have not explained yourself to the thread starter. Can you give us a bad example and a good example of what you're talking about, then we will all see the light and will be happy.


Woof

How about from the M$ website?

Quote:

---

Reserved words have a specific meaning to Access or to the Microsoft Jet database engine. If you use a reserved word or symbol, you may receive an error.

---

-D
DATABASE
DATE
DATETIME
DELETE
DESC
Description
DISALLOW
DISTINCT
DISTINCTROW
Document
DOUBLE
DROP

http://support.microsoft.com/kb/q286335/

And, like I said, if you have a field named as one of the reserved words, to avoid problems with the DB engine, you can simply use [ ] brackets around it, in which case the DB engine will know that it is not to be interpreted as a reserved word.

VB Code:

rsUsers.Open "SELECT [Name] [Date] FROM Users;", cnAP, adOpenDynamic, adLockPessimistic

would be better than

VB Code:

rsUsers.Open "SELECT Name Date FROM Users;", cnAP, adOpenDynamic, adLockPessimistic

Looks like your missing the point dave.

If the program was opened in the VB IDE on the target system and stepped through as the thread starter states,
it is crashing on a line containing a reference to Date. It is not stated that it is even being used in a query.
Not to mention that if that was the case then it would cause an issue on ALL systems and not just a particular one,
at least until the brackets were implemented.

Also, since the thread starter can not even open the db from Access suggests that the issue is related to
something completely different then the bracket solution. :)