Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access

ResolvedVersion Standard

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

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

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.



View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.