Hello guys! I need advice. So I'm working on a Reservation feature of a system. I have created a DAO's for Customer, Employee, and CustomerInquiries. I will explain to you how this works first. The customer creates a "customer inquiry" on the company website to inquire about rental of buses. The employee, then, could log into the website and view the customer's inquiry, and confirm it with the customer. It is better to remove the CustomerInquiriesDAO and just add the methods under Customer? I was also thinking that customer inquiries could just be stored under reservations table and the employee …

Member Avatar
Member Avatar
+0 forum 1

AOA, I m using vb6 with Access 2010 (DAO recordset) and Crystal Reports 9.22 I have developed a projet in vb6 it works fine at desing time but when i Install it (i mean after Package and deployment) and run the projet everything works fine but when i run reports it says: **Logon Failed: DAO Error Code: 0xbe4 Source :DAO.Workspace Discription : "D:\..\..\MyData.MDB" is not a valid path. Make sure the path name is spelled correctly and that you are connected to the server on which the file resides.** How can i change the datasource location in crystal reports at …

Member Avatar
Member Avatar
+0 forum 4

I'm new on programming this VB 6, Advance thanks for those who'll reply. All opinions are open :3 (Sorry for poor English) === The program runs like this: I input the Student ID, then it searched using DAO now the student's info was shown up, what should I fill up now will be the Reason of his tardiness, after that, I submitted it, then it will be recorded. **Now, what I want would be:** After I submit, his Number of Tardy should be counted too based on his Student ID until the end of the year *(because ofcourse, that was …

Member Avatar
Member Avatar
+0 forum 4

Hi all, Can someone please help me. I'm writing a VB5 app that connects to an Access 97 database using a data access control with the following parameters: Connect = "Access" DefaultType = 2 'UseODBC Exclusive = 0 'False Options = 0 ReadOnly = 0 'False RecordsetType = 1 'Dynaset (The app sets the DatabaseName and RecordSource properties at runtime.) When the database doesn't have a password, it works perfectly. But when I give it a password ("OpenSesame") and change the Connect string to "Access;pwd=OpenSesame", I get this error: "Couldn't find installable ISAM." I need to solve this so that …

Member Avatar
Member Avatar
+0 forum 4

Hi I need to migrate an application from MS Access to SQL Server (2005), and i'm using the code bellow, but i'm getting an error when the compiler reaches the AddNew instruction. It gives me "Run-time error '3027': Can't update. Database or object is read-only". [code] Dim DBTesteSQL As Database Dim rsTesteSQL As Recordset Set DBTesteSQL = OpenDatabase("", dbDriverNoPrompt, False, "driver={SQL Server};server=ABC\CDF;uid=XXX;pwd=XXXXX;Trusted_Connection=No;APP=Visual Basic;database=MyDatabase") Set rsTesteSQL = DBTesteSQL.OpenRecordset("SELECT * FROM test", dbOpenTable, 0, dbOptimistic) Debug.Print rsTesteSQL.Updatable rsTesteSQL.AddNew rsTesteSQL("name") = "reg" rsTesteSQL.Update rsTesteSQL.Close: DBTesteSQL.Close Set rsTesteSQL = Nothing Set DBTesteSQL = Nothing [/code] As far as i can tell, the problem comes …

Member Avatar
Member Avatar
+0 forum 4

I need functionality to retrieve the new pk, like I could in DAO. I would like my "nLog" function (see code below) to return the new pk. I have found [URL="http://support.microsoft.com/default.aspx?scid=kb;en-us;815629&Product=adonet"]this[/URL], and I was able to make it work fine in my environment, so I'm pretty sure the problem I have is caused by my failure to understand event handlers and possibly partial classes and inheritance in VB.Net. And not because of my use of the access database, or because the "select @@identity" does not work. It all works OK, so there is not need to be bothered by that. …

Member Avatar
Member Avatar
+0 forum 1

The End.