Search results

SELECT c.* FROM Contacts c WHERE EXISTS (SELECT 'x' FROM tblContact_Categories cc1 INNER JOIN tblCategoryTypes t ON cc1.CategoryTypeID = t.CategoryTypeID WHERE t.[Category Type] = 'car' AND...

True. The original, quite massive, bloating problem with storing images was that Access was converting all images to Bitmap format and thus massively increasing the files size of compressed image formats, such as JPG or PNG. This should no longer be a problem if you enabled the "Preserve source...

How did you arrive at this conclusion? HRESULT 0x80004005 is just E_FAIL. The most generic of errors in the COM space. It is essentially the same as a poster here in the forum describing his problem just with "It doesn't work". I'm not saying you're wrong. Considering that the other error came...

I was not referring to MSDTC. The ACE/JET engine takes that role in a desktop/file system based scenario. Too bad that you don't have a link. The only documentation I could find that explicitly mentions that situation, seems to support my statement. Workspace.BeginTrans method: Some quick...

Yes. The Access Textbox control has a hard limit of ~64k characters. It often starts to behave weird with a lot less characters already.

Do they? I rather think the JET/ACE-Engine does some sort of distributed transaction coordination across all data sources involved. At least, if you use explicit transactions.

The GDI+ API(*) gives you more control over image transformation. It is also quite a bit more complex to use than the fairly simple WIA code. - It's for you to decided which is better. ;-) *=I linked to the "GDI+ Flat API" and the text tells you not to use the "Flat API", but with VBA you must...

I think, you confused registry redirection and file system redirection. Apart from that you are spot on! Quote from File System Redirector:

Exactly the same here if I look for the DLL using Windows Explorer or Everything. However, if in Access (2010 and 365CC, 32bit) VBA, I use the "Browse" button to add a reference and navigate to C:\Windows\System32, I also see this file there! ? If I try to actually add the DLL from System32 to...

For clarification: I didn't mean to say that there is a general issue with automating Project. I was questioning whether Access and Project are a particularly great combination. - The other Office applications are very often used to create "one-way documents", i.e. you create a document with...

I'm not so sure about that. I did some very limited VBA work in MsProject many years ago. More recently, but still years ago, I put together a proposal for a client to synchronize Data in an Access DB with project plans maintained in MsProject. - The client didn't like the proposal, or rather...

You're only going to see registered COM/ActiveX object libraries there. So, it depends on whether the creator of the application did created and published such a library. Most application developers don't. Microsoft was a notable exception the past and provided such libraries for many (not all!)...

Usually the term Factory is used for such a class.

Error? What error? The message you mentioned is a friendly reminder/question that your code change will cause the running application to be stopped. It is not an error! This behavior is perfectly normal. Once you start your application by either explicitly running code from one of your Access...

What do you mean with "When I go to debug"?

Unfortunately, there is little documentation on internals of the JET/ACE-Engine and the the SHOWPLAN output. So, my explanations are meant more as educated guesses than absolute facts. Because it makes the subsequent join in 03 easier (less resource intensive) if both sets of records joined are...

"The first time" means if you try to compile the created database file a second time it works? Or do you mean if worked for months and now it fails for the first time? Do you import into a newly created blank Access file or do you import into a file already existing for some time? I think, the...

@Gasman , I suggested *you* create a minimal sample db primarily because in the process it is very likely that *you* will find the cause of the problem. Excuse me? There are several problems with this database. First, there are references missing (Excel, VBA Extensibility) and thus the whole...

I tried to reproduce this issue based on your description in A365 V2507 Build 16.0.19029.20208 32-bit, but I had no luck. Using the expression Val([txtCarbsCalc])>TempVars("CarbLimit") does work as expected for me. If you want to pursue this further, I suggest you create and upload a minimal...

NO. The Access Runtime is a different edition of Access than the full edition. If you install the full edition but do not license it, it will be degraded to "read-only" operation, which has similar limitations as the runtime edition, but is still very different in detail.