Recent content by aaronkempf

I used to work on a team that used SQL Server Reporting Services, and then we wired SSRS into a product that allowed people to CUSTOMIZE the reports in word before sending them. It was a royal pain. But to ME? I'd move to SSRS and ditch Access Reports entirely. I mean it might not be SIMPLE...

I detest watching stuff like that on YouTube. I mean, to ME, I would much rather read about it than watch a video. I can READ about someting while I'm watching a video about something entertaining like Bebe Rexha or something similiar. I never really understood why the idea of watching a VIDEO...

if you were talking about a MSSQL database, then I would start by creating these two indexes for this query: UPDATE usermanagement SET usermanagement.tblClients_fldDRCClientID = ( SELECT MAX(fldDRCClientID) AS MaxOffldDRCClientID FROM tblClients ) ORDER BY id DESC limit 1; CREATE INDEX...

I'd start by getting rid of ALL of those awful parenthesis. Access randomly adds those in to help, and I think that they are hogwash.

It could be called a 'factless fact table'. I can't remember I think that is Ralph Kimball's invention. It might be Bill Inmons. they are collectively the 'godfaters of datamarts / datawarehousing'. I've seen a ton of legit situations where a PK *COULD* be comprised of a half dozen columns...

what is the extension ACCDR for ? Runtime? I used to play around with swapping the extensions of MDB and MDE and tricking people into thinking it's one thing, when it's really another? I wish I knew more about how it worked on the INSIDE. But I've never heard of ACCDR!

I've recently seen SQL Server be able to do this fairly easily. Of course, SOAP has been built into SQL Server for 15 years now, and it's highly extensible with SQLCLR. I wouldn't wish a newbie to run into using SQLCLR without a LOT of patience. I mean, just the development methodology, from...

I was recently playing with a dataset that had 43million records in about 4gb. My biggest problem with the limitations in Access has to do with the COLUMN count, not the rowcount. I once was interviewing at eBay for a VERY high end job. and after 8 hours of grueling interviews, this guy tried...

I am beginning to like this community. I was a troll for many years, and I'm still FIGHTING irritated that they killed ADP. But still, you guys are a good group, you speak the truth, and I've discovered and read some high quality stuff here so far. I hope you guys keep me around (as opposed to...

I just didn't LIKE how I was out selling people on MS SQL Server, and then Microsoft pulls the rug out from underneath me, and they cancelled a superior product. Maybe I should have been clued into the FACT that ADP were kinda marginalized in 2007 and 2010. But still, to this day, I'd rather...

and then a couple of months later, I walked into a company that had about EIGHTY Access applications and databases. I mean, I still don't understand how a company can have MORE Access applications and databases than they have EMPLOYEES. But the Access databases they scrubbed the data that was...

I was POSITIVE that I wanted to work doing databases. I mean, the Visual Basic side, it seemed kindof beneath me, and I was a real 'go-getter' at that time. For example, on this project at Microsoft, we had 15 people sitting around in a room, asking 'How are we going to finish this project on...

But I did. I mean, I started writing macros in Excel to do all of the formatting. I would take the Log file (that was still being written to) and open it in Excel, do stuff to the columns, record a Macro, and then to modify the macro that had been recorded. I mean, it was a struggle to figure...

Hello I've been using Access for 23 years now. I mean, when I first SAW Access, and what it could do to transform a company's communication; that was when I went back to college in order to study databases. I was working as a QA tester for a video game company in the summer of 1997. I had...