Database + Forms....

Kanye

Kanye

Kanye

Associate
Joined
19 Oct 2004
Posts
218
OK guys, ive been given a project and i have no idea of how to go about it or do it LOL! Great... :)

Basicly, i need to create a excel database that can be updated by 25 users over a local network, all at the same time using a web form...

Just stuff like names and address's etc.

The database is gonna be stored on a local server and we need to make the database secure so it cant be downloaded or opened by the employee's (The 25 users)...

How would i go about getting the form secure so that the users can ONLY enter info into it and not download it or access it to read it?

Also, how would i go about setting the web form up to enter the info into the excell database? I know how to make the form email but thats about where my knowledge stops :p :)

Any help appreciated guys :) Also on MSN if some kind person would like to help me out? Ta :)
 
What is the nature of the information being stored? Is it just simple data fields such as name, address, enail and telephone numbers or is it more complex, such as tabular data?

What will the users be doing with the form, entering new data, editing existing data or querying existing data?

What will the stored data be used for?
 
Its just basic info such as name's addys and numbers. They will be just entering info, i dont want them to be able to access the database in any other way...

Just spoke to my dad and he reckons i can create the database in access then create a form in access and let all the 25 users use the form to enter the info. Will i need SQL server installed so the database is accessable over the network to the 25 pc's via the form?
 
well if the employees cant see the file info then you would need to create a form on the internet and not in access and then link that form to access. i DONT think that in access you can just look at the form and not the tables.. .


and if you have got SQL server installed then that would do otherwise you just need microsoft access saved in the same directory as your form.aspx file
 
Access will run on it's own, no need for SQL Server. If you do have SQL Server then use that instead as it is a 'proper' database.

As for allowing users to enter data in to the access database and no being able to look at the tables you will need to create either a web page in ASP/ASP.NET or create a application to interface with the database. This was they can only enter data you allow them too. You will abviously password protect the database so it cannot be opened directly without the password. On either you web page or application you would pass the username and password in with the connection string.

sfx
 
You must log in or register to reply here.
Back
Top Bottom