Tips creating a table (newbie help!)

[hellfire45]

So I'm looking for a few tips on creating a table in Access. I have a team at my office that needs a form to keep track of records but first I need to create their table DBO. They've got a lot of fields they need and I need some pointers from you guys who know ALOT more than I do. So I have a list of concerns below.



#1) How can I keep the team from compromising the integrity of the database table. I'm talking about putting words where dates need to be, duplicating data, Erasing records accidentally. Stuff like that. That is my first concerns.

#2) How can I make the Access DAtabase accessible from more that one place? Can I merely save an access file on our server and have people open the file?

Thank you!!

[ranman256]

If you set the field to DATE, it wont let anyone put TEXT in it. (automatic) Same with number fields.

If you build a form, for users to enter data, you can set it so they cant delete data. Only add.
There's a setting for everything , to let users do / or dont.

Read up on SPLITTING THE DATABASE.
Every user gets their own copy of the FrontEnd (queries, reports, forms) on their desktop, but only 1 BackEnd (the tables) exists on the network so all can share.

[nick404]

Just browse through the properties of your form and mostly everything you want is in there. As ranman suggested split the db. If you want further security you can save a copy of the front end on your computer and convert the other to an accde file. The user won't be able to view any code, modify any reports, forms, queries in design mode. Really all they will be able to do is input data.