Recent content by maupiti

SQL 2000 SERVER In SQL SERVER Enterprise Manager. I have a table, and this table has no primary key or index key defined, and it does not have any relationship with other table. When I try to delete a row it gives me an error. Error: Key column information is insufficient or incorrect. Too...

SQL 2000 SERVER In SQL SERVER Enterprise Manager. I have a table, and this table has no primary key or index key defined, and it does not have any relationship with other table. When I try to delete a row it gives me an error. Error: Key column information is insufficient or incorrect. Too...

Hi PHV (MIS). The table User_Account had been linked to an SQL Server using ODBC from the very start of this thread.

Access 2003 The query below work, when it is in a saved query, but when I put it in VBA it gives me an error. Syntaxt error into insert statement. ////////////////////////////////////////////// Private Sub Input_Training_Records_Click() Dim Dbs As DAO.Database Set Dbs = CurrentDb...

Hi PHV (MIS) How do I go about to give sufficient credentials for updating the User_Account table. Would it be setting read and write permission in SQL 2000 Server ? ////////////////////////////////////////////// Does this look right to you ? Set cnThisConnect = CurrentProject.Connection Set...

Hi PHV (MIS), and thank you for your help. I did as you have suggested. I removed the cmd.CommandText and I use the two line below and it gives me an error. On the second section I also use .EditMode but it does not work either. //////////////////////////////////// Cannot update - Database or...

2) SQL 2000 Server Why a Data Type of "timestamp" in an SQL table that have an eight characters limit can hold The value "Aug 9 2006 4:56PM" and SQL did not flag any error ?

Hi Golom, and thank you for your help. If I use a "cmd.Execute , , adCmdText" and then a "cmd.Execute , , adAsyncExecute" on a second statement as shown below, then it does work. /////////////////////////////////////////////// cmd.CommandText = "INSERT INTO Table_User_Log_On ( Name...

Access 2003 and SQL 2000 Server. Why the field "Last_Access_Date" was not updated in table User_Account. cmd.CommandText = "UPDATE User_Account " _ & "SET Last_Access_Date = '" & Now() & "' "& "WHERE Name = '" & Forms!Main_Login!User_Name & "';"...

Access 2003, and SQL 2000 Server Run-Time error '3711'. Operation cannot be performed while executing asynchronously. //////////////////////////////////////////// The first code below work, but the second one immediately after this fail. cmd.CommandText = "INSERT INTO Table_User_Log_On (...

Access 2003 and SQL 2000 Server. All tables resided in the SQL 2000 Server. All tables are linked using ODBC. The user interface is Access 2003 Run-Time error '3709' The connection cannot be used to perform this operation. It is either closed or invalid in this content The yellow highlight...

Hi PHV (MIS). Thank you for your help. I did as you have sugggested and the value are "John_Doe " "John_Doe" In SQL Server, the field "Name" is declared as Type: nvarchar, Size: 50. Which type should I use so that it won 't automatically add spaces ?

Access 2003 and SQL 2000 Server 1) ADO code does not work. I had the two code below to print out the two value and they are both the same, yet, it executed the else condition. MsgBox RecordSet_User_Account!Name MsgBox Forms!Main_Login!User_Name If RecordSet_User_Account!Name =...

Hi jebry. I did what you have suggested, and it turns out that MsgBox frm.Controls.Item(3).Name is a label and not a text box, and this is why it gave me the error. This is a good suggestion from you. You asked "Out of curiosity, what exactly are you trying to accomplish? " I have a...

Hi jebry and rjoubert. I make the code even more simpler and I got this error "Application-defined or object defined error". The error is at frm.Control.Item(3).Enabled Item(3) is a text box, and I even delete its label and it still gives me this same error. The label has a "Tag" property...