Search results for query: *

Hi, I have an MS Access 2000 .adp that makes use of SQL Server 2000 backend. Historically the application has worked fine. Recently I added a new continuous form that is bound to a stored procedure. The form has a combo box at the top that enables users to specify which fields in the form...

Hi, I developed an .adp that is being used by 270 people. Each time somebody connects to the database via the application I see 2 or 3 connections for each person. The .adp has a number of forms that are bound to SQL Server stored procedures. The application also uses ADO to execute stored...

Hi, I have a form that is bound to a row in a SQL Server table. The form contains text boxes that are used to store values for each column in my row. The form also has an "Add New" button which, when pressed clears all the text boxes so that users can populate the text boxes with values for a...

Hi all, How can I set the color property of a button column in a dataviewgrid control? I have dynamically added my column as follows: DataGridViewButtonColumn b = new DataGridViewButtonColumn(); grid.Columns.Insert(0, b); I can set text properties by doing: b.Text = "Edit"; etc.... but...

Hi all, I am new to C# windows forms and have a basic question. I have a form which contains a datagrid. The datagrid is bound to a stored proc that takes 4 parameters. In the Load event I do a one time initialization of the 4 parameters. Each of the 4 parameters comes from the selected...

Hi all, I have an ADO recordset that contains about 100,000 records. Is it possible to delete the first 60,000 records from this recordset using one command? At the moment I am using the following: For intX = 1 To 60000 rs.Delete adAffectCurrent rs.MoveNext Next The above is very...

I have recently upsized an Access database to SQL Server. The .adp is for the most part working fine. However, when an end user tries to create a duplicate record in one of the Primary key columns of a Form he gets a SQL Server error message as follows: "Violation of Primary Key constraint...

"Field 'F1' doesn't exist in destination table 'tablename.'" I hate this error message. I am using the following command to load data from an excel spreadsheet into a backend SQL Server database via an .adp: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel7, sTempTable, strFileName...

I recently upsized an Access database to SQL Server 2000. All of the Access tables, macros and queries have been migrated and the application works fine. I have now been asked to implement security so that different people have different access permissions in the adp. Specifically, I would...