Solved

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

Posted on 2010-11-30
7
480 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
[X]
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
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
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.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

737 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