D
DrAvi via AccessMonster.com
Hello,
I'm using the following VBA code to open with one Access application another
Access application (Office 2003, Windows 2000) and it works great:
Dim acc As New Access.Application
'Open the database
acc.OpenCurrentDatabase "Path.mdb", False, "Password"
'Make the application visible
acc.Visible = True
I have another computer (Office 2007, Win XP) and for some reason that code
don't work.
It seems it recognize the path (wrong path gives error message), the password
and even looks like it is about to be open (Windows procedure manager is
showing for a less than a sec two MSACCESS procedures) but nothing happens.
Could you please advise me what can be the problem?
Kind regards,
Avi
I'm using the following VBA code to open with one Access application another
Access application (Office 2003, Windows 2000) and it works great:
Dim acc As New Access.Application
'Open the database
acc.OpenCurrentDatabase "Path.mdb", False, "Password"
'Make the application visible
acc.Visible = True
I have another computer (Office 2007, Win XP) and for some reason that code
don't work.
It seems it recognize the path (wrong path gives error message), the password
and even looks like it is about to be open (Windows procedure manager is
showing for a less than a sec two MSACCESS procedures) but nothing happens.
Could you please advise me what can be the problem?
Kind regards,
Avi