Search results

The main problem is that it's a loosely structured, report focused database. The OP is experiencing the headache of maintaining this visual first design. We are now 145 posts into "Clear out data"

I disagree. AI won't hurt seasoned developers any more than MZ-Tools or similar utilities. You still need to understand the basics. It's like putting two drivers in race cars, one a professional and the other a novice. The outcome will be vastly different.

I took the liberty to ask ChatGPT to look at the following picture and redesign the schema to N3 with joins. The redesigned database as follows 🔶 MAIN TABLES (Entities) 1. FamilyMember FieldTypeNotes MemberIDAutoNumberPrimary Key FirstNameShort Text LastNameShort Text...

I'm sure this has been mentioned. Each family member has a unique login that prevents them from seeing other sensitive records, no need to delete any records because they can only access their own personal account.

I smell a VIP in your future:p

Who's the lucky MOD tasked with keeping track of this?

This is a fascinating read. It reminds me of the mistakes I made early on with my first databases. Those were frustrating times, trying to apply best practices to unorthodox designs. Man, that was tough.

Is OneDrive active?

Did you look in the trash?

Well it is Microsoft product and it is free so....

No good deed goes unpunished

It’s a risk some of us are willing to take in order to help others and learn something new. Not every organization has someone on staff who can write code or the budget to build something from scratch that’s just not practical. It’s far easier to sit on the sidelines, watch people struggle, and...

That’s the nature of programs like Access and Python, any novice (like myself) can start tinkering immediately without formal training, which can lead to unexpected exploits. Unfortunately, some of us feel compelled to help because proprietary software doesn’t always fit every situation...

Just don't use a Debian version, it doesn't support most laptop WiFi adapters, while Ubuntu has everything you need built-in. Edit: I added the word "laptop" for clarity. Debian does support generic WiFi Dongles,

Access is fantastic if your organization supports using it. But, alot of us fall into a different category. We see an issue that Access is perfect for solving, but IT and management are skeptical of it, creating the classic Access struggle.

It’s weird because I never hear this kind of criticism with other similar products. There’s always this cloud hanging over Access sometimes it’s the community, other times it’s the perceived lack of interest from the Microsoft Access team. It’s all very confusing.

The member of the suite they fear most is the one they understand least.

Yeah, pretty much every government workstation has a copy of Access preinstalled, but hardly anyone knows what it actually is let alone how to program with it. And when it comes to IT departments, they're almost universally against because of it ability to run automated.

True, I might be easily impressed, it was like magic to me 20 years ago.

I worked with a guy who was able to get Excel spreadsheets to work on a smartphone for light inventory purposes. I understand that Microsoft Access is a completely different animal.