Copying DB

Background: I'm trying to copy a .mdb file to another directory after I'm finished using it. In creating the window, I've used ADO controls with a Jet 3.5 db engine.

Action: I close all my recordsets then set them to nothing.

Problem: I get an advertisement message box that indicates "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". It's just a simple message box, clicking OK makes it go away, and the file gets copied.

Request: How do I get rid of the message box???

Thanks!

Hi,
I think you'd better you API functions to copy files.

Sam

Thanks, Sam. That's where I was sort of heading, but I really don't want to go there, it I can help it. (This is the second-to-last thing to complete before going alpha test on this, and there's a short deadline).

Oh, well...

Try to set to Nothing the database itself (if defined by Set db=OpenDatabase[...]):
db.Close
set db=Nothing
then try to copy it. It might also still exist an open link to the database trying to refresh, review your code.

What are you using to try to copy the DB?

John G