Search results

Welcome! Are you inside or outside that large building in town? :)

Options?? What is the ID field that ties the child records to the parent record? Can you show a screenshot of the relevant tables laid out in the Relationships diagram?

Your screenshot in #1 is showing 1.08 GB/s. The "B" stands for Byte. Your #1 message seems to convey disappointment that "7 gigabits" speed only results in this 1.08 GB speed. I tried to point out the two are (almost) equivalent.

Are you confusing bits and bytes?

Job security: if the people upstairs ever define a new exam period, I will need to update and test all related queries, and who knows what else...

SQL Server has system views you can query to get all kinds of information about the structure of the database, including: select * from sys.foreign_keys fk inner join sys.foreign_key_columns fkc on fk.object_id = fkc.constraint_object_id You may want to additionally join this with...

Maybe because of the new-ish TrustServerCertificate clause.

Somebody should say that to my apps, which use ODBC 18. A typical connection string: ODBC;Description=xxx;DRIVER=ODBC Driver 18 for SQL Server;SERVER=.\SQL2022;Trusted_Connection=Yes;APP=Microsoft Office;DATABASE=yyy;TrustServerCertificate=Yes;

Who is the author of this Access,Azure,Performance.pdf document?

> using an ODBC connection in MS Access exposes passwords Not if you use this tip: https://www.microsoft.com/en-us/microsoft-365/blog/2011/04/08/power-tip-improve-the-security-of-database-connections/ With an Azure BE, you cannot program as-if you are on a LAN with an OnPrem SQL Server. The...

I am clicking around in your TV but am not seeing the error. Can you provide exact steps?

When someone says this, your first question should be: can you cite some reliable sources? Maybe that person has done some speed tests, and can share the results with you and with this community? Maybe this person can indicate where in your program things are too slow? What you're NOT going to...

With "good tools" I do not mean Ctrl+F in the VBA window, but ones like this: https://github.com/strive4peace/Analyzer and https://accessdevtools.com/ (although that site seems to be down atm).

> I thought it being a vba reserved word with a fixed constant that you cannot define a variable with that same name and assign it a different value? We have to use precise language. I did not define a variable, but a constant. That constant is in a different library (app_name) than the official...

When I defined a public const vbDefaultButton2 as integer = 6, in the object browser it appeared without its hex value. I gotta believe the constant is defined more than once. Also as evidenced by the absence of the problem in a new empty database. I hope you have good tools to do a deep search.

Yes, that is messed up. Wow. Do you have any funny references that could interfere? Or have references in a non-standard order? The default 4 should always be first and in that same order. EDIT: It is also suspicious that the hex value does not display. This is my A2010, with Northwind1 loaded...

Check this out: https://support.microsoft.com/en-us/office/prtdevmode-property-f87eebdc-a13e-484a-83ed-2e2beeb9d699

I meant to say that since in the second argument you used +, that indicates you know that vbYesNo and its cousins are integers. It then stands to reason that the return value of MsgBox is integer too, since in the next line you are comparing it to vbYes (an integer). But + is still incorrect...

You can set a breakpoint in Report_Open event, and then inspect the call stack to see who opened it.

> Even though the code casts string response correctly as integer, I also see no reason why you would have used the wrong datatype when it has clearly been documented as Integer since VBA first appeared in Office 95 While we are needling the OP: he clearly knew that, because he incorrectly wrote...