Compile error. in query expression

  • Thread starter Thread starter M Fuller
  • Start date Start date
M

M Fuller

I've recently been having a problem with an Access 200
database and I can't figure out why. In a couple of
tables, I have date fields, and data is imported from tab-
delimited files on a daily basis. I have queries built
that are called by ASP pages, and they work fine. I've
gone back to some of the queries to slightly modify them,
and when I try to open them, I get an error: "Compile
error. in query expression 'Year([PostDate])'". I've
tried several Date functions on these date/time fields,
and they all give me a compile error.

I also get a compile error when trying to use
DoCmd.TransferText in a module - "Compile error: Invalid
outside procedure".

I can't figure out why these queries and modules used to
be fine, and in fact still run as stored procedures from
ASP pages, but won't open correctly in Access itself. Can
anyone give me any direction?

Thanks
 
Back
Top