Forms stored on the Server??

[adamr99]

I am trying to set up a database over a network using Access for forms and SQL Server 2000 for the tables.

The optimum situation would have my users logon to their machine access everything off of the server - Forms Tables Queries etc..

Is there anyway that I can store the Forms that I create in SQL 2000 or on the server itself and have my users simply "login" to a specific form??

The effect that I am looking for is something similar to using ASP pages on the web (but only with access not on the web).

Is there anyway to do this??

Thanks

Adam

 

[ad2]

Not quite sure what you are asking. You can use ASP to give users access to a database via the internet.

If you mean a local network inhouse, I think you could have Access forms linked to the SQL Server 2000 tables.

There are several threads in this forum on linked tables and split databases.

 

[adamr99]

I DON'T want to use ASP. I was wondering if there was a way to use SQL 2000 and Access 2000 to gain the same funcationality as ASP..... Basically, I am going to be running a database and I want to have users be able to login to that database with Acess but have nothing stored locally on their own machine....

Does that clarify my problem??

Thanks for your help

Adam

 

[JeremyNYC]

Adam,

It's possibly but highly unadvisable. You can just put one copy of your database on your server and have all your users open up that copy. But you'll end up gettting corruption and running into all sorts of other problems.

Why don't you want anything stored on the user's PC?
=If it's because you want to be able to lock them out, just make sure you make them start the database with a shortcut that points to a batch file on the server. You can rename the batch file and the user can't get it.
=If it's because you don't want to use hard drive space, I'd say you or someone at your organization is being too protective of space.
=If it's because you want to be able to make changes to the forms without having to touch each user's PC, take a look at my deploying databases article, on my website. It outlines a way of making sure that the user always has the newest version of the database, without ever having to touch a user's PC.

Or it may well be some other reason. If so, I'd be interested to hear it.

Jeremy =============
Jeremy Wallace
AlphaBet City Dataworks

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.