Move secured DB to shared folder, now it won't open

G

Guest

I am using Access 2002. A colleague and I created a database our company
needed, then secured it using the user-level security wizard. No problems
there. I got all of that figured out with a test database before using a real
one, so they security was set up well and worked beautifully.

The problem now comes when we move a copy of the secured database and the
shortcut to the secured database into a shared folder the entire company can
access. Now, when the users who need it try to access the database via the
shortcut, one of these two different possible errors occurrs:

1. They are able to enter a user name and password, but then nothing
happens. The database doesn't open. They just get a blank screen.

2. When they open the folder, they cannot even open the database at all.
They are just told that "the drive or network" referenced is unavailable,
however, the secured database is right there in the same folder.

Anybody know what is going on and how to fix this? My eternal thanks if you
can help.

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy
 
G

Guest

Thanks. I'll give that a try. I'll have to get back to you on whether or not
it worked, though. My colleague is the one preparing the database in
question. I'm just assisting him with it. Meanwhile, any other suggestions to
a potential solution would be appreciated so we can try several at the same
time. If anybody can still help, I'd appreciate the assistance.

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy
 
T

TC

Not to answer your current problem, but: if the db is going to be used
by several people simultaneously, you really need to split it into a
so-called "front end/back end" (FE/BE) structure. Google this group for
those terms, for more information.

HTH,
TC
 
G

Guest

Okay, thanks again. Sorry I'm not yet able to get back to you on that
suggestion. Sometimes folks in this company get pretty busy. I still haven't
been able to meet with my co-worker again, and he is the one working on the
database. I appreciate your suggestion, TC. I would like to learn how to do
that for future reference, but I actually think it is more advanced than we
really need for this database.

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy
 
L

Lynn Trapp

G

Guest

Wow! Just got back from a meeting of the minds with my co-worker and we
figured it out. Lynn, you were on the right track. As it turns out, he has
Office 2003, but almost everybody else who uses the database has Office 2002.
The target for the icon was referencing a folder with 2003, so it didn't work
for users who still had 2002. All we had to do was right click on the
shortcut icon and change the target in its properties. Thanks for your help,
everybody!

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy
 
G

Guest

Thank you very much. Have a good weekend yourself! TGIF, huh? ;-)

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy
 
G

Guest

Lynn Trapp said:
You can say that again :)
Click to expand...

TGIF, huh? ;-) LOL. Oh... wait... NOOOOO!!! It's Monday again! Why? WHY?
WHY????!!!! Okay, I guess I'm being a little over-dramatic. He he he.

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy
 

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

Similar Threads

2007 users cannot open secured 2003 database 2
secured database doesn't open on new server 4
Open xp secured db in 2007 2
2003 Access Secured Database - how to allow other users to login 1
Reset to default mdw on exit 8
Help moving secured database 1
Slow Response on Shared Data-using Workgroup 2
multiple mdws 8

Top