Message "You entered an expression that has an invalid reference..

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JML - 26 Sep 2004 23:51 GMT

When I try to import any type of file, xls, txt, csv, etc Access gives me an
error message "You entered an expression that has an invalid reference to the
property |". I re-installed the office suite several times without success.
I am running Windows XP SP3 and MS Office 2002. Following are details about
the Access version, etc:

Application name    Microsoft Access
Version    10.0
Build    6501
Product ID    54186-OEM-1790533-06622
Application path    C:\Program Files\Microsoft Office\Office10\
Language    English (United States)
ADO version    2.7
VBA version    6.04
References    VBA, Access, stdole, ADODB
Database name    Not Available
Database path    Not Available
Database size    Not Available
Database create date    Not Available
Current user    Admin
Jet version    Not Available

thank you in advance.

Reply to this Message

John Nurick - 28 Sep 2004 06:28 GMT

Hi JML,

I suggest you try installing the latest Office 2002 service pack. If
that doesn't fix it, post back here with some more information:

Does this happen with all databases or only one?
What happens if you create a new empty database and try importing data
into that?
Which method(s) are you using to import the data?
What is the error number accompanying the error message?

>When I try to import any type of file, xls, txt, csv, etc Access gives me an
>error message "You entered an expression that has an invalid reference to the
[quoted text clipped - 19 lines]
>
>thank you in advance.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message

Debi Goehring - 04 Oct 2004 21:35 GMT

Hi ~ I am experiencing a similar problem in my access database whenever I
try to run a query that runs a report. I recently converted my database from
Office 97 to Office 2003. And I get the message " You entered an expression
that has an invalid reference to the property visible." What does this mean?
I even tried to open the unconverted 97 .mdb file and I still get the
message. It appears to be an Office 2003 problem. Does anyone know what I
need to do to fix it? Please direct me to information about this problem. I
have downloaded all the updates and services packs from the microsoft
website. It still isn't fixed.

Debi Goehring

> Hi JML,
>
[quoted text clipped - 35 lines]
>
> Please respond in the newgroup and not by email.

Reply to this Message

Chicken Pox - 30 Dec 2004 16:21 GMT

Hi,

I met with the same problem, have you any remedy so far.
This problem affects the Link Manager as well.

Reply to this Message

Chicken Pox - 30 Dec 2004 16:59 GMT

This is what I did:

1. I downloaded and run File Monitor from http://www.sysinternals.com.
2. I run the Import Data in Access
3. Then I refer to the File Monitor and realise that one file is missing dao360.dll, after I downloaded this file and copied to C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll, everything works again

I hope this works for you

Reply to this Message