How do I protect my database?

[Nikki]

Hi,
I created the database by using Microsoft access 2007-I’m a new user of this
software. I also save this database in my desktop. One of my employees will
take this desktop with him during the weekend just for emergency case. How do
I protect my data in the database or is there any ways that I can lock my
database? He plans to buy a new computer and I don’t want him to copy my
entire database in his new machine. Please advise/Thanks.

 

[Jerry Whittle]

Go to the Database Tools tab. Click on the Set Database Password. Don't give
him the password.

 

[Nikki]

Thanks for all answers. I need to go to the Database Tools tab then I should
click on "encrypt with password", right? I don't see "Set Database Password"
in my Access 2007.

And the other question, I try to split database to be front end and back
end. We are very small business (4-5 people) but the problem is I plan to
relocate to the other city. So I need to have people in MO and CA using the
same database. I tried to save the backend to dedicated web server but I
couldn't link all tables in front end to the back end in web server. Please
advise if there is any ways that I can do this. I'm not a guru of computer.

Thanks for your kind help

 

[Jerry Whittle]

I believe that you are correct about the "encrypt with password" on 2007.

As for your second question, Access, especially Access 2007, may not be the
right tool. Access doesn't play well on WANs or web servers. You probably
need a web-based application to do what you need.

If you can stand a delay in the data being updated, then replication might
be a solution, but it would take a lot of work to maintain plus data would be
'old' on each of the two sites.

 

[Nikki]

Thanks, Jerry. Can you please explain to me what web-based application is?
I'm sorry I know a little bit about computer. I have a problem when I link
all tables from front end to back end in web server, It shows path couldn't
be found. (I type: \\dedicated servername\Documents\mydatabase_be.accdb.) Do
you know any website that I can learn about how to link the computer to web
server.

Or should I use pcAnywhere to be our server instead? Please advise. Sorry
about that for asking you so many questions.

Thanks so much.

 

[Nikki]

Thanks for the websites. I plan to move to the other state next year but my
employees will work in this town. So I don't know exactly what I should do
for this situation. Now we share the database back_end which is in my
computer at the same office. what should I do to make database working if I
have 2 offices in different areas? Please advise.
Thanks,
Nikki