Expression typed incorrectly after move to new server

  • Thread starter Thread starter Ned
  • Start date Start date
N

Ned

Sorry for the cross post but don't know if this is an Access or server
problem......

I just moved an Access 97 database from an old WinNT4 server to a new
Win2003 SBS server. Now when I run some of the queries on the new server
(using the same client computer WinXP Pro) I get the message "This
expression is typed incorrectly, or it's too complex to be evaluated." Many
other queries work fine after the move.

In the background I can see the first page of results (which look fine), but
then in a couple of seconds the message box appears, when I click OK, the
results change to #Name? in the result fields.

It kind of feels like a network/performance issue; but I don't really know
where to start tracking it down...............

Any help or pointers would be greatly appreciated (I know I should convert
it to SQL server, but need to make the server transition before I tackle
that.)

Ned Desmond
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expression typed incorrect or too complicated 6
Moving shared folders from old server to new server 0
Expression is typed...... 2
SQL Server not recognizing aliased table 3
Expression typed incorrectly ... 8
The expression is typed incorrectly or it is too complex to be evaluated 4
need help with expression 4
ACCESS query expression that works on one computer but not another 4

Back
Top