Callling DB from Web Link...Bug???

M

MHiemstra

If I have an event fire when the form (startup form) is opened the DB will
not open from being called from a Web Page. However if I remove the event
from OnOpen the DB opens up fine.

Has anyone else had this problem
 
R

Rob Oldfield

What does the event look like? Attached to what event? How are you calling
it from a web page?
 
M

MHiemstra

Using MSDN I used the following code to try to speed up the frontend by
always having a connection to the backend

DoCmd.OpenForm " tblConnect",acNormal ,,,,acHidden

This was having the process run on my machine but the form never displayed.

I also used this code and experienced the same problem

RunCommand acCmdAppMaximize when the startupform opened

To call the DB front end I am just using a hyperlink to the .mdb and
clicking Open instead of Save on the dialog box.

My final success was using the info from the previous post using an autoexec
macro to open the form and maximize the application.

I am not a fan of macro's but in this case it did the job for me.
 
R

Rob Oldfield

The key part of your question here is the "web link" part of the thread
title. You haven't explained what you mean by that. docmd.openform will
open a form in an open db... it won't create connections or do anything
else. If you want any help then you're going to have to actually post some
information regarding what it is you're trying to do and/or how you're
trying to do it.

But I'm glad that a macro did whatever you wanted the macro to do.
 
M

MHiemstra

Hmmm I thought I did, let me see if this makes sense..

On a web page I have an HTML link point to my .mdb file.

When the user clicks on the link they get a pop-up asking to save or open
the mdb, just like downloading an exe file.

If the user clicked Open instead of Save and

If the startup form had an event tied to it MSACESS process would run but
the form would never display. If no events and using macro, the form opens.
 
Top