Database launching opens in break mode

[ML!]

Database opens in break mode

I can't recreate this on my local copy but my db launches in break mode on another workstation. The debug window opens which of course confuses the user. The db is split with the tables on a shared network drive.

Error trapping is set to break on all unhandled errors and when I compile the db from the debug menu, it doesn't break at all.

Any ideas?
ML

 

[RuralGuy]

Same OS and version of Access in both cases with all patch levels applied? Is a line highlighted when the system brings up the edit window?

 

[ML!]

Hi RuralGuy

Same version of Access, OS is different. I'm on Windows 2007, they are on XP. There is a highlighted line and before I posted here, I did ask but am waiting on the user to tell me what it is.

It might be this code that refreshes the backend table links because it is the only code that's different between the 2 copies...

(Note the path is 'representative' because the real path identifies the company.)

Public Function RefreshLinks()
Dim tdfTable As TableDef
Dim strPath As String
 
  Set dbsCurrent = CurrentDb 'dimmed as public variable
 
  'Production copy onsite
  strPath = "P:\SharedFolder\DBFolder\DBName.accdb"
 
  For Each tdfTable In dbsCurrent.TableDefs
    With tdfTable
      If Len(.Connect) > 0 Then
        .Connect = ";DATABASE=" & strPath
        .RefreshLink
      End If
    End With
  Next
 
  dbsCurrent.Close
 
End Function

The function is called on the load event of a 'splash screen' form before the TimerInterval property is set. The reason I suspect it stops on the RefreshLinks function is because when the user closed the VB editor, the app stalled on the 'splash' form.

It did break once when I was testing onsite but I didn't note where. I resumed the code and everything else was fine. I tried compiling and it find anything. I compacted and repaired to see if that would resolve it. The next time I opened it, it didn't break so I assumed it was fine.

There isn't any code in the function to check for the tables. But there also isn't any error trapping that would resume on the event of a specific error so if it didn't find the tables, an error would have been thrown and the user didn't report anything.

TIA,
ML!

 

[RuralGuy]

I would try:
Dim tdfTable As DAO.TableDef
...and as a test I would comment out the load event and put the code under a temporary button on the splash screen as a diagnostic.

 

[ML!]

I'll give that a try and let you know what happens. I'll have to do that onsite which will be sometime this coming week.

I use recordset and database references throughout the app and haven't explicitly referenced DAO at all. I've been careful not to use any code that references ADO either to avoid confusion. I haven't experienced any other problems...doesn't 2007 default to DAO? I thought you didn't have to be explicit if you use DAO.

 

[RuralGuy]

You are correct but it always pays to be explicit. Have you tried the free LogMeIn product as an assistance tool for remote locations? I use it all of the time.

 

[ML!]

I've used lots of products/services like it...RDP, VNC and I use DellRemoteAccess for my own network when I'm out of my home office but haven't used LogMeIn. But you raise a good point, I should ask their network admin if their firewalls would allow it...especially since they're an hour away. I assume it uses VNC-like technology, have you run into firewalls and other security issues?

It looks like the free version only allows connections to one computer - is that concurrent? In other words can you use the free version for multiple client sites? In this scenario, the app is installed on 5 workstations at the same site and the backend is on the server. I also have other (non-database) applications where this might be useful with other clients so I'm interested in your experience with it.

It also look like it allows pretty umlimited control. Does the 'server' computer user have to accept the connection (with VNC, you can set it up to invite the support person thereby limiting control).

 

[RuralGuy]

I have a paid version for file transfer to and from the machine at my office as well as remote control. I have a dozen or so people on my free version for occasional support. It does not require the receiving computer acceptance of the connection once installed, and most certainly uses encription.

 

[ML!]

Thanks RG, you've been very helpful. Whether onsite or remote, I'll followup with a post on what I find.

 

[RuralGuy]

Great! Glad I could help.