Access

Resolved · Low Priority · Version Standard

Access

Vimal has attended:
Access Introduction course
Access Intermediate course

by - delegate Vimal [2 posts] (2008 Feb 7 Thu, 12:12) Reply

Our current data base hold numerious record on the product BPP LM produce. The database is in constant use and is accessed by many users at onece.

At time the database does become unstable and looses work that others have done in the past date. What will be the best solution for me sort this ongoing issue and to stablise the database in the long run?

The little understanding I have of the database, as I wasnt the designer, it links in to numerous tabes, forms, and table and possibley macros are in use...

many thanks

Regards

Vimal

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	2	book now	£215	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
2003	2009 Jan 6 Tue	Southwark	5	book now	£198	£215
Full Schedule: See all 51 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Access

by - trainer David gold contributer [428 posts] (2008 Feb 11 Mon, 10:07) Reply

Hi Vimal,

I cannot really suggest anything to stabilise your Microsoft Access database in the long run, but if you are having many users logging on to the database you may want to think about upgrading to a more commercially based database system. Some good examples would be Oracle, IBM DB2, MS SQL ans MySQL. All of these examples are specifically designed to cope with high numbers of users.

Hope this helps
David

· Microsoft Access: Unleash the True Potential Today
· MS Access: Access your Personal Information with Ease
· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· Microsoft Access Tighten your Security Controls
· Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database

Please browse our web site to find out more about
access vba and other Microsoft training courses.

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options
Ø No

§ This Item is not a running total

Ø Over Group

§ This Item is a running total which will reset to zero with each new group value

Ø Over All

§ This Item is a running total which will total over the whole report