Search results

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.

Did you actually the read the announcement you linked to? The Salesforce ODBC drives *is* built into Access and will now be removed. That is what the announcement was about.

There was such an issue with Microsoft's own SCC plug-in for Access. And, I agree, this was a major nuisance. AFAIK, all current source code control add-ins do not require to explicitly check out before making changes. For Git based version control, the Check Out step is generally no more part...

I don't think there are any other ODBC drivers built into Microsoft Access. Does this answer your question?