Help with MSAccess2000

I'm trying to set up a database that people can access through a website.

There will be 140 different accounts, and I want each person to only have access to their specific information, with read only access.

Any ideas?

Please Register or Log in to view the hidden image!

 

Log in or Sign up to hide all adverts.

No helpful input?

Please Register or Log in to view the hidden image!

 

Log in or Sign up to hide all adverts.

Well I have some advice for you...don't use MS Access for that. Your best bet would to go check out MySQL @ http://www.mysql.com. It's a database program too, although I am sure it will be quite a bit easier finding documentation on what you are trying to do. As of now I havn't done my html/database course in school, so I can't really specifically help you, but I do know that MySQL is one of the most widely used html/database program out there.

 

Log in or Sign up to hide all adverts.

Thanks for the info TESTIFY. I'll look into it!

As long as I'm the only one who will need the software, it might be possible. We'll see...

 

Hi Vakemp,
Your best bet to do this would be to use MySql, PHP, and an Apache server to practise with. I created a similar web database last year with these and it works superb. It's not too difficult to learn and there are bundled packages to teach yourself how. Further to this, you need to host your site on a linux server. You will find that MySql &PHP on a linux server is very reliable and secure.
I will try to find the package which I used and I will send you a link to it, it doesn't take long to learn.

 

Thanks Vienna.

I don't know if I will need, or even be able to use a Linux server. It will be on a classified system, and I doubt they will allow me to have my own server for this.

I hope you find the link!

Please Register or Log in to view the hidden image!

 

Hi Vakemp,
If you are putting your database on an intranet there shouldn't be any problems, the server will probably be linux. If the server is NT you could probably use Ultradev and asp with Access, but I prefer MySql.
The Apache server is put on your computer, it's just a prog.
Here's a link to the PHP package I was telling you about.



(Sorry, the link is broken on that page)

 

Here's a download link for PHP Triad
http://downloads-zdnet.com.com/3000-2165-6474268.html?tag=list

 

If you have not used php & mysql before have a look at this:

 

Thanks again Vienna!

I'll take a look at all the links you provided.

I appreciate it!