Search results

At the end of the day, the bottom line is that it's not difficult to enable the navigation pane and other db properties of encrypted FE's, which are used for opening forms to view/edit decrypted data stored in password-encrypted backends. It's very easy to export all the data displayed in those...

Yeh, one cannot do it all with vba inside an open Access FE. Disabling wifi and backups are recipes for corruption. If you can't determine whether ethernet or wifi is being used for the Access table links, then temporarily disabling all network adapters except ethernet before launching the...

When the FE closes, control returns to the cmd script that launched the FE and a PS command can enable the wifi.

That being said, if the main objective is to ensure that a wifi connection is not being used when opening an Access FE, then how about disabling wifi with a PS script that runs when users click on the shortcut that launches the Access FE?

Hmm, there are PowerShell cmdlets for reliably detecting if ethernet is connected: If ( (Get-NetAdapter -Name 'Ethernet').MediaConnectionState -eq 'Connected' ) See: https://devblogs.microsoft.com/scripting/use-powershell-to-disable-wi-fi/ Maybe it was not reliable because WiFi adapters are not...

I thought a solution for that was recently solved by you and ADezii in a UA thread?

There's only so much you can do in a browser-based app versus desktop Access. Web browsers are stateless clients, which means everything is done server-side and the browser just displays it and accepts keystrokes, kinda like a dumb terminal, or a streaming terminal server. For security reasons...

The main reason I am keeping the Access versions of my pawn app around is because most of my clients prefer the rich functionality it offers, e.g. office automation, and they feel their data is more protected by being offline. However, a browser-based version on a private-facing on-premise...

Understood. The demo will have everything the standard version has. However, the demo will only allow limited number of records, ficticious store name/address, and all objects, including the tables, will be together in one encrypted accde. I have been maintaining several customized versions of...

But there's always something different that each customer wants and I am willing to accomodate them as long as it makes sense and does not detract too much from the standard design. Many a times I end up talking users out of making their suggested mods because they're spontaneous "what if" ideas...

For security reasons we stopped using Desktop Office Outlook one year ago and have been using Online Outlook. Has anyone been affected by the Hafnium attacks on Exchange Server? See: https://msrc-blog.microsoft.com/2021/03/02/multiple-security-updates-released-for-exchange-server/

@gemma-the-husky Thanks for the well wishes. A lite standard version is what I am providing for free and the desire is for each pawnbroker to request customisations in order to offset the loss of revenue from giving away the lite version. All versions are table-driven and allow users to change...

You can go into your printer preferences and setup a custom paper size. Then in your Access report page setup you can chose that paper size. You can also create a new custom form in the printer server that can be used with any printer.

The free live version, sans any customisations, will be split FE/BE. I will do my best, hopefully with @isladogs help, to lock down the demo and live password-encrypted accde FE. Meantime, for the demo version I just deleted all the BE table links, imported sanitised/compressed BE tables to...

Okay thanks. Me thinks MSRC rejected my submission because MS' priority focuses on the online M365 product. I pointed out all the loose ends I found in compiled accde's which need to be tied up. Perhaps approaching the MS Access Team would be more effective. I will email you, thanks!

You're Welcome🙂

Welcome Patrick (y)

@isladogs , Ironically, I am planning to distribute a free templated version of my pawnshop management app to select pawnbrokers who will pay for customizations and I need to really lockdown the FE and BE from intrusion. Can you further harden your demo challenge? See my related post...

Thanks for the advice. For the demo I am limiting the number of customers, contracts, transactions that can be added. I was thinking that by combining the frontend objects with backend tables into one password-encrypted accde that it will only work for one seat. If a prospect likes the demo and...

Hi Pat, the dark theme is popular and the color-coded text has meaning, e.g. green money, red warning, blinking red requires immediate action, yellow and large fonts important, etc.... I have 65 sites using this app's theme and they say the black background is a lot easier on their eyes than...