Access 2003 Error Distributing .mdb

[richp]

I recently built an Access 2003 database on my workstation. I have a
client .mdb file with my forms/code, which links tables from an .mdb on
our server. When I copy the client .mdb to a user's workstation and
use it, the links are fine but I get an error on the following line:

Line: Me.txtWhen = Now
Error: "You can't assign a value to this object"

From what I can tell the machines have the same OS, Access version

(2003), and Jet engine. The library references are the same except
that the user's workstation has a different file version for 'Visual
Basic For Applications' (VBE6.dll 6.4.99.72)

First, is simply copying the .mdb the way to distribute the app?

Second, any ideas on why that line of code is breaking?

I'm new to Access so any help is greatly appreciated.

-rp

[Joost]

First, my answer would be yes, although it might not be the most
sophisticated way to do it.
Second, IMHO, your code breaking on that line is not related to the
first, but might be due to the fact that you already directly entered a
value in Me.txtWhen in Design View. In that case, deleting that value
should solve your problem.

[David W. Fenton]

"richp" <rp*******@mcph eters.com> wrote in
news:11******** **************@ e56g2000cwe.goo glegroups.com:

Line: Me.txtWhen = Now
Error: "You can't assign a value to this object"

Open the database, hit Ctrl-G on the keyboard, and in the VBE
window, go to the Tools menu and check REFERENCES. My bet is that
one or more will be marked MISSING. This is because it's not in a
location compatible with the other machine, or because the external
library isn't there at all.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/