Software

Ask something
Discussion Locked

Access 2002 Front End

0 helpful
4 replies

by todd.herbst

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

4 replies

by eschlangen

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.

This discussion is closed to new replies.