Hi! I have to problems regarding VB6.0 and Access and some other applications...
1. I can not open a database from access.
Dim mydb1 as Database
Dim myrs1 as Recordset
Set mydb1 = OpenDatabase("MyDatabase.mdb")
Set myrs1 = mydb1.OpenRecordset("student")
The error appears on the bold text.
It says either "Unrecognized database format..." or "Couldn't find file..."
I am sure that I typed the filename properly, that it is located in the same folder as my program/project and that it is created in MS Access.
2. I can not open an application using VB6.0
My code is simply
Private Sub CmdGo_Click()
Shell Text1.Text, vbNormalFocus
The user types the path and the program runs it. The program works for all applications except one. There is a bot program in this PC and it doesn't seem to run/load when I use my VB program. The window pops for a second and then disappears. Are there limitations to which kinds/types of programs/applications VB can open/run/load? Hope you can help me. Thanks!