Prev: MS SQL has (nolock) - Access?
Next: Run a macro on a specific date - JCW
From: lwidjaya on 9 Apr 2010 19:49
We developed modules using MS Access 97 in a server. A query using Dsum works
fine in this server but when we ran it in another PC, it gave me #error. I
checked the references and all files are in both PCs.
What's wrong with the query?
From: kc-mass on 9 Apr 2010 22:55
Hi,

You'll want to load the text of the query and describe the tables involved
to the group.

You should also check the update status of your various Access
installations.

Look for the version number and SP # for each by picking the menu at "Help",
About Microsoft Office Access.

Regards

Kevin


"lwidjaya" <lwidjaya(a)discussions.microsoft.com> wrote in message
news:CB664EAB-A806-4008-9E6E-B6C4473BED87(a)microsoft.com...
> We developed modules using MS Access 97 in a server. A query using Dsum
> works
> fine in this server but when we ran it in another PC, it gave me #error. I
> checked the references and all files are in both PCs.
> What's wrong with the query?


 | 
Pages: 1
Prev: MS SQL has (nolock) - Access?
Next: Run a macro on a specific date - JCW