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 file.it is very slow...How to spead up the application ?? Is there is any other way could i use...for multiuser application .....

Posted by on

  • bobby_81 Oct 02, 2007

    thank you daverh....and applolize for late response....

  • kavimca Sep 23, 2008

    how to write a query to display sum of two weeks information
    using MSAccess


×

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Novelist:

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

    Scholar:

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

  • Expert
  • 117 Answers

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

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How can I shared files in 2 computers. Can I have step by step. One has to see the other and viceverse, changing and sharing information about statements and bills


Well if you want to actually see each other's computers in real time you can use a desktop sharing application like cross loop (there is a free version).
If you just need to share the files I recommend dropbox. Its a free application that lets you set up a folder on your computer that you can access from any other computer. Additionally you can share it with other users. It is very easy to setup and a very reputable application.
www.dropbox.com

Nov 11, 2010 | Computers & Internet

Tip

Tips on Editing a PDF File


Since PDF is an open file format architecture specification, anyone can advancecomputer application utilities. Adobe gives the free access to apprehend the agreeable of PDF files. But it is not accessible to adapt a pdf book as we adapt a word document, accordingly to adapt a book one can use the afterward methods:

Commercial software: If you are abiding to use conversion application regularly, you can acquirement thec omputer application which is abnormally fabricated for editing pdf file. Infix and Adobe reader Acrobat are some examples for this type of conversion software.

Freeware PDF editors: Editing a pdf book is additionally accessible with the advice of free application accessible on the net. But you accept limitations like admeasurement of the book and utilities on this free software. Hence accept thecomputer application which fulfills your requirements.

Online editors: There are affluence of multi-lingual conversion application accessible online. This converter application has the adeptness to catechumen thecomputer application from PDF to .doc or .rtf files. To use this ability you accept to upload your book to the website. Then, adapt the book in your browser with the online software. This is not appropriate for arcane abstracts because you accept to upload your book to an alien server.

on Jan 14, 2011 | Computers & Internet

Tip

How to restrict access to your applications on shared network?


APPLICATION LOCKER FOR WINDOWS 7
  • If you are usually sharing your computer with someone else, then you might want to restrict their access to your applications, files or documents.
  • Using the AppLocker tool, you have a few options to do this by blocking other users to access Executables, Windows Installers, Scripts, a specific publisher or path.
  • You can simply do this by pressing the Windows key then typing Gpedit.msc. Then go to Computer Navigation -> Windows Settings -> Security Settings -> Application Control Policies -> AppLocker. Right click on one of the options ( Executables, Installers, or Script ) and create a new rule. That should save you from a lot of headaches.

on Jan 30, 2010 | Computers & Internet

1 Answer

Please help with this assignment on computers


Its better if you could do this by your own. Othewise you won't learn anything :D.
Multiprocessing - An operating system capable of supporting and utilizing more than one computer processor. Multiprocessing refers to an operating situation where the simultaneous processing of programs takes place. Below are some examples of multiprocessing operating systems. This also comes with Multi Tasking and Multi user (and multi threading as well). There are SMP and ASMP systems. Read further from here It can be a system which controls a computer or any other hardware device. Examples: Unix/Linux (true support), Windows NT, Windows 2000, Windows XP Professional Windows use SMP and XP sometimes tends to give errors). Vista Business, Enterprise, or Ultimate support multi core and multi processing/processor technologies. (Same applies for Windows 7) Any Server OS such as Windows 2000, 2003, 2008 (not good for client computing. they are servers)
You have to analyze the actual requirement here. Multi processors or multi-core/mthreading/mtask. I don't see any necessity to run a multi processor OS though. You can select a Unix version if the cost cutting applies but need to find an application which suites it. Not sure whether you could find such an advanced application according this scenario.
RAM requirements. Depends on the OS, Workload and the Application. You can check for each OS and use recommendations. Check the application requirements and compare it with the OS. To get an idea of the work load you have to simulate a system and use compmgmt.msc and add a Performance Counter. Each application has workload data in their web sites.
Processor requirements: Pentium which class? 4 is good 2.4GHz and upwards. Better a dual core for the scenario. No need to go for a core 2 or quad core if the cost cutting involved.
Hard drive: Depends on the OS requirements. And the applications + storage. The number of customers will affect this very much. You have to re adjust it after examining the Application requirements.
If you need to share the data you have to think of a storage server and file sharing as well. (If the application supports running an internal database one of your machines should hold the database or run in in a server to support multiple users. Nowadays most apps require such. But the requirement says to store data in local PCs so you can ignore it).
Internet requirements. Analyze the required bandwidth for application in the LAN/WAN. 100mbps would be enough in most cases. Internet speed depends on the number of transactions a day. 1. Application 2. Per User. 3. Per employee. Its easier to find the app requirements. It should be available in the product sites. If not assume. (Availability, Response time, Reliability) Per user: Only if users access from the internet. Ignore otherwise (Availability, Reliability). Per Employee: Add user traffic to the findings. (Availability ,Response time, Reliability)
Internet requirements : No clue given. Check available options in your country. ADSL 2+ would suite with 1Mbps or more. This must not be a bottleneck ( in case of a single gateway failure).
Scalability Issues. You have to support scalability (in case of an expansion) Each app must support it. The network requirements must support it.
Availability = Approximately Real-Time.
Response time: Avoid bottlenecks (OS or app or network and specially no slow machines due to RAM/ Processor over utilization and HDD slowness) Sata would suite in your case (but its possible to use iSCSI since its reliable and fast).
You need a corporate printer (if cost cutting not applied - a print server). Otherwise a shared printer. (You can use Windows work group - May differ in Unix) Fax if necessary. Its fine if all in one machine could be purchased. There are low cost solutions from HP.
A backup database or a HDD.
An E-mail solution. (You can utilize public platforms as well such as Yahoo - Offers more security).
Reliability : The major factor Bottlenecks >>> 1. PC hardware (you can use the required). 2. LAN Switch and/ or Router (If and only if the network needs to be analyzed. Use a hot standby switch / router to avoid bottleneck. How ever if there is not much necessity for a Network environment you can just use an ADSL router with a switch. Switch should address scalability issues). 3. Using a backup connection such as a Modem connection for internet.
I don't think labor requirement is an issue. A user who has capabilities to administrate the systems will be enough. 1 Person. Antivirus / File Antivirus / Firewall (a must). Recovery software if needed.
Hope this helps to give an idea.
Please be kind enough to rate this answer with a testimonial.
Please feel free to contact any time.
Thanks for contacting Fixya.

May 31, 2010 | Microsoft Windows XP Professional

2 Answers

How to create an application which should expire in 30 days


at the time of installation, write down the date in a secret file or database.
each time the application starts check the difference in days from the current date.

each time the application starts save in another place the application last started date.
if the user tries to change the computer date, then you will know if he has set it before the last started date or before the installation date.

Jan 15, 2010 | Microsoft Visual Basic 6.0 for PC

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 Computers & Internet

2 Answers

Linux


can't do any thing here. you have to call Microsoft to buy a multi-user version of Access.
the Access program came with the Microsoft Suite is design for single user.

May 20, 2009 | Red Hat Enterprise ES 4 for Linux

1 Answer

Ms access


Microsoft access is a database application that is part of Microsoft Office. It lets you edit .MDB database files. Installing Access also installs the drivers that allow other applications which use the MS Access database format to also open their databases as well.

Not sure what your question means. If you want more information please ask me before rating the solution.

Jan 31, 2008 | Microsoft Windows XP Professional With...

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

84 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

3015 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...