Search results

Probably no real options here. While networks and WANS have vast improved? I think remote desktop is the better choice. However today you can get away on a good solid network. We often have some users in a different city accidentally connecting their front ends through the VPN when they should...

That is correct. However, when you use ODBC to a file based system like a accdb file? It's resolving to a file path, not a tc/ip socket connection. It's still a file - even when using ODBC. And even if the file is sitting on a shared folder? It's still a file, and standard windows file path...

No, it's better that Access does not use ODBC - it uses the native JET/ACE software stack to do this. And thus the result is not only better but since there is no server when using a Access back end? Then Access does not pull the whole table down the network wire as a result - this is good...

Yes, correct. So, no sql statement at all - just the view name. You find that form loads a bit faster - but only when you have say beyond 3 or more combo boxes will you start to notice this "small" reduction in form load time. So, not a huge deal, but yes, in the combo source, don't place...

Yes, but note the above trick - if you JUST use the view name - no SQL for the combo source, the form loads even faster. You not notice this effect unless/until you have about 3 or more combo's on the page. So, it's a "minor" issue, but I have seen this trick reduce form loads times. So, for...

Another trick that helps? Just specify the view for the combo box, not a SQL query. They again will load faster. This can't always be done. But, if you have say 3-5 combo boxes on a form? You notice a slight improvment. So, JUST the view specifed for the combo box source. Now, to be fair, views...

As noted, PT queries and a combo box don't play nice here. Access client can't filter the PT query correctly. And for messy sql? Again, move to server, and then base the combo box on that view...... So, a PT query for a combo box simply does not work well, but building the view and using that...

I can't agree more. Really, with the modern hardware we have? It near all comes down to design, and the gains to be had for today's standard and decent hardware? Not going to help. A mid range, or even bottom feeder computer today gives you what a state of the art $10,000 computer was 10 years...

Actually, I can add one more FYI to the issue of combo boxes. Do NOT use a pass-through query to drive a bound combo box. But, why? This advice seems counter intuitive, since after all, a PT query is perhaps the fastest performing way to pull data from SQL server, right? Well, there is one...

yes. in fact, the #1 developer time saving tip I can share? Any time you have a query with multiple joins? Convert that to that to a SQL view, and link to that view. But why this suggestion over say a pass-through query, or even perhaps say some stored procedure on SQL server? Simple: cost...

Well, as noted, you can get more then 1 second for some disk intensive tasks. So, the better disk can help even more - that 15 seconds vs 14? Probably not going to be noticed. No real changes to my previous advice here. Anything more would be beyond my pay grade and knowledge..... R Albert

Could not agree more! And, I not a big hardware guy, and not a gamer. Really, today we are spoiled with hardware. So, for me? Just about any machine today is more computer then we could dream about years ago. I often when dragging and copying a Access database - say 130 megs? You can drag...

Well, things have vast improved over the years. So, while at one time, say a VPN between two locations, and running a split Access database? Was not that practical. Now, well, actually it is! However, if the VPN was being used say by “at home” workers? Then that falls down, since it not all...

Ok, now that changes things a wee bit, but again, with hardware where it stands? Well, since the network bottleneck is gone? Well, as long as one has a multi-core CPU. And these days, that's probably a min of 6 threads, and more CPU's? Then that will suffice, and once again, throwing more...

The problem is that if you do what I done for years? That is build the relationship using the UI/diagram tool? You THEN set/create the index after? (which is what most people probably do....) The diagram does not update - so, you don't notice this effect. I ONLY noticed this, because I was...

Ok, I HAVE to do a follow up post! One of the things I love by helping and posting to the community here? Well, you find out VERY interesting things! While I made a long winded post about how SSMS does not really tell you the difference between a one to one, and one to many? I am WRONG!!! -...

If just looking to add content, information, then some type of CMS as WordPress is a really great way to go. But, if you looking to build say forms, code and an applicaiton? (like moving some Access application to the web)? Then of course a different road is required....... And don't worry -...

LOL!!!! - don't get me started on that issue! (as a FYI: I actually was one of the few Access developers that supported this amazing feature!!!). R Albert

Actually, the answer is a round about way is kind of funny! SSMS designer lets you setup relationships, but it actually NEVER calls them anything! (so, no names like “one to many” or “one to one” etc. is ever used, nor displayed). On the other hand? I don’t consider that a many to many...

If you 100% local, no network involved? The having a really great and fast hard drive is the ticket. In most cases (at least these days), Access is not limited by CPU cycles - we have boatloads of those. Hence, in near all cases, it's not CPU, but WHEN access has to use/get/grab external...