Access Page for all Users

[rigby]

Hi

So, we are having our server upgraded today so we can allow remote access
for our employee database amoung other things. It is up to me to make the
employee database available to everyone. How do I do this? I am currently
creating a Data Access Page, but it feels like such a waste of time. Is there
no way for me to be able to use my switchboard for everyone to use. I
designed it specifically for people to use with the necessary links to
reports and other various queries. These reports are needed to be accessed by
users in offices across the world. Our server is being made to allow up to 15
users at any one time, which is all we need, so there is no problem there.

How can I make it so we can use my switchboard with its links to the reports
and queries for all the users. It's purely for taking information off, like
printing reports, etc. There will be only one person designated to do all the
adding and editing of information, here in our office. I hope someone can
understand this. I need help, please. Thank you.

Kind Regards
Rigby

 

[Aaron G]

Rigby,

First off, how are the users going to be connecting to the server? ie. Will
they be using terminal sevices?

The standard way to make the database available to several users at once is
to split the database and give each user their own front end. (Have you done
this? If not, are you familiar with how to?)

Since each user has their own front end (which contains basically a copy of
everything except the tables) they can mess around with their own reports,
queries, etc.

You do not have to create a data access page, unless that's the design route
you want.

Since you only want one person to be the data editor/creator/etc then a
simple solution would be to create a front end that allows such actions and
give it to just that person, then create another front end that does not
allow those actions and distribute a copy to everybody else.

Since I'm not sure if you're familiar with the front end/back end concept, I
don't want to assume too much and confuse you. Be sure to let us know what
your level of knowledge is on the matter.

HTH

Aaron G
Philadelphia, PA

 

[rigby]

Thanks Aaron G

This sounds like a lot of help. I do not know how to use/create front end or
back end database. I have heard and read a little about it but am not sure
how to go about it. I have been talking with my colleagues and we have
decided that the best route would be to create data access pages so whoever
connects via remote access will only be allowed to view a particular folder
with the data access pages in it along with the database but will have no
permission to even open the database itself, that will be only for me to use.
Therefore they will be allowed to download and print the various reports,
etc. and they wont need to change any information.

but then there is another database which will require somone in our USA
office to change information so i will need to create a couple of front ends
for this, could you please advise on how to go abou it? my VBA knowledge is
unfortunatlye very limited.

Kind regards
Rigby

 

[Brendan Reynolds]

You might want to read what Clint Covington (lead program manager on the
Access team) says about the future of DAPs at the following URL ...

http://www.utteraccess.com/forums/showflat.php?Cat=&Board=86&Number=1057772

I agree with Aaron that Terminal Services may be a better solution to your
problem. You can read about Terminal Services at the URL below ...

http://www.microsoft.com/windowsserver2003/technologies/terminalservices/default.mspx