Search results

Your Primary Key should be unique and therefore avoid this problem. Access is actually doing what it is supposed to do. Rather than trying to deal with this problem using code, I think you need to re-define your Primary Key so that it is truly unique. Alternatively you could import the data to...

Sorry I'm still not clear on what you're trying to do. Are you trying import records to a table that has a primary field and if the record you're trying to import has creates a duplicate primary key, you want to do something else?

Anyone else have any ideas? I may try and change the record lock limit to see if that makes any difference.

If you want to trap the error can't you use: On Error Goto errTrap ......... ......... ......... errTrap: if err.number= 31550 then ...do something end if ====================== or use Resume Next ? What is it that you want the code to do when you encounter this error?

Yes its 32bit. I read the part that you quoted and I guess that might be the case if there is some memory leakage with Access itself (the code is fine). In any event, isn't PtrSafe only for use with API's? If not how do I use it with my functions?

Thanks for the reply. There are no API calls though. The code uses mainly HTML Objects container.

Thanks for the reply but that post referes to a Win 7 problem. My code runs perfectly under Win7, but the problem occurs in XP.

Hello, could someone please offer some suggestions as to how I can fix a problem I have with Access 2010? I have written some code to pull data from tables on various web pages. The code iterates through several thousand pages and pulls data from each one. Everything works fine when I run this...

Hello, I've been writing some code to pull data from a website and have hit a bit of a problem. I'd be grateful if someone could help with help this. The one thing that I can't seem to do is to set the value of a combo box on the webpage. I need to select a value in order for the correct...

Anyone know how to create OLAP cubes using either Access or Excel (assuming it can be done of course)? I have a number of queries that I would like to use as the basis for OLAP cubes that can be used by my colleagues. Any help would be gratefully received.

Done it: "SELECT dbo.vSyndicate.CalYearID AS CalYr, Right(ReturnCalQuarterID,1) AS Qtr, dbo.vReturnHeader.SyndicateNumber, Case when ReportingCalYearID = -2 THEN Null else ReportingCalYearID end AS YOA, dbo.vReturnBaseElementMappingUIDescription.FormLabel...

Thanks, tried that but it still didn't work.

I'm trying (being the operative word) to build a passthrough query and am having some problems. When I try running the following SQL it returns "Incorrect Syntax near '!'". Can anyone see what's wrong? SELECT dbo.vSyndicate.CalYearID AS CalYr, Right([ReturnCalQuarterID],1) AS Qtr...

Thanks! Do you happen to know whether there is an equivalent of the nz() function as well?

I'm trying to write a pass-through query that contains anumber of IIf statements. SQL Server doesn't appear to like them. Can anyone please tell me what the syntax should be or what function to use in their place? Thanks.

FoFa, spot on, well done! I see what's happenned now. Access obviously doesn't like the "." and replaces it with a "_" to concatenate the "dbo" to the object name, presumably to denote that it is a linked database object? Anyway, it is working now so thanks very much.

I have a VERY simple select statement that I am using in a pass-through query: "SELECT * FROM dbo_vReturn;", but I cannot get this to work. Each time I run the query it generates an error: "ODBC call failed - Invalid object name "dbo_vReturn" (#208)". The dbo_vRteturn is a view in the backend...

Thanks for your reply, I was just hoping there was an easy way of converting the SQL. Looks like it's going to have to be a case of going through this manually though. thanks anyway!

Does anyone have a Jet to ANSI SQL conversion tool they could either send me or recommend:confused:

Sorry for the delay getting back to you, I've been off for Christmas. In answer to your questions: 1. No this is not an ADP project. This is a database that has been set up for reporting against data held in our data warehouse. We plan a move to BusinessObjects but in the meantime need to use...