Search results

Thank you. I think this is another case where I adopted the practice of using full syntax regardless of whether it's required or not.

Please elaborate. In what context do you not need to use EXEC SP_MyAllPurposeSummary?

"Hey, Claude. Use the raw files in this GitHub Repo: https://github.com/GPGeorge/Context_LTFLibrary. The raw URLS are in the file called LTFCatalogRawURLs in that Repo. Discard any files you may have retrieved in earlier sessions. Use only these latest versions."

It's a public repository.

SSMS is tightly coupled to SQL Server in the sense that it is designed to work with SQL Server databases. However, it's important not to confuse the two. SQL Server -- the objects themselves, tables, views, stored procedures, etc. SSMS -- tools to create, modify or delete objects in the SQL...

What I do is export the files to GitHub and provide the AI (Claude in my case) the Raw URL's for those files. Claude needs to have access to the GitHub repo, so I created one just for that purpose. It also can't get to files in the repo directly, but it can retrieve them via the Raw URLs.

SQL Server Migration Assistant for Access (SSMA) is a tool that migrates tables from Access to SQL Server. SQL Server Management Studio (SSMS) does not enter into that migration process. You do not even have to have SSMS installed to migrate the tables to SQL Server. SSMS has NO objects of it's...

Show us your existing VBA code, then, please.;) I don't think the SQL you show corresponds to opening a recordset using OpenRecordset. My guess is that it needs to be something like this. Public Sub Populatedates() Dim intDateCount As Integer For intDateCount = 0 To 1094...

Most experienced Access developers have come to a very similar conclusion regarding the creation of Primary Keys from bits and pieces of other fields. That conclusion can be summed up as something like: "This method creates more problems than it solves." Therefore, the most commonly offered...

I have to agree with CJ. To what end would you want to deploy SSMS on a client's computer? To make it easier for the client to connect to and explore/dink around with/modify the SQL Server database for your application? I'm sure that, if the client has an IT department, their security team...

From time to time we hear about legacy apps running on Access 97/2003/2007 etc. The defining characteristics of such apps generally include isolation from integration with other applications and a business model that hasn't changed since dirt was invented. That's fine where it works. Until it...

There are very, very few black and white decisions. I well recall the contretemps surrounding Kaspersky. For a while I used other Anti-virus tools, but eventually, it seemed that Microsoft's Defender became good enough and easy enough and ubiquitous enough to decide maintaining a separate tool...

Good point. 👍

Further to what has been suggested, you need a table called something like "tblLogin". It will need fields like "Login" and "LoginDateTime". In an AuthoExec macro, call a function that captures the UserID of the person starting the application and the date and time of that login. Store that in...

There is a commercial application that is really good at comparing accdb versions. https://kellermansoftware.com/products/accessdiff When I was active as a consultant, taking over "rescue" projects, I found it well worth the cost of a license.

Who better to ask that one of the AI's? This is from Claude. Based on recent research and reporting, here are the key locations where AI data centers are being constructed with significant power and water constraints: Major Constrained Locations Northern Virginia (Loudoun & Fairfax Counties)...

Isn't this thread supposed to be about performance of SQL Server Management Studio version 21 versus SQL Server Management Studio version 22? Why are we even talking about Access in this context?

I think it's a grey area and most such reseller offers probably do skirt the edges of their licensing agreements with Microsoft. On a different, but related topic. I am now party to two different class action lawsuits against AI companies for downloading books from pirated online libraries...

The key is that you will be buying an LTSC licensed copy, with all the rights and restrictions that entails. Specifically, it is my understanding that LTSC licenses are NOT intended to be resold at retail. They are sold to an organization, to be used within that organization...

Muddying the waters ever so slightly. The current plight of technology-centric forums like AWF is clearly related to the use of AI. It's a case where I believe the correlation between increasing availability and usability of AI and decreasing activity at such forums does indicate a high...