switchboard question

G

George Applegate

I have two users who have full installs of access 2007.

On the one PC, when they open the database, I have it set to display a
"Switchboard" form. It does this just fine, showing the form and then
the switchboard table items as options.

On the other PC, when they open the database, they see the switchboard
form, but no switchboard table items show as options.

They are both opening the same database, which is located on the
server.

Along the same lines, the same user that can see the switchboard
items, when they work on a particular form, there is an edit mask to
only be able to enter one field in CAPS, which works. However, on the
other PC, when they open the same form, they can enter lower-case
data.

We are in a testing mode and when the second user is opening it, the
first user is not in the database.

Any ideas why this would be happening?
ga
George Applegate
(e-mail address removed)
 
A

adam.vogg

We had to recreate our Switchboards that were created via the
Switchboard Manager in Access 2003 for users using Access 2007. We
had to manually create a form with the switchboard buttons. If that
database was created using an older version of Access, you could try
recreating that switchboard as a regular form.

Not sure what else...
 
G

George Applegate

Adam,

In this case, it was actually simpler than that. On further
investigation, on the PC that wasn't displaying the switchboard table
or doing the keyboard macro right, it had "security settings, click
here" and the security was set to "not trust"...just had to change
that and voila...

Live and learn, right? I'm getting a lot of gray hair from this...but
it's fun!! :)

ga
We had to recreate our Switchboards that were created via the
Switchboard Manager in Access 2003 for users using Access 2007. We
had to manually create a form with the switchboard buttons. If that
database was created using an older version of Access, you could try
recreating that switchboard as a regular form.

Not sure what else...

George Applegate
(e-mail address removed)
 
C

CurtainMary

I would have thought that front-end/back-end would be the safest way.
Back-end with all tables on the server, then each separate PC have their own
front-end linked to the one back-end
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top