Solved

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

Posted on 2010-11-30
7
468 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 

Expert Comment

by:hitendramalviya
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Thank you
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
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…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

744 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now