error 3024

[Watermelon]

I have a really perplexing problem.

Everytime I run this query:

" UPDATE [Assembly].[Catalog], [Assembly].[CatalogPage] SET Assembly.CatalogPage = Assembly.CatalogPage + 2 WHERE ([Assembly].[Catalog])= " & cboCatalog & " AND ([Assembly].[CatalogPage])>= " & StartingPage

I get this message:

"run time error 3024, can not find file C:\Window|Profiles\Tom\MyDocuments\Assembly.mdb."

Does anyone know why this is happening? I've never seen anything like this before. I'm trying to run the query from a form if that helps.

Thanks,
watermelon

 

[GingerR]

is Assembly.mdb the name of the file you are currently in?

if not, i'm guessing you've checked and the db is really on your c:\ drive? are you linking to tables in that database?

 

[tlbroadbent]

The query syntax is incorrect. Update the table only and set the columns.

UPDATE Assembly
SET Assembly.CatalogPage = Assembly.CatalogPage + 2
WHERE ([Assembly].[Catalog])= " & cboCatalog & "
AND ([Assembly].[CatalogPage])>= " & StartingPage Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[Watermelon]

Hi tlbroadbent,

Thanks a lot! You were right!

Watermelon