Search results

Well, not my intention to be rude, if as such, then my apologies. And really, this should be great news. And the reason? Well, if everyone not having this issue, then that bodes well here - really, it does. Since, if the issue not all that widespread? It suggests that a fix is possible, right...

Your "use" case is actually quite common. So, on program startup, you check if re-linking is required. But, how do you change what location, so correct linking is to occur? Well, you have several choices. One choice I used in the past was having a local table in the front end. It had several...

First up: >>there is a SQL server over LAN Ok so file sharing, locking etc. not going to be the issue here, then right? >>I pinpointed an issue to the 24h2 update Really? Well, if this was a wide spread issue due to that update, then would not the internet light up like a Christmas tree...

I'm not seeing this issue. If I have SSMS open, and click on a .sql file (from windows explore), then it opens up with current SSMS instance - not a whole new version. And if I have a sql query window open to a given database connection? Then double clicking on a .sql file not only opens the...

What's that saying about the juice is not worth the efforts to squeeze the fruit or some such? Typing in "exec" not going to wear out your keyboard is it? ;) I don't recommend leaving it out.... R Albert

Actaully, in both SSMS, or even a PT query from Access? You don't need the EXEC in front in most cases. So, from SSMS, then these will all work: EXEC dbo.GetHotels EXEC GetHotels; dbo.GetHotels GetHotels And thus, even from a PT in Access, then this works: So, the "exec" is actually...

Ok, for sure then, start out using SSMS to create, manage, change, add, modify the tables. You find SSMS not a whole lot different then ms-access. The table designer is VERY much like the Access one. Only trick part is to setup your PK takes 2 steps, and not one like in Access. However, above...

Well, at one time Microsoft had 80 developers JUST working on the Excel installer. And another example? I knew some people working for a software company that sold metal quality tracking software. (tracks grade of metal a it goes though many manufacturing steps - a must have for quality...

Actually, you are 100% MUCH better off to start out using SQL server from day one. Since you noted you have "run time" experience, then I think you have a good grasp of the development cycle here, and I assume you also are aware of the split front end, and back end setup. However, when JUST...

Actually, no, don't at all one tiny bit back off on the points you are making here! While I'm kind of stomping a bit on you in regards to the poster? (since they using Access + Azure - not a lot of need to patch and update stuff, is there???). However, I'm actually going to state that EVERYONE...

Again, much agree, but above is a VERY different context here! So, while I have to be aware of say some OS patch, or some update to jQuery or ISS internet server, or SQL server? It's still not me the developer in most cases having to update the OS or IIS or the database. I mean, we been...

Just right click on the nav pane, and choose details. Like this: Also THEN note how I changed the sort to descending for modified date. I assume of course this is a "one time" event, and for future development, if you split your database, then this "issue" will go away.... R Albert

As noted, i up-voted your response. However, say I'm using Azure as my database, well it's being updated and patched all the time for you, and your software that uses Azure in most cases will require few updates. And same goes for having written web based (public facing) web sites (it's what I...

Yes, but it works the other way around – the end user has to start the remote session, not that you can! (and I don’t think any customer would give you the ability to remote into their computer). So, this works like “goto my pc” or “Team Viewer” or many of the other “support” systems. The...

Ok, first up, I’m a bit confused by all this talk of patches, updates etc. At the end of day, one wants to: Sell, and deploy some software to users. Such users don’t care about backups, patches, etc. They JUST want to use the software – nothing more, nothing less. They will NEVER had to deal...

Don't think windows ever included an extra windows license. Only exception was back in windows 7 days when they included windows xp mode (a vm to run older software). The other case was windows server editions- they allowed 2 free vm's for the one standard license (and they still do now to my...

At one time, I could recommend this idea - not anymore..... However, I can think of a few cases, where I have run a server OS. So, I had a server OS setup for SharePoint services. This was of course during time when Access “web services” and “Access web publishing” of Access applications...

Well, actaully, if you leave the solution exploer tree open, then in most cases, a live connection to SQL server does exist. And in fact, since about SSMS 21, OR 22? When I'm restoring a database, I now OFTEN have to close the explorer tree right before the "restore", else I receive a message...

Ok, long story short? You need to turn this into a SQL view. SELECT DISTINCTROW tblProducts.ProductID, tblProducts.ProductName, tblProducts.vatCatCd, tblProducts.dftPrc, tblProducts.itemCd, 0 AS RRP, 0.16 AS VatRate, tblProducts.Sales, tblWarehouse.WHID, tblProducts.taxAmtTl FROM tblProducts...

The issue(s) of a persistent connection doesn't apply nor effect nor help when using SQL server. The persistent connection works due to eliminating the time for windows to grant op-locks, and switch from single user file mode to multi user file mode (and to create the. Ldb locking file). In case...