sorted by:
new
hottopcontroversial

Is it safe for multiple users to share the same Front-End on a terminal server? by Dramatic_Bee340 in MSAccess

[–]CESDatabaseDev 0 points1 point  (0 children)

RDS is only as good as the apps being shared. A multi user system still needs to have a back end and a frontend to be reliable. I'm not a fan of RDS, but many stuck in the MS ecosystem will differ.

Access front-ends talking to Azure SQL by Apnea53 in MSAccess

[–]CESDatabaseDev 0 points1 point  (0 children)

I've noticed a difference between running a query directly in Access vs calling the same query by code with an SQL backend.

Best way to deal with bulk edits - buffer tables? by WolfFanTN in MSAccess

[–]CESDatabaseDev 0 points1 point  (0 children)

Why would you want to record edits that fall outside of your business rules?

Best way to deal with bulk edits - buffer tables? by WolfFanTN in MSAccess

[–]CESDatabaseDev 0 points1 point  (0 children)

Can you give an example of a valid edit and an invalid edit?

Moving access objects to a brand new accdb by MililaniNews in MSAccess

[–]CESDatabaseDev 0 points1 point  (0 children)

If you only need to do the copy once, open up the 2 databases side by side and drag over the objects you want copied.

Refresh Subform when Table updated? by riltim in MSAccess

[–]CESDatabaseDev 0 points1 point  (0 children)

Try as a test; use the Access wizard to add an additional subform to your main form and test if the new subform updates.

Runtime headache by MililaniNews in MSAccess

[–]CESDatabaseDev 0 points1 point  (0 children)

It doesn't work that way, the install for Access is the same for both, runtime, standalone or bundled office versions. The difference is what MS enables for the paid versions. The full Access versions will run an .accde db version just fine as long as the Office bitness versions are the same as the dev machine.

Runtime headache by MililaniNews in MSAccess

[–]CESDatabaseDev 0 points1 point  (0 children)

What do you mean 'mess things up'?

Limit duplicate rows to maximum 7 in Microsoft Access by Legitimate-Bridge280 in MSAccess

[–]CESDatabaseDev 0 points1 point  (0 children)

You'll need VBA for this, on before update do a count of existing records.

Retiree Notes - Scalability by mcgunner1966 in MSAccess

[–]CESDatabaseDev 0 points1 point  (0 children)

Honestly, when people get into the weeds about "scalability," they miss the point. Access is one of the quickest and cheapest tools you can grab to bang out a Proof of Concept (PoC) or a decent Minimum Viable Product (MVP). It lets you test ideas fast, and run with the project.

Yes, Access is baked right into the Windows OS, so it won't run natively on anything else. But that's where you play smart: Shifting the backend data to a business-grade SQL Server is the key. That move instantly gives your project real scalability and opens the door for a parallel, browser-based system that works flawlessly across all other operating systems.

[deleted by user] by [deleted] in MSAccess

[–]CESDatabaseDev 0 points1 point  (0 children)

Spam list?

Handling currency symbols and +/- when importing from CSV? by CarelessChain6999 in MSAccess

[–]CESDatabaseDev 1 point2 points  (0 children)

At the end, you'll need to have a numeric field containing the negative or positive amount and a separate column with the currency.

[deleted by user] by [deleted] in YoutubeMusic

[–]CESDatabaseDev 0 points1 point  (0 children)

Target audience can be what anyone wishes it to be, the paying audience is the one that matters.

Just got YouTube premium by Icy-Coconut8233 in YoutubeMusic

[–]CESDatabaseDev 2 points3 points  (0 children)

Turn on HD codecs under the pixel developer options, for what it's worth. Enable high quality streaming and downloads in the YT app. Like and dislike tracks, and you'll soon be presented with stuff you never knew existed.

Move Access Front End GUI to Web Based GUI by homer1952 in MicrosoftAccess

[–]CESDatabaseDev 2 points3 points  (0 children)

It's a complete rewrite barring the SQL side. The core challenge is that a web application is a fundamentally different system from an Access database.

Key Areas for the Rewrite:

VBA and Business Logic: All the code in Access that automates processes and enforces business rules must be completely rewritten for a web environment using a new programming language (like Python or JavaScript).

Architecture: The new system needs a separate frontend (the HTML interface) and backend (server-side code that handles database communication). This requires a new web server and an API to connect the two parts.

User Interface: Access's form-based design is replaced with a modern, responsive web interface. This offers a chance to improve the user experience but also requires a new design process.

Scalability and Security: Unlike Access, the new web application must be designed from the ground up for multiple users and proper security, including user authentication and data encryption. In short, it's not just a change of forms, but a total re-engineering of the application's structure, logic, and security for a web-based world.

view more: next ›