Hi,
I've got a database with a form that contains 3 buttons each one opening a separate database with the following code. 2 of these databases open fine but one flashes up for a second and then disappears:
The code is identical for each.
I'm working on an Access 2010 adp front end linked to sql server 2000.
Any ideas why this might be happening?
Cheers,
Peter
I've got a database with a form that contains 3 buttons each one opening a separate database with the following code. 2 of these databases open fine but one flashes up for a second and then disappears:
The code is identical for each.
Code:
Dim accapp As Access.Application
Set accapp = New Access.Application
MsgBox "The Database may open BEHIND the current database. Please minimise this database to view."
accapp.OpenCurrentDatabase ("S:\Waste Management Database\Waste Management Database.accdb"), False
accapp.Visible = True
I'm working on an Access 2010 adp front end linked to sql server 2000.
Any ideas why this might be happening?
Cheers,
Peter