Hi George,
Thanks for still offering your opinion. Again though, this goes for anyone willing to answer, can you paint the picture of how exactly the hacker can get in? Theoretically, what are the weak points of an application as i described considering all security steps are taken?
@GPGeorge thank you so much for offering your advice. You've given me a lot to think about.
This is indeed sensitive data that should have security at the forefront. I was insisting on illustrating scenarios where there would be a breach in confidentiality regardless of data being comingled...
:ROFLMAO::ROFLMAO::ROFLMAO::ROFLMAO::ROFLMAO::ROFLMAO::ROFLMAO::ROFLMAO::ROFLMAO::ROFLMAO:!!
Tbh I find comfort in knowing no application is perfect. It gives me affirmation that I can get there and I'm allowed to make mistakes.
This is precisely why I value this forum. Your input is invaluable and I will do as suggested with taking some courses to get up to speed.
After much introspect, I realized I'm not equipped to handle this venture on my own which is why I hired a developer with an existing team. He was kind...
How can I facilitate interoperability between these databases?
Globally, there is a huge push towards interoperability between pharmacy management applications within a given jurisdiction. To date, the United States has difficulty achieving this despite government incentivized initiatives and...
I appreciate the concern. Forgive my ignorance but I don't see how data can potentially be released without access to it.
Kindly educate me on the risk and what are my options on remedies?
The developer is using React JS. I have researched it and I am happy with the choice. I look forward to my application in the new year when my "team" will have something to show my customers.
Im not hosting the front end via sharepoint synced folder any longer. As @The_Doc_Man correctly predicted, I have experienced performance issues when the sync folder connection lapsed. However, it was not terrible, just embarrasing when it happened. I would also ensure that you are always...
So I did it!
Function QOHComp_Q()
Dim db As Database
Dim qd As QueryDef
Dim qr As String
On Error Resume Next
Set db = CurrentDb
On Error GoTo 0
CurrentDb.QueryDefs("PassThrough_Q").SQL = "SELECT " _
& "Concat(ChildDrug_T.GenericNameStrength_childdrug, ' ', Form_T.Abbreviation_form) As...
The only reason I'm not using the query built in access is due to performance. I am currently waiting 10-20 seconds for the form to open to display the results of which is unacceptable.
You are spot on with the sql view route. I've created both subqueries in sql view and have joined them to...
Hi there CheekyBudda,
1. Yes I'm supposed to add a concatenated statement to show which staff member is responsible for the transaction.
2. Correct. Abbreviation_form is from table Form_Y.
3. I did not use the above statement as a pass-through query. I couldn't get the pass-through query to...
Not sure if I executed it correctly. I got nothing.
But from what I see when then pass-through query is generated, if the stock out is null then it equals the stock in for some strange reason.