Re: Users locked out of secure DB
From: Steve Kendrot (anonymous_at_discussions.microsoft.com)
Date: 02/26/04
- Next message: Martin: "Re: Menu"
- Previous message: Jeff Conrad: "Re: Create a Registration Code"
- In reply to: Joan Wild: "Re: Users locked out of secure DB"
- Next in thread: Joan Wild: "Re: Users locked out of secure DB"
- Reply: Joan Wild: "Re: Users locked out of secure DB"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Feb 2004 09:56:40 -0800
Hi Joan,
I just figured out why I couldn't copy and paste the FE
throught the networks. Share permissions for the
destination folders were set to read only....wish I had
checked that yesterday! Think I will overwrite the files I
created yesterday because I didn't get the security set up
on each version the same so was running into problems on
the different workstations.
I've been reading up on replication. Would you recommend
going this route? I think my plans are to have two
databases. A stripped down version designed for users, and
another designed for analysis of data. Is this a common
practice?
Also, what kind of systems do database managers use to
keep track of queries etc... I find the DB gets confusing
once I start building queries on queries. Many of my
reports are built on tiered queries. I've often thought it
would be convenient if access allowed subfolders in the
database window to organize groups of related queries. Is
there any way of generating a list of queries involved
with creation of a specific report? I often create queries
which I don't wind up using and if I'm not carefull about
deleting them right away, I often forget if they are a
vital component of some report.
I'm a wildlife biologist with no computer background and
stumble my way through this database development. It sure
is nice to have a resource like this forum to turn to.
Without folks like yourself who are so generous with their
time and knowledge, I (and many others from the looks of
it) would really be lost.
Thanks again.
Steve
>-----Original Message-----
>Hi Steve,
>
>"Steve Kendrot" <nonutes@dmv.com> wrote in message
>news:0e9201c3fb2e$662fec70$a101280a@phx.gbl...
>> Joan,
>>
>> On another note, I found it very cumbersome to get my FE
>> copied to my workstations. As it turns out, Window's
would
>> not let me copy the database and paste over the network.
>
>This really is the only way. Why can't you copy over the
network? If the
>workstations have problems with a simple file copy, they
will undoubtedly
>have trouble connecting with the backend over the network.
>
>> Instead I had to create a new database with the same
name
>> on each machine and import all the objects from the
>> original copy. I did this while logged onto the custom
>> workgroup I created the original database with. The
>> permissions and security features did not come with the
>> imported objects however. Do I need to rerun the
security
>> wizard on every copy? There must be an easier way. Can
it
>> be done without code?
>
>Importing secure objects into a new database will not
work. As you found
>out the new objects are not secured.
>
>An alternative to copying over the network, would be to
copy your secure FE
>to CD and copying from the CD on each workstation. If
you do this, after
>copying to the harddrive, open Windows Explorer, right-
click the FE mdb and
>remove the read-only check.
>
>However, your best bet is to copy over the network.
>
> --
>Joan Wild
>Microsoft Access MVP
>
>
>.
>
- Next message: Martin: "Re: Menu"
- Previous message: Jeff Conrad: "Re: Create a Registration Code"
- In reply to: Joan Wild: "Re: Users locked out of secure DB"
- Next in thread: Joan Wild: "Re: Users locked out of secure DB"
- Reply: Joan Wild: "Re: Users locked out of secure DB"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
