Search results

No login info is saved in connection string. As I said Windows Authentication is used. So there's no login info at all. But you can not hide the server name, and database in connection string. Can you?

@BlueSpruce One last question. Do you know you can open your FE and while the FE is opened, launch another database and from there, read the connection string of your FE's linked tables to BE?

Thanks. I'll pass the words to our IT.

Where I work, (like 90% other companies) most of PCs are only terminals. I'm sure you understand how a terminal in an Active directory work. Anyone can sit in front of one of these terminals, and open one of our Access databases to work on it. And because mostly Windows Authentication is used...

If your FE is Access, you can open a blank database, write a simple code to return all tables and then theri fields in your FE. You can also run an update or insert query from a database outside your FE. You can hide/unhide tables in a FE using a remote database, or change FE's properties like...

While all the the mentioned pros of an in-house solution is correct, you guys forgetting about the security. If you own a business, security of your data stands ahead of everything else, and well....all of us know that Access is amoung the least secure apps.

They forgot to say being unemployed is the least risky job to be affected by AI. :)

A new Microsoft study of 200,000 Bing Copilot chats reveals which careers are most exposed to generative AI’s impact. 🤖💼 They found roles focused on writing, teaching, advising, and providing information, such as translators, writers, historians, sales reps, and customer service agents are most...

I didn't oversimplify anything. I only showed that jobs come and then vanish. With each improvement in technology, there's no room for certain jobs. You have two options. Prevent the improvement of technology to keep jobs being vanished, or enforce it and accept the current situation. I simply...

Thanks. I'm away from my PC. I'll check it as soons as I'm back. I appreciate your input.

I'm not a fortune teller nor a prophet to know how the future works. But according to human history, I proved that every year a lot of jobs are vanishing because of the improvement in technology. There were lamplighters to light candles in street lamps. With the invention of electricity, that...

Why are you afraid of jobs being lost? With every evolution in technology, there were a dozen jobs that vanished. Do you regret that? Switchboard Operator Replaced by Automated telephone switching systems (1980s) Film Projectionist (in small theaters) Replaced by: Digital projectors and...

Who told this? And why do you think Ai was built to work for us, not replacing us? My understanding is that AI was designed and made simply to replace human. Am I wrong? Here's a part of my research (several months ago) The Original Proposal: Dartmouth Conference (1956) Source: Dartmouth Summer...

That's desirable. (I assume.) After converting data type from real to money, I don't care about the fifth decimal points onward. I need to have my data to be with the same integer and same first 4 digit after decimal point. If my data in table is 12.0012345678, I need to have 12.0012 as my...

I have a table in a sql server which is accessed by a Microsoft Access FE. The mentioned table has a field named "Multiplier" with a "real" data type. It's used for some engineering calculations. Because of a change in our company's policy and the problems with real data type, I'm considering...

Thanks for posing it here. I just wanted to see how you've done it. Thanks again.

@MajP what happened to your faking MVF post? Did you deleted it? Why it does show up? https://www.access-programmers.co.uk/forums/threads/faking-a-multi-value-field.309635/

I was fascinated by @MajP's job on drag and drop items on forms in the following two thread. In each case, Drag a circle in the left side of the form with your right mouse button and drop it on the floor plan or the ship. Then select the color...

Maybe something has changed after my version (2505). I'll ask the IT to update my PC and will check again. A csv file for the second query is attached. Change .txt to .csv Thanks for testing.

I'd like to, but I can't. Because Access doesn't save the query and shows the above error message. If I turn off Monaco, Access saves the query and runs it without problem. If I try to edit the sql of the query while Monaco is ON, it fails to save and shows the exact same error. I think you can...