Question Error 2486 - Stops in same place

[new_2_prog]

I have a module that runs when a command button is clicked it essentially deletes tables, imports tables (don't have them linked because MAS200 even though you tell it to remember the login and password when linking still asks you to enter it when using the table in any way), then I have queries that run to make tables, update tables.
I have determined it deletes tables and imports them fine but when it comes to running the queries I get the run time error 2486 then I will comment that one query out and it does it for all queries.
This issue is at the server.
Now if I access the database off the server from my desktop and run the command it works fine, problem is I want to schedule a nightly task on the server but if it won't run on the server then every day I have to manually update it.

ANY insight?

Thanks!!!!

 

[Fifty2One]

You need to check your open database connectivity permissions for reading writing to the database. RunTime Error 2486 is related to ODBC and not being able to reach a valid datasource.