Linked Database

[Bruce]

We use a Access 97 program in work which has two forms I've been asked if I
can share the program on our network but restrict the main form to certain
users and allow only the second form visible or available to all. The only
idea I can come up with is to create a Access program only showing the one
form (an identical copy) and link it to the main program, so the data can be
amended and xferd in both directions.

Would this work?

Bruce

 

[Bas Cost Budde]

We use a Access 97 program in work which has two forms I've been asked if I
can share the program on our network but restrict the main form to certain
users and allow only the second form visible or available to all. The only
idea I can come up with is to create a Access program only showing the one
form (an identical copy) and link it to the main program, so the data can be
amended and xferd in both directions.

For one thing, you can retrieve the network user name. See
http://www.mvps.org/access/api/api0008.htm
This fact can help the startup decision to show or hide some/any form.

You can create as many front ends to any database as you like. That is
common practice. Is that part of your question?