Search results

Greetings, I have used such syntax as in this snip below: 'Define attachment to database table specifics and execute commands via With block Set adoCMD = CreateObject("ADODB.Command") With adoCMD .ActiveConnection = ObjBEDBConnection.ADODBConnectionObj() .CommandText =...

Greetings Pat, Only the MS Access default to the application wizard which is located under C:\Program Files\ which my ID does not have write permissions to. Blocked there as well. I am thankful,

Greetings Pat, This is for my own developer use... the VBA code. Such as, to complete the production implementation of an upcoming component, I automated with VBA connecting to the application's Oracle DB, issue some SQL, generate XML content to be able to bulk de-provision data from the...

Greetings The_Doc_Man, Then there will be no automatic workaround at this client. I was hoping for a similar work-around as we found for the GPO AutoLogin restoration solution. I spent all year (Jan prod go-live to Dec) to get approved DR/LRU interfaces for a production application. The...

Greetings The_Doc_Man, Yes the machine I am using Office 2016 on is a corporate managed computer at a client site. My machine here went through an Office 2010 to Office 2016 upgrade a while back, and that is where adding the trusted location via direct registry edit stopped working. I recall...

Greetings, I suspect a GPO is preventing me from adding directly to the registry Access 2016 User Trusted Location. In the Access UI Trust Center, all buttons are greyed out, and nothing shows up as User Trusted Locations. I successfully added my own directly to the registry. When I restarted...

Deja vu... here we go again... I am now working with A2010, a DB2 LUW BE DB, and am seeing the ADO ActiveConnection.Errors reset when I attempt to grab them into the ObjErrorHandlerADO object. How are other dealing with ADO ActiveConnection.Errors objects in order to capture error information...

Yes I use late binding, however I have a module which defines all of the constants ADO makes use of, so I will specify the constant name. So basically what I last worked out is the method if using ADO objects. The only strange thing I recall is I had to force the height of a multiple items /...

No no no... I want to send pass-through SQL to the BE DB. Just when I do so, that causes a disconnect between BE / FE such that ADO objects have not directly linked to form controls. For this read-only dashboard, I am asking again so I might head down another path. I am seeking a way to bind...

Greetings, Some time ago, I was chatting with Galaxiom in this forum system about techniques to use ADO objects as the data source for form controls and not have to use the ADP file format. For a previous client I worked out a technique to use Access in a Client/Server configuration where...

Access / VBA called the SP, and WHILE the SP was executing the server went down, never to return? Ugly situation... :confused: I have no experience with LONG running SP's, even SP's many printed pages long execute in the blink of an eye. So are you using ADO objects to execute the SP, DAO...

Which is exactly what I was seeking. The solutions I develop for clients are open source solutions. The client's paid for my consulting time to develop a solution for them, not a lock-in black box.

However according to my original question, I desire to be able to distribute .accdb format files and not have to compile them. If it is truly as simple as renaming the extension as has been suggested on this thread, for that simplicity I am thankful.

Excellent, thank you.

Aaahhh... so just rename the .accdb file to .accdr and then the Access Runtime will open / play it just fine? If so, that is at least doable.

Greetings, Is it a requirement to using the Access Runtime version that the database VBA source code be compiled? Or will the Access Runtime raise no issue operating an .accdb file format? Blessings,

That might work if there is some sort of guarantee that the master DB has unique enough data to meet the requirements of the ultimate target database. I will definitely keep that in mind. Checking I understood your take on it... use two linked table objects - one to each DB, then use a...

Greetings, Given an environment of two separate / different SQL BE DB's able to be connected to by ODBC connection, what other options than using a desktop database file as temporary storage exist to download records from the one SQL BE DB, to then use as the source of a bulk INSERT into the...

I did not, but got bit at a different spot. The place I got bit was in displaying varchar(max) data in a form text field. I banged into a crash out beyond "65,535" aprox characters... then later found that the amount of form text able to be held by a text area control was indeed that very...

You are most welcome, EternalMyrtle. I am please the problem has been successfully resolved.