App created in access 2016, moved to remote site with Office 365, recopied to my PC WON'T WORK

[Ron Nemec]

I created a split app on a desktop PC. I moved it to a remote site which uses Office 365, relinked the tables and it works fine.


However when I copy all of the tables and the app back to my desktop I cannot open the app part on my PC in order to relink the tables. I get an error (I think it was 3619) saying that the app is in use by another and if I continue then NO forms etc are even visable.
Does Office 365 on a network do something to the app? I can open any of the tables just fine just not the app that uses those tables. At the remote site using Office 365 I CAN open the app in update mode to make changes to the forms etc.

[ranman256]

its probably the references, not the app.
open the db while holding the shift key,
once open, press ALT-F11 to enter VBE
menu, tools , references,

see if anything has a checkmark YET says MISSING. that means its looking at the old version.
uncheck the missing, then look down the list for the current version. then check it.

another problem could be 32 bit vs 64. Do a global search for DECLARE, and make the app safe for both 32 or 64 bit PCs by using PTRSAFE:

#If Win64 Then      'Declare PtrSafe Function 
Private Declare ptrsafe Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hWnd As Long, ByVal lpszOp As String, ByVal lpszFile As String, ByVal lpszParams As String, ByVal lpszDir As String, ByVal FsShowCmd As Long) As Long  
Private Declare ptrsafe Function GetDesktopWindow Lib "user32" () As Long


#Else  'non ptrsafe


private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpszOp As String, ByVal lpszFile As String, ByVal lpszParams As String, ByVal lpszDir As String, ByVal FsShowCmd As Long) As Long
Private Declare Function GetDesktopWindow Lib "user32" () As Long


#End If

[Ron Nemec]

The application was created on my PC and for the last year it was modified etc on my laptop, copied to the user's network and run. We have had that process going now for about 5 years. Only in the last 6 months have I encountered this problem. One was with an I modified for them about 3 years ago and they wanted a modification but I encountered this problem both on my laptop and on their own network. I had not touched this app for about 6 months and they requested a change and the problem showed up.

Here is what the references screen shows:

[pbaldy]

Post 3 was moderated, I'm posting to trigger email notifications.

Ron, your image doesn't appear to have attached properly, you might want to try it again.

[Ron Nemec]

And this is all that access shows when I open it in update mode (Opening with shift key down):



None of the forms, tables or any other of the aspects of the app show up. There are tables that I have copied over also and they open as expected showing the tables and NOT giving me the message that someone else is in the program. Also when I made the copy to bring home there were NO LDB files for the app (which should be expected since they are using a .BAT file to gain access that copies the app to their hard drive and then opens the app. So far when I do the shift-open to the app on their network it allows me in as expected.

[pbaldy]

For some reason your attachments aren't working. What is the file type? You might try putting them in a zip file and attaching that.

[Ron Nemec]

Here is the second image. This is all I see when I shift-open the application.



And here is what I see in the references step: