Can anyone give me advice on where to look for possible causes of repeated database corruption?
Have been experiencing problems with database corruption in a system under development. In last few months, this Access 97 database has gone sour three times, usually fist indicated by failure to...
I'd recommend using the Inserted and Deleted temporary tables created during transactions. On a Delete action, all deleted records appear in the Deleted temp table while the Inserted temp table will be empty.
CREATE TRIGGER [DELETE_FOB_Size] ON [dbo].[FOB]
FOR DELETE
AS
DELETE FOB_Size...
Jo - It may not be an elegant solution, but I've always used error trapping for this.
Err_CmdPreview_Click:
If Err = 2501 Then
Err.Clear 'If report is closed because there's no data,
'don't report an error
Else
MsgBox Err.Description
End If
Resume...
Thanks for the suggestions, Ian and MisterC. I'm thinking of going in a slightly different direction now:
Create a link to the data file, then use the linked table's TableDef to build a format file for bulk copy to SQL server, since the data will eventually end up on the server anyway. From...
Jo -
Instead of closing the report, just cancel it.
Private Sub Report_NoData(Cancel As Integer)
MsgBox "No Records Available."
Cancel = True
End Sub
Hope that helps.
John
All variables and their assignments are stored in RAM, so the variables can be used simultaneously by multiple users without worry. For that matter, if multiple sessions are open on a single PC, the assignments in RAM are also kept independent.
Unfortunately, that's exactly what I mean: There's no way of knowing how many fields or the type of data sent. The customers sending the data are adamant that they cannot be held to a data format standard <arrrrgh!>.
What I'm doing is allowing the user to map the fields from the temporary...
I'm using VBA (TransferText & TransferSpreadsheet) to automatically import various types of files into temporary tables in Access 97. The problem is that Access makes guesses about the data types of the columns based upon the first few hundred records it reviews prior to import. For instance...
Thanks for the advice & sorry for the long delay in responding. As you suggested, I was able to place the code in the form module, use the ReturnsRecords querydef property to set up a new recordset to access the new record, and hold the returned value for later use.
It works like a champ now...
Using Access 97. I have a module that opens querydef to call a SQL stored procedure to insert a new record. That proc has an output parameter (@CAMP_ID) to return the new record's ID. Once I execute the SQL statement from within Access, I need to bring that output parameter back into Access...
I've set up a SQL 7.0 maintenance plan to complete full backups on certain databases and trans logs each night. The job is supposed to delete files older than two days, but SQL is often failing to do so... and I can find no clear pattern to the failures.
I first had this split into two jobs...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.