How to build a Forum Account Database

How to build a Forum Account Database

Post by RGF2a » Fri, 15 Jun 2007 01:50:02

Access 2003, Forum database: Web,User Name 1,User Name 2,Pass World 1,Pass
World 2,Question,Answer,Email,2

Save at D:/Computers/Chats_and_Forums/
It that OK?

How to design this database?
Don't repeat
How to backup in the same time?
Use frequently
How to assure data will not be modified when use? Set rights?
Or something in window? Not in data sheet mode use?

How to build a Forum Account Database

Post by John W. Vi » Fri, 15 Jun 2007 02:47:19

On Wed, 13 Jun 2007 09:50:02 -0700, Davi < XXXX@XXXXX.COM >

I can't figure out whether you're offering a database or asking a question,
and if it's a question, what you're asking.

John W. Vinson [MVP]


How to build a Forum Account Database

Post by Chris » Mon, 18 Jun 2007 00:45:35


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.


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.

If your filepath exists, it is ok.

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:

Tips to Get You Going ~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).

MS Access Desing:

Building Microsoft Access Applications, by John L. Viescas

Don't repeat what?

For MS Access, backups are best conducted when no users are using the

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.

You would design your database settings and Forms so that data
wouldn't be modified at the wrong time.

I'm not sure what you mean, can you clarify?


Chris O.