Search results for query: *

One thought if you are trying to import from SQL to Access... NVARCHARs actual length is twice that of VARCHAR. Try changing the size of the column on the Access end to 40.

Try to Decompile the mdb. Start --> Run "C:\Program Files\Microsoft Office\OfficeNN\MSACCESS.EXE" "x:\MyMDB.mdb" /decompile Substitute your folder for OfficeNN (ie Office11, Office12)

Insert a space after the keyword CALL As Private Sub Form_AfterUpdate() Call DisplayImage End Sub

Is the nightly backup being appended to the backup file? The backup command needs the /INIT parameter to start a new file.

Not sure why you are getting the error. I just tested it in a quick form and it works as expected. Two questions: 1 - What is the data type of the column [DOB]. If it isn't type DateTime, you may need to convert it to DateTime before passing it to the function; although I would expect to see...

You aren't passing in the non-optional date_of_birth value. You control should have a value of =basDOB2AgeExt([MyDOBColumn]) where [MyDOBColumn] is a table column containing a date_of_birth.

Try running this query: select max(maxquerylen) seconds from v$undostat; Then set the value of undo_retention to something higher than the returned value.

Your trigger isn't written to handle multi-row updates. Post the trigger code here so the forum members can see it and make suggestions.

Check to see if you have any missing references.

The syntax should be something like: CurrentDb.Execute("YourDeleteQueryStatement",dbSeeChanges) You need to have a primary key defined for the table (probably your Identity column) in order to delete from Access.

I don't remember the specifics, but I had a similar problem some time ago. It had to do with Access creating an invalid name for a worksheet. What does the name on the tab look like? Is there anything in the event log related to the error?

Take a look at the TransferSpreadsheet function if you are trying to create a spreadsheet directly from Access.

You don't need the .Value property. Just use "INSERT INTO tblTestTable (TestTextData) VALUES ('" & TestThingy & "')" Also, you should give the variable TestThingy a data type like Dim TestThingy As String rather than let it default to a Variant type.

I'd like to add a question along these same lines. What action short of recompiling the procedure should be taken to make sure procedures are using more current execution plans? Is updating statistics sufficient? Thanks in advance.

Yes. You can try something like this: CREATE PROCEDURE usp_Do_Something(@StartDate DATETIME, @RecsEffected INTEGER OUTPUT) AS SET @RecsEffected = 0 If @StartDate... UPDATE Table1... SET @RecsEffected = @RecsEffected + @@RowCount INSERT Table2... SET @RecsEffected = @RecsEffected...

Try: Select ActionType, Count(ActionType) As OnHand FROM TableA Group By ActionType, Order By ActionType

The column will be 8000 bytes. Is the column defined as varchar(8000) or Nvarchar(8000)? If the column is Nvarchar it is Unicode and reserves 2 bytes of storage for each character. If it is varchar, it reserves one byte of storage per character. Is it possible the limitation is a result of...

My $0.02. My understanding is that provisions of SOX only apply to publicly traded companies. If the OP's Not-For-Profit is not a public company he/she shouldn't need to worry about SOX. My experience with the process is that the important point is being able to show that your company has a...

My $0.02. Try turning off System Restore. Then delete the offending entries. Turn System Restore back on after you are sure they aren't returning.

Dim Ctl as Control