Search results

Title pretty much says it all. I want to be prepared if the server ever takes a serious hit. I'm already backing up the individual databases but I'm not sure if the logins are part of the master db or what.

I have an MS Access frontend to a SQL Server 2000 database. The database was originally an Access mdb that I upsized using SQL Server's DTS wizard. After setting the primary keys and identities for the original autonumber fields I began to test the interface to make sure it still worked. I...

I inherited this database and I can't figure this out so I'm looking for some causes. the database is in one .mdb file, the interface in another and links to the database via the linked table manager. The tables aren't normalized, nor was there any attempt at relational integrity (Strike 1)...

Here is the code Dim insertStatement As String insertStatement = "INSERT INTO tableDisplay (name, manufacturerID, cableID, transportInterfaceID, powerCableID, backLightInverterID, notes) " & _ "VALUES ('" & subFormDisplay!modelNameTextBox & "', " & _...

I want to set my insert such that Insert into tableA (x,y,z) = (SELECT x,y,z FROM tableB) WHERE NOT EXISTS (select x,y FROM tableA,tableB WHERE tableA.x = tableB.x AND tableA.y = tableB.y) Basically I want to insert data in tableA from tableB if it does not exist in tableA yet. Access says...

Just when I thought I had my problem licked... I created a subforum with an updateable query, and this works. I can view the results of the query, modify them and add new records. However I shortly realized that once I deleted a record (either by some VBA code, or by SQL) that I could not...

I have a subform that I'd like to put a delete button on, so that it deletes each specific record. This was left over by the previous programmer for this purpose but without any documentation, and it doesn't seem to work as intended. Using the below code allows you to delete the record, but...

I can write an UPDATE statement fine, what I don't quite understand though, is updateable statements involving forms. To populate a form you have the form record source set to some SELECT statement and then you place your controls and set the control sources to the fields in the SELECT...

I hate to ask such a broad question but googling just turns up links for how to use the wizard, and I don't want that. Its my understanding that a subform functions a bit like a report, I can set the recordsource to a query and it'll display all the records returned, in the controls that I've...

I want to update a column in table A with the value in table B where the value in A matches another column in B This is what I have, which seems like it would be a valid query but Access is telling me its not an updateable query. UPDATE PaymentBackup SET PaymentBackup.ClientID = (SELECT...

I'm not quite sure how to explain this. The application I need to maintain has a regular form, and then a subform on it that is supposed to fill up based on a query, with each record being represented as a row and the columns have various drop down boxes or textboxes etc. Normally there will...

I'm trying to figure out what tool I can use to connect to an SQL Server 2000 database in the same manner I use the SQL Server Express Management Studio software for SQL Server Express. I'll be connecting to the database over the internet via ODBC. I'm looking at a hypothetical situation where...

this is vexing me. I have 4 tables, 2 entities, 1 relationship and 1 lookup Entities are tblOrg and tblForm Relationship is tblVentureParticipation Lookup is tblInfo (Has many different lookups) When an organization (these are listed in tblOrg) turns in a form, a new record is inserted into...

Hi, I have a listbox on my form named participantsListBox I want to do the following dim selectedControl as Control selectedControl = Me.Controls!participantsListBox However I cannot do this because participantsListBox is null. What is the error in my logic / how do I do what I'm aiming for?

I have a report that I built that will alternate pages of text with blank pages. I've tried resizing it in case parts were overflowing but that has done nothing, and I don't see properties I might've turned on by accident that would do this. Can any help me fix this?