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.
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12hlapmt9/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124981471/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org
">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life
- brought to you by One Economy</a>.</font>
--------------------------------------------------------------------~->
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/
