471,573 Members | 1,367 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,573 software developers and data experts.

Access 2003 Error Distributing .mdb


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

Feb 27 '06 #1
2 1406
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.

Feb 28 '06 #2
"richp" <rp*******@mcpheters.com> wrote in
news:11**********************@e56g2000cwe.googlegr oups.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/
Feb 28 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Colin Chudyk | last post: by
26 posts views Thread by Dragon | last post: by
7 posts views Thread by Ian Davies | last post: by
52 posts views Thread by Neil | last post: by
5 posts views Thread by Prakash | last post: by
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by lumer26 | last post: by
reply views Thread by Vinnie | last post: by
reply views Thread by lumer26 | last post: by
reply views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.