ms access network login help needed

[vasox56]

hi, im about to create a database that will be used over a network.

i realise now that i will need to create a back-end database (stored on a server) consisting of my tables..

and a front end database on each terminal consisting of the forms/reports etc.

i will also need a basic login system for each user.

can anyone recommend a tutorial or some reading material that explains how this can be done, step by step preferably..

thanks..

 

[fneily]

Better off posting this in Microsoft: Access Other topics. But give more details.

INTRAnet or INTERnet?
Would a table containing login's and passwords suffice?
How many users? Maybe you can just place the Database on a server and let the users at it.
Splitting a database should be in any Access book. Also, linking the tables. You could also do a search in the seven Access forums on "front end" and "back end" and splitting.

For a book name - Access 2000 Bible. (I'm sure there's a 2003, etc.)

And out of curiosity, are your tables Normalized?

 

[vasox56]

hi, thanks for the reply.
its nothing major.. just a basic broadband-router network.. windows xp.. about 5 machines in total.

i would need each machine to have the front end.

im not sure at this stage whether im gonna set the main db on a server, or just share it off the fastest pc in the office.

a table with usernames and passwords will be fine.

i have a db already that is about 70% normalised, the reason i didnt go all out is because we needed a system in place and i didnt have time.

now tho im making it proper.. so really i would prefer to get this user-network thingy sorted before i start designing the entire structure of the db.

 

[fneily]

Again, for more info, see the Access forums and do a search on "network". eg. thread181-1390308