MS Access Database Speed Question

[ykhamitkar]

Hi There,

I have some questions about ms access database

1. How much data ms access can handle with good speed.
2. Does the size of column affect the speed of ms access database.
(If i keep size as 100 instead of 50 in the Field Size property in design view)
3. If I create a client server application and 10 people work on the same database at the same time, Would it affect the speed of the database
4. Is there any way I can keep a back up of each record deleted. if somebode deletes any record in form the deleted record should be stored in an archived folder.
5. Also In my requirment I want to track each and every activity that users do. For example if somebody changes any textfield in the form his details should be stored in some database.Is there any short cut way to do this.

Please help me with these answers.

Thanks,
Yogesh

[NeoPa]

You have (accidentally) posted this question in the Access Articles section. This is NOT an article.
I'm moving this to the main Access questions forum.

MODERATOR.

[NeoPa]

1. I don't know - try here (Microsoft Access Specifications)
2. I believe not. The amount of data may, but only very marginally.
3. Yes
4. You can code your project to log all deletions.
5. No shortcut way that I know of. See answer to point 4, but arrange to log before and after images for each each update.