MS Access over network

  • Thread starter Thread starter ANSWER
  • Start date Start date
A

ANSWER

Hi,

I have tables with data on server and FrontEnd on eash computer in network
so they all can enter or edit data.
On server I have to share that folder with administrative privileges. Now
all users on network can copy my database with data over network.
Can I make something like this: users can only enter into database over
FrontEnd but not over network (My Network Places -> Server -> C -> MyData ->
new.mdb)

Thanks
 
ANSWER said:
I have tables with data on server and FrontEnd on eash computer in
network so they all can enter or edit data.
On server I have to share that folder with administrative privileges.
Now all users on network can copy my database with data over network.
Can I make something like this: users can only enter into database over
FrontEnd but not over network (My Network Places -> Server -> C ->
MyData -> new.mdb)
Click to expand...

Not that I know of. I think you'd need to invoke Access user-level
security. Here's where to start:

<http://support.microsoft.com/default.aspx?scid=/support/access/content/sec
faq.asp>

It's not a trivial task to learn about security so be prepared for a steep
learning curve and always back up your files before attempting to apply
security - it's very easy to lock yourself out.

Once you've got to grips with the FAQ then the step-by-step example on my
web site may also help.

Regards,
Keith.
www.keithwilby.com
 
Back
Top