Davi,
I am struggling to answer your questions. I don't think I've
succeeded, but I've tried anyway.
My comments are in-line below.
Davi said:
Access 2003, Forum database: Web,User Name 1,User Name 2,Pass World 1,Pass
World 2,Question,Answer,Email,2
I am not sure what this list represents.
This link leads to a Google internet directory for chats and forums.
I am not sure what this link has to do with your post.
Save at D:/Computers/Chats_and_Forums/
It that OK?
If your filepath exists, it is ok.
How to design this database?
Database Design:
Database Design for Mere Mortals by Michael J. Hernandez
Query Design:
SQL Queries for Mere Mortals by Michael J. Hernandez, John L. Viescas
Normalization, Basics:
About.com
http://databases.about.com/od/specificproducts/a/normalization.htm
Tips to Get You Going
http://home.att.net/~california.db/tips.html#aTip1
Microsoft: Description of database normalization basics in Access 2000
(not significantly changed by Access 2007, see the article's own
references at the end to material from the early 1990s).
http://support.microsoft.com/support/kb/articles/q209/5/34.asp
MS Access Desing:
Building Microsoft Access Applications, by John L. Viescas
Don't repeat what?
Backup
How to backup in the same time?
For MS Access, backups are best conducted when no users are using the
database.
For concurrent database backups that are accurate and reliable, you'll
need a different database product.
So there is a multi-user requirement?
Split your database.
How to assure data will not be modified when use? Set rights?
You would design your database settings and Forms so that data
wouldn't be modified at the wrong time.
Or something in window? Not in data sheet mode use?
I'm not sure what you mean, can you clarify?
Sincerely,
Chris O.
