Please Help?! Splitting the Database

[Guest]

Good Morning,

I have a database that I have split but I would like to create 2 seperate
front pages that don't use the same Switchboard table.

i.e. have one version that enables the user unlimited functionality of the
database and one version that only enables the user to view data from the
database, from the switchboard.

What I was thinking was to create a second linked table (Switchboard 2) and
link this to the switchboard form, in the user version? How would I go about
linking my Switchboard to a different table???

Thanx in advance

 

[SusanV]

Hi Ashley,

Your best bet would be to eliminate the built-in switchboard and create your
own startup forms.

 

[John Vinson]

Good Morning,

I have a database that I have split but I would like to create 2 seperate
front pages that don't use the same Switchboard table.

i.e. have one version that enables the user unlimited functionality of the
database and one version that only enables the user to view data from the
database, from the switchboard.

What I was thinking was to create a second linked table (Switchboard 2) and
link this to the switchboard form, in the user version? How would I go about
linking my Switchboard to a different table???

Thanx in advance

If there are other differences between the two users' views of the
data, you could create two completely independent frontend databases.
You don't need to use the Splitter Wizard to link the tables - you can
create a new .mdb file by copying the current frontend; use File...
Get External Data... Link to link to the backend tables; change your
switchboard; delete any unnecessary forms, reports, and queries.

John W. Vinson[MVP]