Problem using expressions on Access 97/XP Pro

#1

Hi there,

I recently installed a new machine for one of my users which is
running XP Pro SP2 with Office 97. He has come to me this morning with
a couple of problems he is getting when using Access.

The first was that it wouldn't give him the option to import Excel
files, but I found out that re-registering some dll's solved that, but
he is still getting a problem when trying to build a query. As I'm no
Access expert I thought I'd seek some help from anyone who might have
an answer :-)

I got him to e-mail me the problem which is pasted below:

Quote:

My other problem was within Access, when I use a simple expression
in a query.

When I run the query, I am told of a "compile error in expression " which
is Error number 3075.

In this case the the expression was Left([tblImportCredits]![SEASON],2).
As a doublecheck I used the expression builder to make sure I hadn't made
a mistake.

The same error occurs in when i use many other expressions like int, iff,
isnull etc.

Can you find out? It may be that the solution is similar to your last one.

Any ideas? I have made sure he has the Data Access addon installed as
well as the SR2 service pack, but he is still getting the problem. Do
any other dll's need to be re-registered?

--
Stuart

#2

Hi:

I would uninstall and then reinstall '97.
I believe there are more DLLs that are not being found.
Assuming he's got the CDs you would be better off with a reinstall and
get all of them fixed. Even if I could tell you which DLLs to
register, you could very well have a similar problem next week.

Good luck

Ira Solomon

On Wed, 15 Jun 2005 10:52:17 +0100, The Fold
<thefoldNO (AT) SPAMntlworld (DOT) com> wrote:

Quote:

Hi there,

I recently installed a new machine for one of my users which is
running XP Pro SP2 with Office 97. He has come to me this morning with
a couple of problems he is getting when using Access.

The first was that it wouldn't give him the option to import Excel
files, but I found out that re-registering some dll's solved that, but
he is still getting a problem when trying to build a query. As I'm no
Access expert I thought I'd seek some help from anyone who might have
an answer :-)

I got him to e-mail me the problem which is pasted below:

My other problem was within Access, when I use a simple expression
in a query.

When I run the query, I am told of a "compile error in expression " which
is Error number 3075.

In this case the the expression was Left([tblImportCredits]![SEASON],2).
As a doublecheck I used the expression builder to make sure I hadn't made
a mistake.

The same error occurs in when i use many other expressions like int, iff,
isnull etc.

Can you find out? It may be that the solution is similar to your last one.

Any ideas? I have made sure he has the Data Access addon installed as
well as the SR2 service pack, but he is still getting the problem. Do
any other dll's need to be re-registered?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Problem using expressions on Access 97/XP Pro

comp.database.ms-access comp.database.ms-access

Problem using expressions on Access 97/XP Pro - 06-15-2005 , 04:52 AM

Re: Problem using expressions on Access 97/XP Pro - 06-15-2005 , 08:14 AM