Search results

Thanks all for your honesty. Thinking of network performance with Azure, doing a very rough calculation (no doubt wrong :p) I have around 108,000 records * 6 average sub-records = 648,000 sub-records in this one area alone. relating to one container. I won't go into detail spilling out my...

Life is short, do what you want I think. But credit to you, it mustn't be that bad for 15 years of use & so happy that don't want to greatly deviate.

Int > TintyInt/ SmallInt/ BigInt... Seems no point in wasting space with some of these. I don't need to waste space generically assigning these data types with the PK's/ FK's to int. Don't get me wrong some will be, but I'm going through them now determining what sizes I reasonably need for...

EDIT - On closing & reopening MSSQL the changes have taken effect fully. I can handle the 4 FK constraints manually; that's no big deal but would appreciate if someone can help in doing this for PK's? After importing to MSSQL I want to convert certain FK's/ PK's data-types. So need to drop all...

Persevere, you're close. I struggled with this also. You're wrong on below, but logical so don't beat yourself. Pretty sure I did exactly that when experimenting also. qdf.Parameters(sPar1).Value = sFreq It's possible. If your intent is to set the parameter in VBA & run the query (you will not...

Oh dear, this is really not good for me 😭.

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.