mimottershaw
Registered User.
- Local time
- Today, 10:27
- Joined
- Feb 2, 2007
- Messages
- 40
Dear all,
I have been posting quite a few problems over the last few days as I've been working on a project for work, and I just wanted to say thank you to everyone for their assistance and patience! You will be delighted to know that the project now seems complete, and all I have to do is install it at work. Fingers crossed!
In the past the only databases I have designed have been for my own use and maintenance, so this has been something new for me.
I read with interest the "Access Ten Commandments," particularly with reference to preventing users (with even less knowledge than me) from being able to access certain features that may make the database and therefore integrity of the data vulnerable.
I would be really grateful for any general advice about how to go about (in detail if possible) protecting this database to prevent the design being altered or the data inadvertantly deleted??
Additionally could somebody please educate me about how a database will work over a network, particularly if two peole access it at once? For information I am installing the database on a shared network server, to be accessed by several users who have access to that "Drive." Can two people access it at once, and what happens to data integrity if two people have it open at once, or try to update it at the same time>
I believe the version of Access at workk is Access 2000, if that makes any difference.
As always, thank in advance,
Regards,
Mark.
I have been posting quite a few problems over the last few days as I've been working on a project for work, and I just wanted to say thank you to everyone for their assistance and patience! You will be delighted to know that the project now seems complete, and all I have to do is install it at work. Fingers crossed!
In the past the only databases I have designed have been for my own use and maintenance, so this has been something new for me.
I read with interest the "Access Ten Commandments," particularly with reference to preventing users (with even less knowledge than me) from being able to access certain features that may make the database and therefore integrity of the data vulnerable.
I would be really grateful for any general advice about how to go about (in detail if possible) protecting this database to prevent the design being altered or the data inadvertantly deleted??
Additionally could somebody please educate me about how a database will work over a network, particularly if two peole access it at once? For information I am installing the database on a shared network server, to be accessed by several users who have access to that "Drive." Can two people access it at once, and what happens to data integrity if two people have it open at once, or try to update it at the same time>
I believe the version of Access at workk is Access 2000, if that makes any difference.
As always, thank in advance,
Regards,
Mark.
Last edited: