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.

 

[AccessVandal via AccessMonster.com]

But be aware that there are many password hacks out there (not sure about
2007 but in older version). Why not just cut and paste it into your personal
Thumb Drive. That way, you have a backup also just in case there's a crash
(assuming you also have a backup of a backup).

 

[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.

 

[AccessVandal via AccessMonster.com]

Albert Kalla have some info on WANs that you might need to understand.

http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html

And this might be a good solution.
http://www.members.shaw.ca/AlbertKallal/Articles/ThinClientsand.net.html

Since you're use web server, it might be good to use remote connection to the
web server if you can.

MS SharePoint might out of your budget. You might want to use MS Terminal
Service if you can as you might have a standard 5 user licence on your web
server assuming you're using Windows Server.

Tony Teows site here. Terminal Service as a thin client.
http://www.granite.ab.ca/access/terminalserver.htm

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.

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

[quoted text clipped - 29 lines]

 

[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

 

[AccessVandal via AccessMonster.com]

Have you read the web site?

It requires some expertise to deploy a remote connection like TS or Citrix.
As Access is not efficient with WAN connection (read lost
connection/corruption problems), I doubt even some of the internet service
provider can give you a local connection (like a LAN network) to the remote
office judging from where you come from.

Albert's site had a MS SharePoint that you want to look at. But setting maybe
priced out unless you have a good budget.

You might want to look for a local Access consultant to assist in deploying
Access database.