Search results

After spending a year developing my own application intended for .accde at initial launch this is the last thing I want to see. Credit to the author a beautiful brain. Did anyone try it out?

Be like Access I'd imagine; primary key at parent, infinity at child both infinites would end at a joining table. I'm sure your sort of calibre knows this & you've just put this as on off-the-fly comment. Thanks Albert, credit to you a lot of people don't admit when they're wrong. I also don't...

No that's not the protagonist, @tvanstiphout & @BlueSpruce got it from OP. I've regurgitated the topic many times now. Thanks for trying though (y), last thing I want to do is be rude. Your effort was appreciated.

Absent in GUI in Nr-3...

I could not agree more. I think it'd be a relevant counter-argument if there was not many GUI's, but there are thousands for such trivial things, yet to repeat myself yet again, probably the most important thing in a db (normalization) is absent.

Yes George, I appreciate that, but given the thousands of GUI's/ panes which do have direct selection for every property/ attribute/ object known to man in a single click through a GUI; yet absent on one of the most fundamental concepts of a db I find shocking. I do appreciate my lack of...

I'm only able to view Properties; which don't seem to have the join-type, which lead me to pic's posted in Nr-1.

Thank you @BlueSpruce, oh so endpoints are different like other software. I'm still really surprised there isn't more functionality in separate panes on this topic being normalization is such an intrinsic topic in db's.

Thanks @BlueSpruce, yes I've done this. The properties & objects pic'd were from the relationship diagram on a single click selection. As stated double-click does not work. Where does one actually see the join type; as stated I can't see it in the pic's posted. Are the endpoints different...

Thanks Tom that is helpful, but wow what a headache. On such an intrinsic, core area of normalization there must be a simple quick way built into MSSQL :eek:. So we can see the relationships between keys in the Object Browser & it's Properties Window when clicking the relationship in Diagram...

I'm pretty sure I tried without encryption, also removing the password argument entirely, & without Trust Server amongst countless other things for a few hours. I'll try again later, atm I'm just grateful I got my data in there & a mountain of things to learn. Obvs better to use latest driver I...

I don't know why mine wouldn't work, I spent hours on it, just could not get it going.

Sorry @temple owls, I gave bad info. No matter what I did i couldn't get it to work.

Thanks George, yes I thought it strange. Strange the link to Youtube didn't work. I've edited it again just in case. Trying again via 'Media' in case that works.

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