Search results

Check out Sean MacKenzie's video for this command. I believe it avoids a DNS file being created. If you don't select to remember password (which you shouldn't because the ODBC password is stored locally then; allowing hackers to obtain the password) so it prompts the user to enter the password...

I'm brand new to MSSQL like you, possibly password needed for server? ODBC driver 17 is fine I think, 18 is not for Access. It might also be that on creating the table a wizard was used rather than importing the table via VBA; which VBA avoids some sort of local records being created I think...

Thanks George, 1 - Sorry about that, edited link to YouTube video of Sean Mackenzie's guide on hooking up Azure with MSSQL & Access, should work now. 2 - Post 13 - I did not post the link/ file so I have no idea who the author is. I posted a link to Sean Mackenzie's video of setting up Azure...

Thanks for all your input guys. This video from Sean MacKenzie Data Engineering was very helpful along with your help also. One or two relationships have not imported but that's fine I'll sort them out. Interestingly I hooked up Azure & am using MSSQL Server 2022 also. Presumably Sean did this...

Silly question - how does one determine the existing join-type between a table-relationship from the Diagram-View in MSSQL 2022? Also can't see any indicators in the Table-Design itself. There seems to be a bug in double-clicking the relationship line does not open the relationship (articles...

Thanks guys, I get the gist to do as much as possible in the BE. Do we think carry on in Access, then think about Azure once I get it all working, or move to Azure now, whilst continuing to develop & test? I imagine I'd need to convert datatypes on incompatible types... & many things would that...

Thanks Colin, was in no way meant to be a dig; but a token of gratitude for the valuable lessons on your site, & as stated in tutorials they were all designed to be solvable. Very grateful for the info.

Thanks @Minty, good news that SQL Queries are more powerful as I'm working on a bit of a pig at the moment. I'm not sure if I should try to upload to Azure & see how i go from there. I imagine this will slow me down massively as I'm so new to it & learning Access was hard enough (still know very...

Can anyone recommend a good book exposing common pitfalls...? I'm a complete novice in both Access & Azure. Seems that using an ODBC connection in MS Access exposes passwords... in the registry.... Also as I still have not finished my application which I am planning to sell as an .accde & Azure...

Agree completely, I'm very grateful for the help & guidance Pat gave me & time taken from her day to generously explain things I could not have understood without her. I cannot count how many times I fail to understand something & load my old threads to rediscover the answer. Now a considerable...

Sure, but as queries go it isn't that bad a query & quite a simple one. He certainly shouldn't be using a union query for the reasons mentioned & you've kindly indicated an elegant solution with logic he can follow in a simple standardized query; not even a sub-query... A few mere lines. :love...

Wherever possible avoid a union query & go via CheekyBuddha's logic. If you used a union query you would be loosing the ability to edit data later. You'd likely reference this query in different applications throughout your application only with diminished functionality (in not being able to...

Thanks John, very helpful. I was worried I'd have to convert all my recordsets to ADODB, but judging from your code that doesn't appear so :love:.

Do you have any advice to share? I'm considering Azure but I am terrified. This is concerning, is a Windows user account authentication safer?

I agree, I'm surprised that the consensus is to post a new thread, on the same subject; leading to superfluity & detriment to Search Engine Results Page (SERP) for users. Millions of results for the same topic, opposed to a single answer with high-calibre solutions.

It wouldn't it's just a heads up as it was such an inadequate OP & I have much of my own work to do was just trying to be helpful is all shooting back a quick response for you to investigate further incase you were under pressure is all. Trying to give back to the forum which has helped me so...

With Me![sfrmPosLineDetails Subform].Form.RecordsetClone This is sinister. You're opening the recordset with the option as dbOpenDynaset or dbOpenTable right? Not recordset clone, as that will not allow an edit/ save changes. Requery your form or your form's recordset after the update. If you...

I am guilty of this.

Thanks Colin, be interesting to see what happens. If it is bad practice (which is a very good chance) I pray I'm able to find the problem :eek:.

Reassuring & both terrifying in a single word :ROFLMAO:.