Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

access shared database on workstations shared over a network with a server

Posted on 2010-11-30
7
475 Views
Last Modified: 2012-05-10
I just started consulting for a ski shop that has an access database on a windows 2000 server shared over the network so when they make a change on one workstation it propigates to all workstations. The problem is I installed a new workstation on their network because of a motherboard failure and i do not know how to get the database to work on the new computer. I installed access on the new computer but i am not sure what to do next.
Thank you for the help.
0
Comment
Question by:jhreboot
7 Comments
 
LVL 3

Accepted Solution

by:
cnjuguna earned 500 total points
ID: 34239216
Do you have the location of the file? To share an Access Database only 1 copy is maintained say on a shared folder on a server. The user computers will only have a link to the database. The database allows for multiple simultaneous connections to it.
0
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 34239248
If the database is using Front End and Back End Structure, you just need to get a copy of the Front End. You may only open the file and you can access right away its records.

And if it is an access shared file, you need to navigate and open it from the folder where the file is located.

Sincerely,
Ed
0
 
LVL 2

Expert Comment

by:compTrack
ID: 34239401
Hello There,

I have been programming on MS Access Databases and have given consultancy services, provided solutions and deployed them in a client-server fashion for quite some time now.

What you need to do is this:

1. Split the MS Access Database using the Database Splitter tool that comes with MS Access. This will split the MS Access Database into a Front End (that contains all the forms, reports and queries) and a Back End (that contains the tables). However, the Front End will contain Linked Tables to the Backend.

2. Create a folder on server and place both the Front End as well as the Back End in that folder. Lets name this folder say for example "Database Folder"

3. Now on every client machine, what you need to do is map a network drive (Tools -> Map Network Drive) to the folder on the server where you have put both the Front End as well as the Back End (the folder we called Database Folder). Lets say, you mapped that network folder as the M:\ Drive

4. Now, in the C:\ Drive of every client machine, create a folder (lets call it "clientFolder"). In this forlder, create a batch file and add the following script to it:

:Download
copy "M:\FrontEnd.mdb" "C:\clientFolder\FrontEnd.mdb"

"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" /excl "C:\clientFolder\FrontEnd.mdb"
:END

Note: In the second path in C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE, change the Office12 to the version of office you are using. Example, Office 2007 is office12 if I am not wrong. Office 2010 is office14.

5. Right Click on each of the Batch file so created in the above step on every client machine and say "Send to desktop" to create a database shortcut on the desktop for every client user.

Im sure there are other ways, but this has worked very efficiently for me over the years.

Keep us posted.

Best Regards,

compTrack.
0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 

Expert Comment

by:hitendramalviya
ID: 34239555
You can simply create DSN :
1) Go to control panel > Administrative tools. Open Data Sources(ODBC).
2)Select tab System DSN > Click on Add button.
3) Select Microsoft Access Driver(*.mdb) from list & click on finish.
4) Now give Datasource Name. & Select Database from your network path. then click on ok button.
5) Now dsn created successfully & you can use dsn name for your connection.
0
 

Author Comment

by:jhreboot
ID: 34242425
I do not see a dsn on the other computers.
I created the dsn now what should i do?
0
 
LVL 2

Expert Comment

by:compTrack
ID: 34243359
If I am not wrong, DSN is used to programmatically access Back End Tables when one needs to manipulate row values using code.

I thought the scenario here was that the database was already developed and needed to be deployed in a Client - Server Architecture.

Have I understood the question correctly?

compTrack
0
 

Author Closing Comment

by:jhreboot
ID: 34248898
Thank you
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question