Multiple Switchboard with Split DB

[scottmvinovrski]

I have front end users that process work through a switchboard and that data is logged in a back end shared drive DB. I have a question and haven't really been able to find a similar problem that someone else might have encountered. Anytime I edit the switchboard on my desktop it edits on everyone that has the front end on their desktops as well since the tables are linked. Would it be possible to have 2 entirerly different switchboards so that the front end users wouldnt have access?? Would i have to create a new table called for example Switchboard items 2? Any feedback is appreciated.

 

[RuralGuy]

All of the users should have their *own* copy of the FrontEnd on their own machine. Split your Access database into data and application

 

[scottmvinovrski]

Rural Guy,
I did make a copy of the DB on their desktop of the front end. One problem though, since the switchboard is linked to the tables on the back end anytime I change the switchboard the change is seen on the Front end of all the users. I originally had a tab on my switchboard for reports. After copying the Front End onto their computers I realized that I did not want them to be able to see this option and switchboard so I deleted the button. I still want the report button on my switchboard but my question is do i have create another switchboard table and a second switchboard form?

 

[pbaldy]

I don't use switchboards, but I suspect putting the switchboard table in the front end would be one way to solve your problem.

 

[RuralGuy]

Paul has the right idea. I don't use switchboards either and forgot it is driven from a table in the back end. oops!

 

[scottmvinovrski]

I don't use switchboards, but I suspect putting the switchboard table in the front end would be one way to solve your problem.

Paul or Rural Guy,
If I do switch the switchboard table and move it to my front end do you think this would cause any problems for those who are still using the switchboard. Or do you think I should just create a form that acts as a switchboard on the computers of those who need further access to reports ect...

 

[KeithG]

I myself do not use switchboards but moving the table to the FE should fix your problem.

 

[scottmvinovrski]

Keith
I understand what everyone is saying and thanks for your help, but does this mean i can move the table to my copy of the front end or everyone's copy of the front end? Just wondering since about 20 ppl have front ends?

 

[KeithG]

You will have to redirstribute your FE. Unless you have an Auto Update Utility built into your database. This is what I have and it works well every time I update the version number a form will pop up in the users FE stating that there is an update available and to log out and log back in to receive the update.

 

[pbaldy]

Alternatively, you could import the table into your db, leaving it server based for everyone else. Depends on your overall goals.

 

[RuralGuy]

You should probably try and work out a solution that does *not* require 2 different versions of the FrontEnd. In one of my Applications I check to see which computer we are running on and if it is mine, I enable additional features for me to use. Just one idea.

 

[KeithG]

What I do is use Environ("Username") to capture the user name logged into windows and enable/disable feature for the username.