Hi leigh,

Welcome to VBForums.

Can you give us a bit more information? For instance, you can it crashes when running in the VB6 IDE (integrated development environment). Therefore, can you give us a snippet of code that shows us the line it's crashing on? You should be able to click "Debug" when it crashes, and then it'll show you the exact line of code that crashed.

Also, please be sure to surround any code you post with the ...

[code]
your code here
[/code]

... tags.

Also, can you tell us what type of database you're using? Is it an MDB file, an ACCDB file, or possibly an ODBC connection? If you could show us a snippet of code where the database is actually being opened, that may help as well.

Regards,
Elroy