GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Database  >  Microsoft Access
Go To First  |  Previous Question  |  Next Question 
 Microsoft Access  |  Question 24 of 29    Print  
How to share a Microsoft Access database across a network?

  
Total Answers and Comments: 2 Last Update: April 14, 2008     Asked by: Bessie 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
April 10, 2008 09:38:20   #1  
MaryLustion Member Since: April 2008   Contribution: 1    

RE: How to share a Microsoft Access database across a network?
+ Its recommended to split the database in Frontend and backend.
+ Put the backend on a server/common computer.
+ Give appropriate permissions on the folder for all the users who would be using that database
+ Then Save a copy of the frontend on all the local computers of the users.
+ Make sure the linked tables are refreshed.
+ This method helps in preventing corruption to a great extend.
+ You can also keep the frontend on the server along with the backend and have shortcuts for the frontend on the local computers.
+ But this is more risky as it can cause corruption in DB
+ Having a non-split database is also another method but not recommended by microsoft.

 
Is this answer useful? Yes | No
April 14, 2008 16:34:09   #2  
johnjustin Member Since: March 2008   Contribution: 8    

RE: How to share a Microsoft Access database across a network?

Place the database in a computer which is connected in a network. Place the front end application in all the computers connected in the same network. Modify yor code in such a way that the applicaiton is accessing data from that computer where the database is available.


 
Is this answer useful? Yes | No

 Related Questions

Latest Answer : It's light-weight and suitable for small-scale applications -- those that require only a little amount of data to be saved.  Especially for beginners, it's easy to tinker with. ...
Read Answers (1) | Asked by : Dp

View Question | Asked by : RyanJames

What are the steps for setting referential integrity between two tables present in the Microsoft Access database?
Read Answers (2) | Asked by : blenda

View Question | Asked by : joel

What is the approach or method for implementing user-level security with replication in Microsoft Access database?
View Question | Asked by : norman

Latest Answer : From Database Manager run "Compact and Repair Database" ...
Read Answers (1) | Asked by : timmy

View Question | Asked by : fred

View Question | Asked by : fred

View Question | Asked by : sripri

View Question | Asked by : sripri


 Sponsored Links

 
Related Articles

Using XMLType for Handling XML Data in the Database

Using XMLType for Handling XML Data in the Database Being an object type XMLType can not only be used to store XML data in the database but also to operate on that data via its built in methods Regardless of the storage model you choose XMLType provides a set of XML specific methods to operate on XM
 

Using Oracle Database for Storing, Modifying, and Retrieving XML Data

Using Oracle Database for Storing Modifying and Retrieving XML Data With Oracle XML DB you have various XML storage and XML processing options allowing you to achieve the required level of performance and scalability One of the most interesting things about Oracle XML DB is that it allows you to per
 

Performing XSLT Transformations inside the Database

Performing XSLT Transformations inside the Database Now that you have the employees XSL stylesheet stored in the database and the xmlusr schema is permitted to access the hr employees table you can create a script that will instruct the database to build an HTML page based on the data stored in hr e
 

Moving All the XML Processing into the Database

Moving All the XML Processing into the Database In the preceding example the database server performs only a part of the XML processing while the rest is still performed by the PHP engine Specifically the database server generates an employees XML document based on the records from the hr employees
 

Performing XML Processing inside the Database

Performing XML Processing inside the Database When building XML enabled applications on top of Oracle there are many advantages to performing the XML processing inside the database when compared to performing it on the client The key advantages to perform XML processing inside the database are as fo
 

Network Topology

Network Topology There are two levels in a network topology and there are five kinds of network topologies The networks can be connected at two levels the physical and the other is logical A topology basically defines how the network has to be designed and provides a structure to the network mosgoog
 

Network Management

Network Management Network management is the method of managing the tools that belong to a network and maintaining administering all the systems that are connected in the network For one to be able to efficiently manage a network that person should be a qualified network administrator and should hav
 

Network Designs

Network Designs While designing a network many factors have to be taken into consideration like the area to be covered capacity of data that has to be handled and even security issues However when it comes to networks there are LANS or the Local Area Networks and WAN the Wide Area Networks These are
 

Online Virtual Business Network

How to begin an Online Virtual Business Network What is Virtual Business Network Business and commerce right from the ancient days depended a lot on the physical representation of the business and the physical identity of the customers and other collaborators Most of the business dealings were done
 

N-Tier Architecture: Data Access Layer

N Tier Architecture Data Access Layer In an N Tier architecture the data access layer consists of components that aid one in the process of accessing the database When it is used correctly the data access layer serves as an abstract level for the structures of the database Simple changes that are ma
 

Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape