Search results

Yep, it's a problem in MS dbs, because MS has never gotten their hands dirty and figured out how to properly distribute a db remotely. That doesn't mean that others haven't done it successfully.

Thanks, you just got added to my favorites, and I look forward to learning from your examples.

Oh, please come and tell that to the government agencies I have to work with. And not just the government. My bank has me logon to my account here over the WEB with my four-digit ATM PIN. How hard is that to crack?

Now I got to add a field for name and not number on the street. Here we go deeper in the rabbit hole.

I started my old application on 10 mb and in production had to go to 30mb. I can't imagine needing 2GB unless ACE handles variable length fields poorly. But some client may want the entire world of addresses, you gotta plan for the worst. That's why I'm thinking ahead for a possible split be...

I think you missed the part where I said, "when one splits a backend db". But you did confirm what I said. You're right, I hadn't checked for your great message, one hour or so, before I wrote my question here (then again, it wasn't my original question, it was more of an tangential observation).

Yes, I studied Cobb in university, and I know some mainframes from IBM had started implementing the ideas. I ended up working with Reality/PICK/D3, which in another forum I stated was pretty basic. Here's a file structure, here's a query language, here's a BASIC that works with the query, good...

Thanks, mine was VERY scientific too--printing Snoopy calendars.

As you can see, I used that trick too. Ha ha

I'm planning to use formatting in tables because I am writing the software for Spanish, Portuguese, French, Italian in addition to English. No one format will serve all countries, so formats become dependent on the country and type of POC it is. Like my foreign language translations, they will...

Why put email addresses with phone numbers? Following your design, shouldn't emails be in their own table?

Let's Let's try this one more time. Here is the report for the table where the group descriptions came from. This one table can replace over 65K (254^2) tables with good design. Some of the data was just experimental and other to show how permutations work.

Look below, I have no idea what I'm doing wrong to get a reply to attach to another post.

The group fields that you see in the report aren't related to departments directly. I add those group fields to my designs to allow users to add their own "special" fields that won't impact my design. In the example, Grp1 shows if it's a corporate or branch type of department, while Grp2 is...

I replied, but I have no idea where it went.

If you started in the 60s, how is it you look younger than me? Share the secret friend.

Here’s my first post to this forum, and it’s going to be a doozy. I’m coming from a mini/mainframe environment, where things weren’t normalized very well. But as I go down the rabbit hole of Access, I wonder which of two approaches might be best for flexibility and usability. I’ve created these...

Hello, I'm Thomas (but here in Colombia, Tomás). Professionally I was known by T. Wade. I started programming in Assembly and Fortran in university in the 1970s and got addicted. My degree was in business and accounting. I grew up in Santa Barbara, California. I spent a lot of time trying to...