General discussion

Locked

Access 2002 Front End

By todd.herbst ·
In Access 97 I had a front end database that had 1 form with 12 buttons. The buttons pointed to a macro that issued the sendkeys command %{F}{DOWN}{ENTER} F:\DATA2\ACCESS\Training.mdb {ENTER} to open the training database (example). This now does not work in Access 2002, so I am using Hyperlinks. The issue is that each Hyperlink causes the user to Login again because another Access is being loaded, as with 97 it closed the current db then opened the requested db. I am using Access security to control users rights in the db, this work fine for us. Is there a better way to set this up or different code for Access 2002?

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 2002 Front End

by todd.herbst In reply to Access 2002 Front End

Point value changed by question poster.

Collapse -

Access 2002 Front End

by ESchlangen In reply to Access 2002 Front End

I'm not 100% sure but two things come to mind:
1. Since you're using Sendkeys to manipulate the menu, make sure that the menu is the same, and
2. Shouldn't it be ALT-F to open the file menu?

Also, I believe that Access 97 used an MDI (Multiple Document Interface) but that Access 2000 and up use SDI (Single Document Interface). This may be what is causing a new instance of Access to run for each database that you open.

Collapse -

Access 2002 Front End

by todd.herbst In reply to Access 2002 Front End

Poster rated this answer

Collapse -

Access 2002 Front End

by todd.herbst In reply to Access 2002 Front End

This question was closed by the author

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums