Search results

I HEAR YOU. Unfortunately, the choir "attendance" is few. Incredibly, you would think the Indian outsourcing competition would have boosted attendance. I fear it has not. Instead, the few who do attend, do not listen to the "gospel".

Below is UNQUESTIONABLY the "Poster Child" of the special interest group known as "Programmers Who Disdain Embedded-in-source SQL and/or Touchy SQL Syntax": Read all in it's glory here: http://www.utteraccess.com/forums/showflat.php?Board=82&Number=1755780...

Agreed. But a poor one at that. Good 4th or 5th G/L's don't bust your chops over rigid syntax requirements and exact statement ordering. They're design is to solve business problems quickly, not to bog down the developer in technical details.

I've got no experience with ADPs. Other than security, and ability to handle millions of rows, what exactly are the other benefits of going with SQL Server or the Express edition ?

No confusion....above is what I meant. The ability to have objects like queries, and then be able to clone them and modify them is just powerful IMHO. It's a shame however that PARAMETERS were never extended to permit SQL full code fragment replacements (so I created my own). I really disdain...

Thanks Pat for that tip on the need for Citrix to be set-up with multiple profiles. As far as Jet goes, I know they've made improvements with the 2007 release. Nonetheless, my experience has been that for MDB read/writes Jet/DAO is so much faster than ADO. In fact I've nick-named the latter...

Oh boy, what a "duh" moment for me....that's probably it ! On a similar note, can anyone give me an idea of what the performance hit would be to run any version of Access from a file server vs. locally. Also, what about the licensing ? Does MSFT check for the number of concurrent users ?

Thanks much Simon for the technical discourse....much appreciated. I just met with my client yesterday and he indicated that he was unable to run an Access97 application using TS and RDC. However, he was able to run a VB6 application against the same AC97 MDB files on the network drive. Thus, I...

You bring-up another interesting point....VPN. Is it required ? Can the packets really get sniffed ? Does it slow-down the TCP/IP connection much ? Does the software layer needed cause side-effects or performance problems ?

Thanks much....I am glad to see Access able to work well remotely....that's another thing I can pitch. BTW: Does Terminal Services need a dedicated server box ? What kind of load is put on a server with say 10 users all pounding the keyboard at once ? Also, is T/S plug-n-play or is there a lot...

Yes, and along those lines you guys are using the ever-so-excellent STARTMDB.EXE program that is packaged as the autoFEUpdate utility, right ? I'm not sure how it works in a TS environment....does each logged-in user get their own folder/directory ?

Not to mention the frame or body as well....:D

Thanks but interestingly one Access MVP and consultant told me that he thought this set-up was subject to MDB corruption. However, based on your explanation, I don't see the problem....at all.

I would think twice about that statement....with all of the IT budget cuts going on right now and the scrutiny of green eye shaded accountants who are running the show now-a-days. Wouldn't it be foolish if they spent $100k now for an ASP.NET CRM only to discover in a year they could have done it...

Thanks Pat, but I was told that using Windows RDC (Remote Desktop Connection) can cause data corruption. Is remote access via terminal services or citrix completely reliable as far as database integrity goes ? Again, the only reason I am recommending Accdb as the database right now is the...

Unfortunately, we DO have reprogramming....going from VB6 to VBA for one thing. However, this is minor compared to a total rewrite IMHO. Well, my sense is that Microsoft's new Azure platform is going to make ASP.NET coding look foolish within the next 1-2 years. Everyone's going for web dev...

One might ask why ? Microsoft Online is now practically a free sharepoint hosting service. Yes, but the ASP.NET rewrite is estimated to be 1+ man-years of effort....too expensive for this small client. This is a highly customized CRM for which there are no packaged CRM solutions, no frameworks...

I very much appreciate your reply Pat. Regarding the volume issue, I've heard of other developers being able to access up to 60,000 rows in Sharepoint lists....and that is the max this application would ever have. Tell me if I'm wrong on this, but I've heard of many problems in developing apps...

The current system is undocumented and the code is uncommented. It is essentially unmaintainable. Yes, the client has multiple locations around the WORLD. Collaboration is needed. Web updating is needed. Sharepoint via web is the perfect solution IMHO for the lowest cost. ASP.NET would be very...

I've been getting a lot of criticism for suggesting the above solution for a client. Here are the key points: 1) Backend database is already in Access MDB format; 40k lines of VB6 code - ADO access method; this is a customized CRM application with many relationships. 2) data volume is small -...