Question about Microsoft Office Standard for PC

1 Answer

MSACCESS Multi user APplication

I have devloped access application and using by more than 30 members at a time. i placed the backend file in the share drive and frontend in the PCs desktop by linking the tables to the backend is very slow...How to spead up the application ?? Is there is any other way could i use...for multiuser application .....

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert who has written 50 answers of more than 400 characters.


    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 98 Answers
Re: MSACCESS Multi user APplication

Access is never good for multi-user with more than about 10 users! MS say: use SQL server. Of course, it all depends on the complexity of the app, the amount of data, transaction rate etc. You can also try putting the backend on a "real" server (15K rpm SCSI or sSCSI disc, Xeon CPU) and give it as much RAM as you can afford (at least 4GB) then you might get reasonable performance. If you can't do it any other way & a licence for MS SQL Server is out of the question, use MySQL as a backend: you can make Access clients talk to it as there is a free Access driver for it. You can even run MySQL under windows: you don't need Linux (although it will run faster under Linux). Setting it up is fairly easy and it will outperform an Access backend by at least an order of magnitude, if not 2 or 3 :)

Posted on Sep 22, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

1 Answer

Damaged mdb 2010 file gives strange error message

First one apply short guide, second make use of MDB Open File Tool
· Launch the Microsoft Access application, but do not try to open the corrupted MDB file.· Go to "Tools" in the top menu bar, expand the "Database Utilities" submenu and select the "Compact and Repair Database" option if you are using Access 2002 or 2003. If you are using Access 2007 or 2010, you can find the "Compact and Repair Database" option by clicking the Microsoft Office button and going to the "Manage" menu.· Highlight the MDB file that you want to restore and click the "Compact" button.· Enter a name for a new database file, which will contain the restored data from the damaged MDB file.· Navigate to the location on your hard drive where you want to save the restored version of the file.· Click the "Save" button. Access will now compact and repair the MDB file and save a restored version in the location you selected.

Jun 23, 2015 | Microsoft Access Business & Productivity...

1 Answer

Extract RSD files

Files that contain the .rsd file extension are normally associated with the RealSQLDatabase. The RSD file format that associated with this file type is a database file format that is used by the REALbasic software application.

The REALbasic software program is an application that is used to develop other software applications that use the BASIC programming language. These RSD files store the database information in a structured format. The information contained in the database can then be accessed using the various SQL commands.

The .rsd file extension is also used with Roland software program. These RSD files store sound files that are used by the application.

Or in simple terms you need the right software to use a RSD file.

Oct 23, 2013 | Rosetta Stone Business & Productivity...

2 Answers

I am getting error codes 6129,0 and 6073, 816 on my quickbooks 2008. What can I do to open the company?

This error can occur when:
  • Data is converted or restored over a network.
  • Several computers are acting as host for the QuickBooks data file.
  • QuickBooks is unable to communicate with the server.
  • There is data damage in your company file.

If the error occurred when you were restoring a company file from a backup or updating a company file to a newer version of QuickBooks over a network:
  1. Copy the backup file (.qbb file extension) or the company file you want to update (.qbw file extension) to a local hard drive.
  2. Restore the backup or update the company file.
  3. Copy the restored or updated company file back to its original location.

If the error occurred when you were trying to open and use a company file:
  1. Update QuickBooks to the most current release on all computers that open the company file.
  2. Close QuickBooks on all the computers with access to this company file.
  3. On the computer you select to host the company file, switch to single-user mode, and then back to multi-user mode:
    1. Open QuickBooks and open the company file.
    2. Choose File > Switch to Single-user Mode.
    3. Choose File > Utilities > Stop Hosting Multi-User Access.
    4. Choose File > Switch to Multi-user Mode.
    5. Choose File > Close Company to close the company file.
  4. On all other computers that will use the company file, stop hosting multi-user access :
    1. Press and hold Ctrl while you open the QuickBooks program and continue pressing Ctrl until QuickBooks opens completely. This opens QuickBooks without opening a company file.
    2. Choose File > Utilities >Stop Hosting Multi-User Access. If that option doesn't appear, the computer is not hosting and no further action is necessary.
    3. Repeat steps 4.a and 4.b for each computer other than the host computer.
  5. Configure the QuickBooks server for multi-user access:
    1. Click the Windows Start button and choose All Programs > QuickBooks > QuickBooks Database Server Manager.
    2. Click the Scan Folders tab.
    3. Click the Add Folder button, select the folder that contains your QuickBooks company file, and click OK. Repeat this step if necessary to add additional company file folders.
    4. Click the Scan button to begin scanning. After the scan is finished, the company files in the scanned folders are configured for multi-user access.
  6. Open the company file in QuickBooks. If you receive the same error message, refer to Settings required for firewalls to make sure your firewall is properly configured to allow QuickBooks access to your company file.
  7. Open the company file in QuickBooks. If you receive the same error message, open a different company file or a sample company file located in one of the folders you scanned with the Database Server Manager.
    • If no company file will open, reboot the host computer and try again.
    • If other company files open without error, the company file generating the error message may be damaged. For more information refer to Verifying and rebuilding QuickBooks company data.

