Switchboard is read only

[NES]

I set up a database with a switchboard. When I opened the DB again and tried
to change an item (actually delete an item) on the switchboard, I'm told that
it's read only. I don't recall setting any locks on it, and I can't find out
how to unlock it. Any suggestions? I'm using Access 2003 with Win XP.

Also, at work, since installing a new computer, I'm plagued with security
questions as I try to open a database from the server. I respond with YES to
the first question, the I get a larger window with explanation to which I
reply NO, then I get the macro question. I know how to handle that, but the
other two elude me. Any suggestions for that?

I'd be most grateful for a reply to these 2 questions. Thanks.

 

[Joan Wild]

I set up a database with a switchboard. When I opened the DB again and
tried
to change an item (actually delete an item) on the switchboard, I'm told
that
it's read only. I don't recall setting any locks on it, and I can't find
out
how to unlock it. Any suggestions? I'm using Access 2003 with Win XP.

Do you (and all users) have modify permissions on the folder where the mdb
is located? You should also split the database; leave the backend on the
server, and give each user a copy of the frontend on their computers.

Also, at work, since installing a new computer, I'm plagued with security
questions as I try to open a database from the server. I respond with YES
to
the first question, the I get a larger window with explanation to which I
reply NO, then I get the macro question. I know how to handle that, but
the
other two elude me. Any suggestions for that?

It's rather difficult to respond without knowing what the 'security
questions' are. You may find that resolved when you change the windows
permissions on the folder. If not, then please post the text of those
messages.

 

[NES]

Thanks for your reply, Joan. On my home computer I like to think I have
complete authority. The computer sometimes doesn't seem to agree. <G>
Actually, after posting the question, I later spent several hours with the
switchboard problem, checking out the write, edit, etc. which were all set to
"yes". Finally, I noticed that record locking was set (on the switchboard)
which was something I did NOT change originally. When I set it to No locks, I
was finally allowed to edit the switchboard. Since I've been using Access for
several years, this is the first time this has occurred. Don't know why.

Splitting the database is something I played with early on. When I tested it
by moving the data (just to see if I could reconnect with it when it was not
immediately found) I could not figure out how to reconnect. Rather than lose
everything, I just decided to keep it together. In addition to the fact that
I still add things to make it more useable, we have encouraged some of our
staff members to take a copy of it home periodically so that they have access
to it there.

Perhaps you can direct me to a page where the procedure for "reconnecting"
the frontend of the database to it's data when the data is moved is
discussed. WHen I tried it, all I got was an error message.

Regarding the security messages, when I return to work on Tuesday, I'll make
note of the security error messages I'm getting, or perhaps get screen shots
to upload (if we can do that here).

Thanks again for your help. Much appreciated.

 

[Joan Wild]

What error are you getting when you try to reconnect? What code are you
using? There is code at http://www.mvps.org/access/tables/tbl0009.htm you
can use. I'm assuming that this database isn't secured.

Just post the text of the messages. Attachments are frowned upon in
newsgroups.

 

[Andy]

You might be interested in my Link Tables module (free for the asking).
Works in all versions of Access up A2k3.

My Link Tables allows you to navigate to q moved back end database, and
re-link tables.


Andy

 

[NES]

Joan, It has been more than a year since I tried it -- at my age I'm lucky to
remember what I had for breakfast today. I'll try it again a bit later and
see what happens. Thanks. Ok -- no attachments. <S>

By code, I assume you mean VBA. Sorry. I stick to the basics right now. I
had made a copy of the DB to another directory, split it, then moved the data
to another directory. When I ran the DB, it couldn't find the data, and it
didn't tell me how to lend a hand to the task. I don't remember the
particulars.

I'll be back. Thanks.

 

[NES]

Thanks for the offer, Andy. After two years I'm still quite new at Access,
and I've never even considered "modules". I'm lucky to get macros working
(usually). But I shall keep you in mind for further discussion. Thanks again.
These discussion groups are GREAT!

 

[Joan Wild]

Joan, It has been more than a year since I tried it -- at my age I'm lucky
to
remember what I had for breakfast today. I'll try it again a bit later
and
see what happens. Thanks. Ok -- no attachments. <S>

By code, I assume you mean VBA. Sorry. I stick to the basics right now. I
had made a copy of the DB to another directory, split it, then moved the
data
to another directory. When I ran the DB, it couldn't find the data, and it
didn't tell me how to lend a hand to the task. I don't remember the
particulars.

You can just use Tools, Database Utilities, Linked Table Manager to locate
the backend in its new location. Be sure to put a check at the bottom of
the dialog.

 

[ASH]

Norm,

Using my Link Tables requires no programming experierence, nor VBA nor
module usage.
It does just what Joan suggested you can do manually using the link table
manager. I use it in all of my databases just because I have found it easier
to use than the linked table manager. It allows the user to link to multiple
backends using a friendly Link Tables form. All you supply is a simple table
edit to specify which tables you would like to link to.

Good luck with your development,
Andy