access and the internet

[hp]

Hello to all,

I have an Access 2000 database that i need to make available through my
department's website. All the user over the internet needs is access to the
reporting function of the database. The only issue is that the database is
running live on my network which doesn't include my web server. So, I guess
I may need to create and extra action to the database that writes to the copy
of the databae on the web server everytime a particular table is updated.
This also raises permissions and security issues.

Thanks

 

[Arvin Meyer MVP]

Instead of trying to keep the data synchronized, try and update the data
once or twice a day, by ftp'ing the database to the website.

 

[hp]

Hello Arvin,

Thanks for the advice, i actually was thinking about that. The only issue
is that the people that want access to the database for the reports are
pretty high on the totem pole; so if I happen to do the update at the wrong
time, or late it could cause some ripples in the pond I would much rather
avoid. Please let me know if you have any other ideas.

Thanks for the tip though

 

[Arvin Meyer MVP]

The other (and more secure) method that I can think of is to use Terminal
Services. With that, they can login from anywhere to a specified account on
the server and run anything that you want to give them access to. In one
case, I wrote an app for reporting only and the users logging in could only
see their reports and nothing else. It was easy to do since I could capture
their user name from the login to the server, and secure because without an
account, they weren't getting in at all.