By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,844 Members | 836 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,844 IT Pros & Developers. It's quick & easy.

MS Access Database Speed Question

P: 64
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
Jun 14 '07 #1
Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,566
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.
Jun 14 '07 #2

NeoPa
Expert Mod 15k+
P: 31,566
  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.