Hal MCGee, Thanks a lot.
Brijraj Rathod India. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 25, 2005 6:20 PM To: [email protected] Subject: Re: [AccessDevelopers] I am always afraid about my database. Brijraj, 1. Always compact your database. If you have a back end front end split, be sure and compact the back end nightly when all the users go home. Also assign a timer form to your app that automatically logs out any user who is idle for a set amount of time, many examples of this are available on the net. Also, use a batch file to make copies of your critical databases before the nightly compact to a separate computer. 2. Good database design and form design. User training is also essential. 3. See 2. Also be sure you understand what the user needs, work with the person if possible to see how they work with data and computers. 4. Depends. If you hit the 2 gig limit, you can recover the database structure but generally not the data. I've only hit that when working with data from commercial systems. 5. Again good database design. On your tables add appropriate keys. If you are using Access over a network, then two issues are important. Access requires fast disk access, so if it is on a shared server with a heavy disk load, Access will perform poorly. Access also requires a reliable fast connection. Over long distances Access will have problems with the latency. As with everything else in life, keep learning. Read and buy Access books, use the web, go to school in database design and visual basic programming. Good Luck Hal Hal McGee Engineering Data Manager Group Engineering - Process and Compliance Seating Products Group B/E Aerospace Winston-Salem, NC "Brijraj" <[EMAIL PROTECTED] .com> To Sent by: <[email protected]> AccessDevelopers@ cc yahoogroups.com Subject [AccessDevelopers] I am always 08/25/2005 07:09 afraid about my database. AM Please respond to AccessDevelopers@ yahoogroups.com To All Access Developers, I have fear that I will lose my database. I don't know but I heard that Access Data Base is not reliable as the size Of Database Increase. ------------------------------------------------------------------------ ---- ------------------------------------------------------------------------ ---- (1) What is the tips to make Access Database Safer ? (2) How can we prevent Data from data Corruption ? (3) What is the Important point When we work in Access ? (4) What is the Chances of Database recovery if Database is corrupted ? (5) Through which way we keep our database More Speedy ? ------------------------------------------------------------------------ ---- ------------------------------------------------------------------------ ---- I know that I had five Questions, but this question r really important hope u understand. If u had any experience about database corruption then please guide me how u recover it. ------------------------------------------------------------------------ ---- ---------- * Stay in touch with www.inMail24.com! Your time-proof mailbox and photoalbum * Zoner PhotoStudio 7 - Your Photos perfect, shared, organised! www.zoner.com Please zip all files prior to uploading to Files section. YAHOO! GROUPS LINKS Visit your group "AccessDevelopers" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Please zip all files prior to uploading to Files section. Yahoo! Groups Links ---------- * Stay in touch with www.inMail24.com! Your time-proof mailbox and photoalbum * Zoner PhotoStudio 7 - Your Photos perfect, shared, organised! www.zoner.com __________ NOD32 1.1202 (20050825) Information __________ This message was checked by NOD32 antivirus system. http://www.eset.com ---------- * Stay in touch with www.inMail24.com! Your time-proof mailbox and photoalbum * Zoner PhotoStudio 7 - Your Photos perfect, shared, organised! www.zoner.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
