469,913 Members | 1,947 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,913 developers. It's quick & easy.

MS Access Database Speed Question

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.

Jun 14 '07 #1
2 1417
32,231 Expert Mod 16PB
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.

Jun 14 '07 #2
32,231 Expert Mod 16PB
  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.
Jun 14 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

63 posts views Thread by Jerome | last post: by
14 posts views Thread by Sean C. | last post: by
49 posts views Thread by Yannick Turgeon | last post: by
9 posts views Thread by Tony Lee | last post: by
27 posts views Thread by SQL Learner | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.