Software

Ask something
Question Locked

Access 2007 Phonebook

0 helpful
3 replies

by chris.bradshaw

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi

Im a bit of a newbie with Access. I have the basic concept of forms, tables, etc. I want to make a simple database that I can import 100 contact details into.

From this I then want to create a simple front-end form that allows users to search the database by either entering a person LastName & FirstName and the DB will populate a list of users that match the search criteria and then with all the selected persons contact details.

Once i have this working, then id like to use this DB on my companies Intranet to allow staff to have a central place where they can get anyones contact details in seconds.
If anyone can help me with this or point me in the right direction id really appreciate it :)

Thanks
Chris

3 replies

by john.a.wills

use a combo box with Row Source property
SELECT DISTINCT [NewUserSurname] & ", " & [NewUserGivenName] AS UserName FROM UserChange ORDER BY [NewUserSurname] & ", " & [NewUserGivenName];

by anneclive

Access 2007 comes with a Contact Manager Database Wizard - this should get you started and is easy to customise. To share the database on the intranet, you need to split it into a Frontend (users) and Backend. The Backend database should contain only the tables with the data. This sits on the server and is accessed across the intranet by users (each of whom have a frontend copy of the database). The frontend container (mdb) has everything EXCEPT the tables (that is forms, queries, reports). To access the data from the frontend mdb, use linked tables (search Help, my memory is fuzzy). So, in summary, on each user computer there is a frontend container (mdb) which has linked tables and all forms/reports/queries in each. Essential stuff: make sure you make a regular backup copy of the backend mdb that contains the actual tables and data. Users also need to keep you aprised of computer crashes while the database is open because objects (forms etc) can easily become corrupted and corruption is a snowball effect. To backup the backend mdb: create a new blank database and import all the tables and relationships into it making sure the working mdb has the same name as originally called (or your linked tables in the user frontends won't work). I believe the Help has info on this: search for Split database.

This discussion is closed to new replies.