Hi
I created a function to keep updated on client side database with the server database. In my application I like to keep the same version in both client and the server. I tried to overwrite my client database with the server database and close my client application. Then I restart the new client version. But Access is not allowing me to open another object of the same database when its already running. I will be greatful if anyone can tell to me to fix this problem.
My code looks like:
Private Sub UpdateDB()
FileCopy strServer, strClient
DoEvents
strOpenClient = "MSAccess.exe " & strClient
Shell strOpenClient, vbNormalFocus
DoCmd.Hourglass False
DoCmd.Quit
End Sub
Cheers!
Mona
I created a function to keep updated on client side database with the server database. In my application I like to keep the same version in both client and the server. I tried to overwrite my client database with the server database and close my client application. Then I restart the new client version. But Access is not allowing me to open another object of the same database when its already running. I will be greatful if anyone can tell to me to fix this problem.
My code looks like:
Private Sub UpdateDB()
FileCopy strServer, strClient
DoEvents
strOpenClient = "MSAccess.exe " & strClient
Shell strOpenClient, vbNormalFocus
DoCmd.Hourglass False
DoCmd.Quit
End Sub
Cheers!
Mona
