Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2010-11-30
7
Medium Priority
?
491 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 2000 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

721 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