Search results

Sub SendStatusFromSlaveToMaster() Dim Connect As Object Dim sDatabase1 As String Dim sDatabase2 As String sDatabase1 = "C:\Master.accdb" sDatabase2 = "C:\Slave.accdb" Set Connect = CreateObject("ADODB.Connection") With cn Connect .Provider =...

What does that have to do with one accdb opening up another accdb application and automating it? You're telling me the accdb that opened the other accdb cannot find out if a form IsOpen, close it, or close the app, even though it created that instance? This has been done before. The accdb...

What if an additional accdb could be setup to act as a network monitor that periodically checks the status of the connection and the status of Access app? It could force via automation the close and reopen of app if close/reopen of the form fails, or the instance simply doesn't respond? The...

They've been spying on us ever since we started using cell phones and the internet. Fir all we know, they have the ability to listen and see everything we do in our homes, car, everywhere we go with our devices.

I get it, but based on what you and @The_Doc_Man have explained, plus my comments about the FE and/or BE possibly becoming corrupted, perhaps it's better to close and reopen the FE. What you propose is to use the On Timer event, the same way we implement auto exiting the form, or the app, after...

One way, or another, those in power will find a way to totally control society 😕

So there's no way for speeding up recovery unless the device driver or the OS layer is modified, and that wouldn't happen anyway because it would deviate from standards?

I can tell Google is scanning every word of our posts. In another watercooler thread about Late Stage Capitalism, we started discussing car stereo systems and sure enough all the ads are about car stereos 😒

Even if all I metioned in my last post were possible, the FE and BE might already be in a corrupt inconsistent state and a CR would have to be done. Each of our workstations have a desktop shortcut that copies the master FE and launches the clean FE copy. ReLaunching the FE copy is actually...

So can the disconnection be detected sooner, reconnection happen more quickly, and continue where it left off, without having to close/reopen the form, or the FE?

Ha, I remember John Sirica, the Watergate and Admiral Poindexter/Oliver North Judge. My driver license says driving a vehicle is a privilege, not a right. So for that "nobody owns vehicles and pay by the mile" model to work, the government would have to revoke everyone's driving privilege and do...

And that's the reality of it. Here we are trying to extend an X-Base tool to do things that commercial grade db servers with transaction monitors are capable of doing.

I don't think you can rely on the increase or decrease of AWF members, posts, to determine if more or less people are using Access. I know several Access developers and users who have never joined AWF or any other forums. Then there's millions of Access apps out there, including many mdb's that...

The accdb may already be in a corrupt inconsistent state even if you were to close and reopen the form. What about if the problem happens while an update query or internal housekeeping is in progress? Being that Access is closed source, what would you suggest to the MS team for making Access...

Most db servers support atomic transactions, but Access ACE engine doesn't. It also doesn't have transaction logging with record rollback, or make use of a before image, or checkpoints.Even if you were to link an Access FE with a db server backend, the FE is still going suffer damage with a...

Okay, but why is the dropped packet not detected by both SMB and the listener (Access), discarded, and retransmitted?.. It's not the case that the whole packet was dropped, rather Access received part of the packet, or the packet contains garbage caused by interference, and now the accdb file is...

I would've thought good error detection, correction and retransmission of packets was built into SMB, and other networking protocols. However, in this thread I was told Access is the problem:

Yes, I remember seeing that, but it only applies to ODBC for SQL Server, and doesn't solve the main problem of network interference and delays causing accdb corruption.

And for the above reason is why ODBC always requires login when re-connecting to a db server? In a previous post I mentioned that Access' file server architecture and SMB are part of the reason why Access is intolerant to network noise and latency, but I was told SMB was irrelevant. We use...

I kno that. I was referring to the C# you mentioned. It's a lot easier for a team to work with external code modules versus code encapsulated in accdb containers.