473,216 Members | 2,013 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,216 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 1469
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Colin Chudyk | last post by:
Hi, Here is my situation. Can anyone provide insight? I have developed a database in Access 2002. I am planning to distribute it as a split MDE (front) / MDB (back) to be used by the Access...
3
by: Colin Chudyk | last post by:
Hi, Here is my situation. Can anyone provide insight? I have developed a database in Access 2002. I am planning to distribute it as a split MDE (front) / MDB (back) to be used by the Access...
26
by: Dragon | last post by:
I have an Access 2003 .mde sitting on an SQL Server. The tables for the application also sit on the Server. I'm having a problem with ODBC on only one of about 10 machines. All the other machines...
4
by: Aliza Klein | last post by:
Apologies in advance as I am SURE this has been asked 100 times - but I haven't got a simple answer: I have MS Office XP Developer and have created an installation package (with the runtime) for...
7
by: Ian Davies | last post by:
Is the runtime version of Access for distribution, that is available with the developer extensions a fully functional version of Access apart from the ability to create, edit and code a database? I...
52
by: Neil | last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server...
7
by: wazdakka | last post by:
I'm confused about what is necessary to distribute an Access 2003 application to people that don't have MS Access (or don't have the right version) installed on their PCs. I have done some...
5
by: Prakash | last post by:
I am developing an HR package under Access 2003 for a client but do not want to give him the source code. I understand that under these circumstances I would need to compile my package, thus...
3
by: Paul H | last post by:
Most of my projects are developed in Access 2003. I have not even installed Office 2007 yet! I need to buy VSTO to get the run-time licence for Access 2003. No doubt I will soon need a run-time...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...

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.