Visual Basic&database, ISAM Error???

ISAM Error???

Author	Message
Bill #1 / 4	ISAM Error??? I've recently been trying to teach myself VB 5.0(just starting with databases) and tried this piece of code Private Sub mnuFileNew_Click() Dim wk1 As Workspace Dim db1 As Data CommonDialog1.InitDir = "C:\Testdir\" CommonDialog1.ShowSave Debug.Print CommonDialog1.filename Set wk1 = DBEngine.Workspaces(0) Set db1 = wk1.CreateDatabase(CommonDialog1.filename, "dbLangGeneral") wk1.Close End Sub What I am trying to do is to Create an Access database file from a Drop down menu File-New. So I set a common dialog control on the form and made the menu. The Problem is that when ran it I get "can't find installable ISAM". What the heck is an ISAM - I cna't find this anywhere. Everyting appears to be right from the books I've been reading. My question is - has anyone had this problem before or if not does anyone know how you locate a 'installable ISAM' and what it is. Thanks for your help.
Fri, 27 Jun 2003 04:00:32 GMT

Brewe #2 / 4	ISAM Error??? I've had this error before as well. It fixed itself when I installed the latest service pack. Hope this helps Scott Quote: > I've recently been trying to teach myself VB 5.0(just starting with > databases) and tried this piece of code > Private Sub mnuFileNew_Click() > Dim wk1 As Workspace > Dim db1 As Data > CommonDialog1.InitDir = "C:\Testdir\" > CommonDialog1.ShowSave > Debug.Print CommonDialog1.filename > Set wk1 = DBEngine.Workspaces(0) > Set db1 = wk1.CreateDatabase(CommonDialog1.filename, "dbLangGeneral") > wk1.Close > End Sub > What I am trying to do is to Create an Access database file from a Drop down > menu File-New. So I set a common dialog control on the form > and made the menu. The Problem is that when ran it I get "can't find > installable ISAM". What the heck is an ISAM - I cna't find this anywhere. > Everyting appears to be right from the books I've been reading. My question > is - has anyone had this problem before or if not does anyone know how you > locate a 'installable ISAM' and what it is. > Thanks for your help.
Fri, 27 Jun 2003 20:16:47 GMT

Bill #3 / 4	ISAM Error??? Found my own solution for those care. In the line "Set db1=" I removed the quotes from dbLangGeneral. The newline is nowSet db1 = wk1.CreateDatabase(CommonDialog1.filename, dbLangGeneral) All work perfect from there. Quote: > What I am trying to do is to Create an Access database file from a Drop down > menu File-New. So I set a common dialog control on the form > and made the menu. The Problem is that when ran it I get "can't find > installable ISAM". What the heck is an ISAM - I cna't find this anywhere. > Everyting appears to be right from the books I've been reading. My question > is - has anyone had this problem before or if not does anyone know how you > locate a 'installable ISAM' and what it is. > Thanks for your help.
Thu, 03 Jul 2003 03:12:23 GMT

Robert Johnso #4 / 4	ISAM Error??? Bill, I had this problem with VB6. It is an install problem. Try reinstalling the database access components. After I installed everything, the problem went away. It is probably in an install section that you skipped. Robert Quote: > I've recently been trying to teach myself VB 5.0(just starting with > databases) and tried this piece of code > Private Sub mnuFileNew_Click() > Dim wk1 As Workspace > Dim db1 As Data > CommonDialog1.InitDir = "C:\Testdir\" > CommonDialog1.ShowSave > Debug.Print CommonDialog1.filename > Set wk1 = DBEngine.Workspaces(0) > Set db1 = wk1.CreateDatabase(CommonDialog1.filename, "dbLangGeneral") > wk1.Close > End Sub > What I am trying to do is to Create an Access database file from a Drop down > menu File-New. So I set a common dialog control on the form > and made the menu. The Problem is that when ran it I get "can't find > installable ISAM". What the heck is an ISAM - I cna't find this anywhere. > Everyting appears to be right from the books I've been reading. My question > is - has anyone had this problem before or if not does anyone know how you > locate a 'installable ISAM' and what it is. > Thanks for your help.
Sat, 05 Jul 2003 07:36:00 GMT

Page 1 of 1

[ 4 post ]