Search results

I find that doubling-clicking on a file with the .sql extension opens it in the program with which that extension is associated at that time.

I've been trying to recall an issue with Access back ends on network shares that was possibly associated with the 242H2 update. The only thing I come up with is that it had something to do with needing to disable leasing. Maybe someone will know what I'm talking about and can address whether...

Having migrated Access tables to SQL Server since the early 2000's, I've had the opportunity to do so in multiple ways. Who remembers when "Export to SQL Server" was an option on the Access ribbon and before that a Menu option? Each has advantages and disadvantages, and no that is not a waffle...

Unfortunately, the table in your current database is not yet suitable for a relational database application. It appears to be the result of importing an Excel worksheet into Access with no further effort to convert it into the appropriate tables. That is a very common mistake when first...

"... it makes it really easy to find ...." (y) I would add, "... and to make it clear what is happening." As I get further away from the halcyon days of head down programming for clients, I find it comforting to be able to read and follow the logic of fully qualified code structures.

You might also want to account for possible Nulls in CountryID WHERE (GrantsT.CountryID = 3 AND GrantsT.Status = "Active") OR (GrantsT.Status = "Completed" AND GrantsT.CountryID IS NOT NULL) That said, David's version is more likely to produce the correct result.

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...