Copying DB

[Dnd]

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!

[Sam_Cheung]

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

Sam

[Dnd]

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...

[Vikktor]

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.

[John G Duffy]

What are you using to try to copy the DB?

John G