When I test the connection it says "connection succeeded". But when I try to open the database it says "Can't open a database made by an earlier version of Visual Basic". Could that be the cause? If so how can I convert a database of an earlier version to a VB6 one?
I have been having the exact same problem... it's frustrating as ****:banghead:. So today I googled the issue (again) and found this article from MS (knowledge base article 160907 - Mastering Series: Run Time Error 3043 Disk or Network Error)....I honestly do not know if this solution will work, but it's worth a try. It says to create a Temp folder in C
Thank you very much for your reaction. This error 3043 is a very irritant error with an even irritant explanation by Microsoft, namely no explanation, only a meaningless phrase which is no answer a normal person can understand.
I will let you know if it worked for me.