Form on workstation connecting to Web server database

[kensington43]

I have a workstation that does not have internet capability and I need to create a form to just search information on an Access 2000 database sitting on our web server.
I already created the form but how do I connect this to the database on the web server?

Please advise if this can be done and how I would do this?
I assume I would have to create an ODBC connection on the workstation to this database? Or would it be a mapping?

 

[jsteph]

You say you don't have internet, but I assume you have lan capability? You would just link to a table on the server. It doesn't matter if it's a 'web' server, a file server, just another pc on the network. It's all the same as far as linking tables.
--Jim

 

[kensington43]

Thanks,

It seems now the Lan wont work from the workstation to the web server due to security issues. But I can manually copy the database from the web server to this workstation with no problems. I was wondering how I can automatically copy this database from the web server to this workstation. Does Access 2000 have this capability?
If so please advise or do I have to run something like a Perl script using the web server task scheduler to do this?

 

[jsteph]

If the .mdb is part of the IIS application and in the

http://wwwroot

folder, it may have the iis security applied to it. You can override this if you feel it's reasonably safe to do so--all you'd be doing is giving access to that .mdb file to your username or whatever group you want to use that file. You'd also want to make sure the .mdb isn't opened exclusively, and that the JET security will allow you to link tables--by default it will.

Anyway, I wouldn't go the copy route--unless it's a one-time thing. Setting up a copy procedure to happen daily is a kludge that I think you'd be better off avoiding. A simple security change should get things going for you so you can link.
--Jim