Echo?

[auujxa2 via AccessMonster.com]

I have a form open on startup, and code run on the form open. All the code
does is follow a hyperlink, then close the database.

I'm basically using the database as a "portal" from a frontpage website, so
anyone who does not have access to the department drive (where the database
is), won't be able to access the file that the hyperlink opens.

My problem is that the hyperlink opens the folder properly, closes the
database properly, all is well....

BUT

The database opens again and hiccups, and I get an error message (after it
performed everything i needed it to)

The code is simple:

Private Sub Form_Open(Cancel As Integer)

Shell ("Explorer.exe \\belk1\cltmd_public\Corp Reports\Private Brands")

DoCmd.Quit

End Sub

 

[Tom van Stiphout]

On Wed, 10 Dec 2008 21:29:34 GMT, "auujxa2 via AccessMonster.com"

What is the error message?

Wouldn't it be better architecturally if the webpage itself (through
Windows Authentication and Active Directory) found out who is trying
to open it, and act accordingly if the user is not in Department X?

-Tom.
Microsoft Access MVP

 

[auujxa2 via AccessMonster.com]

I wish I knew how to do that. That is my ultimate goal for phase 2. I'm
using Frontpage to build the website. If you could point me in the right
direction on how to do that as far as a link to some website, it would be
helpful.

What is the error message?

Wouldn't it be better architecturally if the webpage itself (through
Windows Authentication and Active Directory) found out who is trying
to open it, and act accordingly if the user is not in Department X?

-Tom.
Microsoft Access MVP

I have a form open on startup, and code run on the form open. All the code
does is follow a hyperlink, then close the database.

[quoted text clipped - 20 lines]

End Sub

 

[Tom van Stiphout]

On Thu, 11 Dec 2008 14:14:14 GMT, "auujxa2 via AccessMonster.com"

I'm afraid that's out of scope for an Access forum. Perhaps some web
development forum can help. FrontPage is old technology and mostly
(exclusively?) geared toward client-side processing. What I'm talking
about requires server-side processing.

-Tom.
Microsoft Access MVP

I wish I knew how to do that. That is my ultimate goal for phase 2. I'm
using Frontpage to build the website. If you could point me in the right
direction on how to do that as far as a link to some website, it would be
helpful.

What is the error message?

Wouldn't it be better architecturally if the webpage itself (through
Windows Authentication and Active Directory) found out who is trying
to open it, and act accordingly if the user is not in Department X?

-Tom.
Microsoft Access MVP

I have a form open on startup, and code run on the form open. All the code
does is follow a hyperlink, then close the database.

[quoted text clipped - 20 lines]

End Sub