Access

Resolved · Low Priority · Version Standard

Thu 7 Feb 2008, 12:12 Delegate Vimal said...

Vimal has attended:
Access Introduction course
Access Intermediate course

Access

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

Mon 11 Feb 2008, 10:07 Trainer David said...

RE: Access

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips