run macros in Access 7.0 from VB 4.0

Thread View: microsoft.public.vb.database.dao

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by antonio garcia cabeza Thu, 11 Dec 1997 00:00

Author: antonio garcia cabeza
Date: Thu, 11 Dec 1997 00:00

31 lines
2134 bytes

I�m running Access 7.0 an VBBASIC 4.0 on Windows 95 system
My database has a security.
I create a macro in Access and then I run the macro from vb.

Private Sub ACEPTARIMP_Click()

Dim MiBD As Database, Acobject As Object

Set Acobject = GetObject("q :\base.mdb")


Set MiBD = gwsMainWS.OpenDatabase("q:\ base.mdb ")
�gwsMainWS is the Workspace I�m working from
Acobject.Application.Visible = False
Acobject.DoCmd.SetWarnings False

Acobject.DoCmd.RunMacro "IMPORTAR", , ""

Acobject.DoCmd.SetWarnings True

The code opens an Access sesion and I find Two problems :

- Access is open in a visible way eventhough I use the sentence
Acobject.Application.Visible = False

-The new Access sesion is joined to the default workspace in the PC and
the default user is admin although I�m in another wokspace and with
another user from Visual Basic.

Can someone help me ?

Re: run macros in Access 7.0 from VB 4.0

Author: Mick Metz
Date: Thu, 11 Dec 1997 00:00

9 lines
1591 bytes

Search the Microsoft knowledgebase for article Q167659 for info about the
visible problem.

antonio garcia cabeza wrote in message <349000B8.C73FFFD0@cyberweb.es>...
>I�m running Access 7.0 an VBBASIC 4.0 on Windows 95 system
>- Access is open in a visible way eventhough I use the sentence
>Acobject.Application.Visible = False
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads