Search results

I thought you were my friend 😞

No dice. The user of the app can select which BE to connect to and scan (for purposes of Anonymizing the data), and I'm allowing them to select either Access or SQL Server BEs.

If SQL Server is the back-end (BE), we can link to tables and views. Views are like queries. However, if Access is the BE, we can only link to tables, not queries. My form is listing BE objects and I have a "View Data" button. When clicked, I link to that table, and use DoCmd.OpenTable to view...

I'm expecting DRM: the video is protected and cannot be shown worldwide.

Re Active Directory: here is my blog post. The code includes a test to see if you are using AD or not.

Great to see you here Sean, and best of luck with your project.

One other suggestion: if you had an add-in such as this one you can do a deep "Find" operation for the word "BusinessAddress", and it would list all occurrences, including the query discussed above.

I asked Chatty "where can I download ingredient cost information for bakery goods?" and got a few promising leads.

I think the answers are No, No. Have you tried reviewing the execution plan? And maybe also the Database Engine Tuning Advisor?

> Decimal() Don't use Reserved Words for function names.

I disagree, Colin. While it is true you can write a MsgBox replacement, that is a far cry from having ALL messages having consistent features. Like @DaveMD I have been annoyed that for example ODBC error dialogs do not allow you to copy the text using Ctrl+C, while other messages (including...

The link George referred to is https://www.mockaroo.com/ I am working on an Anonymizer that can generate plausible-looking random data. Send me a PM and maybe I can share it with you.

Considering your situation, I would keep it very simple: * SQL Server Express, the free edition, on-prem. You'll need to add a sproc to perform a database backup, since scheduled backups are not included in Express. * Very few stored procedures and views. They are mostly to optimize performance...

I can only think of disadvantages, such as The software you'll install on this machine has not or barely been tested on this OS. This includes device drivers like your printer and camera. When you build your app (this is more for .NET development than Access) it may pick up unusual references...

Cut/Copy/Paste more than likely are unchanged. But what could have happened is that the clipboard was in use by another app. Reboot the machine, don't start anything else, and try again. Another test you could perform is to do the operation manually. Is "Paste" grayed out when you get to that...

Thank you for answering question 2. We'll wait for the answer on question 1.

That was my thought as well. The OP better very clearly define what threads he wants to defend against. Keep an excellent Access developer, putting in an effort of N hours, from accessing the algorithms / encryption keys, or the NSA?

> without having to execute the function wherever it is required Perhaps this is an issue of not using precise enough language, but the way I am thinking about it, yes, you have to execute a function if you want its return value. If it is a deterministic function, then conceivably you can cache...

Replace the word "SSMS" with "SQL Server". The former is an editing tool; the latter is the database engine. You could put complicated calculations in a .NET assembly, and call it from your sproc or function. See this about assembly security. See my Simil blog page for an example of calling an...

I have a few questions: 1. Roughly how many products do you have, and how often do they change? 2. Why are you joining with tblWarehouse? Do you only want products that are in the warehouse? If so, there may be better ways.