Jun 01, 2010 | Intuit QuickBooks Pro 2008: Windows

2 Answers

New windows 7 not able to open files

It's not Windows 7 Problems, your files should open with a "proper installed" application.

I mean, you should use Microsoft Access (MS Office) to open several files like .DBF, .TBL etc.

If you have specific application to handle your Invoice System, you should install the application as well.

Have you had it installed in your new computer?

Jan 20, 2010 | Business & Productivity Software

1 Answer

How to link vb 6.0 to msaccess?

You Need ODBC to solve your link... ODBC is a gateway. Can Access by Microsoft Access or VB in same time... Note: Please in Code Programming you must lock or unlock you data if you want application running same time..

Jul 20, 2009 | Microsoft Business & Productivity Software

1 Answer

Unexpeted close promodag.


Olmapi32.dll is one of the MAPI components installed with Outlook 2007. I think that your current configuration file contains one of the following conditions: account impersonation in the Exchange Connection tab of Tools > Options, and/or a hidden mailbox to establish that connection to the Exchange system. That could work with Outlook 2003, but not with Outlook 2007 or 2010.
Can you follow these steps:
  1. Locate the Repex.pri file, that you should find in the %SYSTEM%\ProgramData\Promodag\Reports\8\ directory.
  2. Edit it using NotePad.
  3. Delete the following values (xxxx in red):
    • MAPIServer = xxxx
    • MAPIMailbox = xxxx
    • MAPIUseNTSpecific = x
    • MAPINTAccount = xxxx
    • MAPINTPassword = xxxx
    • MAPIUserName = xxxx
  4. Save the Repex.pri file.
  5. Start PROMODAG Reports.
  6. Go to Tools > Options and open the Exchange Connection tab.
  7. Enter your connection settings (user account and mailbox) and make sure that the following conditions are met:
    • The user account is a member of the local Administrators group.
    • The user account is a member of the Exchange View-Only Administrators group.
    • The user account is associated to a mailbox and you select that mailbox (Outlook 2007 MAPI client libraries do NOT support impersonation).
    • The mailbox is not hidden in the Global Address List (Outlook MAPI client libraries would make the application crash).
I believe this should be sufficient to solve the problem.

Best regards,
Pierrick Lussan

May 26, 2009 | Software Shelf International Promodag...

1 Answer

Company file in use message when several users access the file

If this is a real time program changes should be able to be made simutaniously. Check with your IT department, they may have to increase the allowed user #. If your position is top priority, some programs will allow more than one "super user" profile, the "super user" can make changes at anytime, but that profile is subject to corporate approval.

Apr 23, 2009 | Intuit QuickBooks Premier 2008 (3-User...

7 Answers

Undelete records from access table

ou can try to use third party Access recovery utility to restore your lost and damaged data from .mdb files. For more details about this software:-
Access File Recovery

Apr 17, 2009 | Microsoft Access 2000 (077-01277) for PC

1 Answer

Palm OS-based PDA freezes up

If you’re not sure what file or application is causing the problem, you’ll need to perform a hard reset. Before you do this, be sure to perform a HotSync so your data is properly backed up (the hard reset will erase all data on the PDA). To perform a hard reset, press the power button while performing a soft reset. Replace the power button when you see the Palm/PalmOne logo and press the Up button when prompted.

Next, find your Backup folder on the desktop. You’ll usually find this folder located within your user folder, which is usually located in either C:\Program Files\Palm, C:\Program Files\palmOne, or C:\Program Files\Handspring. Your personal folder will resemble the user name you selected for your device. If you used your first and last name, for instance, your user folder will likely be the first six letters of your first name followed by the first letter of your last name. Rename the Backup file to Backup.old and HotSync your Palm to restore personal data. Because you renamed your Backup folder, no applications or additional files will be restored at this point. Instead, an empty new Backup folder will appear. Move applications from your Backup.old folder into the new Backup folder one at a time and HotSync your Palm. After each HotSync, try to reproduce the problem. If the problem doesn’t reappear, move on to the next file. Delete any files that cause a problem after they are moved onto your PDA.

Enjoy! Pls.rate me if it's done. Thanks.

Kindly regards,

Feb 29, 2008 | Best Software ACT for Palm OS - Instantly...

1 Answer

"delayed write failed" in office 2003

You will get a delayed write failed when the network is no longer connected and the user tries to save the file. are you noticing any other issues on your network?

Sep 09, 2007 | Microsoft Office 2003 Basic Edition...

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

79 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides