Multi-user Contact Manager, Any Ideas??

Jul 8, 2005

I'm in the process of recreating a contact manager for a group of salespeople at an office I work for... What I want to do is be able to consolidate all of the contacts in a single contact database on the back end. Then the records will have specific users specified to each record, and what I want to happen is that the users will open up their own database, and they will only see the records pertaining to them, and they can't change who gets the records.

Here's where it starts getting tricky. I want the manager to have access to all of the records, and I want him to select which user's contact list he wants, and it brings up those contacts. I want him to have a combo list on the screen where he can select who gets which contacts, and he can change them throughout the different users.

Related to each of these contacts is a subform, called CALLS... When this button is clicked, any information regarding past calls is brought up, and the user can add information about a call that is made. This checks the previous form that is open to find out the ContactID so that it can open up the corresponding CALLS entries in the CALLS table.

Here's what I did: I created a new contacts form for each salesperson (there are 5 salespeople). Then I had to create a new subform for each salesperson for the CALLS, and then the information will be gathered from the proper subform to the users contact form.

I can do all of the above, but it seems kind of redundant to do this for all of the users, and I'm wondering if there is an easier way to do this. Also, in the future if more salespeople are added and I'm not here for the company to set up the new users, I would like to see if there is an easy way for them to set it up (like adding a new value to a few different spots)...

BTW: One difficulty is that they are already using a previous contact manager (not designed by me) that has hundreds of contacts, but each user has their own separate copy of the contact manager which is just copied and pasted onto their local drive when a new salesperson arrives. I will also need to import all of their previous contacts, and I would like to maintain as much of the original structure as possible to avoid dealing with user compatibility problems.

If you need to see the contact managers, please let me know. Any questions, i will be glad to discuss. Thanks.

View Replies


ADVERTISEMENT

Need Ideas: Alert User When Record Hasnt Been Updated In Over An Hour

Jul 22, 2007

I have a form in continuous forms mode...
Each entry is something the user is supposed to check on once and hour and update.
I have a "Last updated" field.
Now() goes into that field every time the record is updated.
I have a querry that will show the users records that are over an hour old.

How can I get Access to pop-up a window or something to alert the user they need to look at something? It would be really nice if Aspect would start blinking in the task bar or something.

Thanks!

View 5 Replies View Related

General :: Timesheet Manager - Report Based On Date Range Given By User

Jul 7, 2014

I have the following project that works as a timesheet manager:

Users enter in a form the employee name/date/hours worked/role/overtime (yes or no)/rate... on a daily basis. At the end of every week, they must create a report depending on the dates given in a query.

I have only one table (tbl_EmployeeHours) and a query to calculate the number of hours between two dates.

At the moment a report gives me all the information above (employee name/date hours worked etc..) but what I am trying to is a bit different.

I need Access to create a report (based on a date range given by the user) that would give me: per unique name, the number of normal hours worked in total, next column, the number of hours worked as overtime (rate 1.5), then, the number of hours worked as overtime (rate 2).

This means there are 3 different totals. For example, in the date range given, someone might appear twice but in the report he will appear only once with 3 different totals...

My guess:

I would say I need to create a different query for the 3 different totals (normal hours, overtime 1.5 and overtime 2). For each query you would need to ask the user to input the date range (which would not be so user-friendly I agree...). Then, I am not sure how access would create that list of names and combine the 3 different results from the queries...?

View 14 Replies View Related

Multi-User - Can You Assign Which User Created/amended A Record?

Aug 4, 2007

Hi guys,

I've seen different log in forms and tips on multi-user use but can't seem to find info on the following...

We have 6 people at work and I'd like to assign which user updated a form or created a new record...this would be particularly useful on the sales part of the database to track who made a call to a particular customer...

Best ideas anyone?

dazza61

View 6 Replies View Related

General :: Access Multi User Database - Error On Only One User

Apr 24, 2013

I have a multi user database in Access 2000 that is on a server. The individual users have shortcuts pointing towards the server instance. One user and one user only when opening the shortcut gets the error "you do not have exclusive rights to the database" .

All other users can enter the database with no error box. I have checked the advanced setting under options and they are correct. Ironically if you go to start and open access then navigate to the database shortcut. It opens with no error.

View 1 Replies View Related

Multi User (1 X Rwx, 2 X R--)

Mar 2, 2007

I have read a lot about if multiple users want to share an MDB, they have to create BE and FE and split the database.

I understand having to do that if all those users want to write to the MDB simultaneously.

I have a situation where one person will do data entry (write access), and two other users will just want to view and perhaps just search the database (read).

If only one person is writing at any time, do I have to do all that splitting and FE/BE configuration?

View 2 Replies View Related

Multi User

Apr 17, 2007

I've create a form with subform that work like a charm, now they want in a multi user environment. What is the best way to achive this?

View 6 Replies View Related

Multi User Capacity

Sep 1, 2005

I plan to create a multi-user application on access 2000. There would be more than 20 users simultaneously logging in the database. The database would be kept in Server with high config. The users would work on the database (server) from their workstations. Forms/Queries/Reports ... are in the workstation (client). The database may growup to 70 MB every 3 months. The application will run on the database for 3 months which will be replaced with a new one after that period. Is it a good plan to do so on Access 2000. Am worried about the network traffic. Will the users face it as a very slow application ???

(SysConfig workstation: Win2K Pro/ 128 MB RAM/ 40GB HDD/Pentium-4)

Any suggestion is appreciated. Thanx in advance.
Prodigy.

View 2 Replies View Related

Multi User Access

Sep 5, 2005

Hi
If I want several users to access a database from their network pc's, should I place the access database .mdb file on the server and set the Sharing properties, then install the access application on each of their stations.

They need to each be able to use the database when they need to and read or add data, reports etc.

I am using access 2003.

Thanks

Dave

View 14 Replies View Related

Multi-User Recommendation

Mar 10, 2006

I maintain a database that is used by several people in my office. Only about 4 different people actually use the database but I would like the database to have multi-user support. As of right now the tables, forms, modules, etc. are all in a single mdb file. Can someone recommend a method for making this database accessible to several users at once? My main concerns are accuracy (changes commiting in the proper order) and low chance of corruption.

View 1 Replies View Related

Multi User Problem

Feb 7, 2007

Hey everyone,
I am in desperate need of your help. I have a split database that I am trying to enable multi users access to the database. I created a folder on the share drive with the front end and a folder on share (BEN) with the backend. I have changed the settings via options, advanced options, and checked that shared box however it will still not allow everyone into the database at the same time. Is there something that I am missing? Should I then right click and copy and paste the front end to local PC since the tables are split and still on the share drive???? I plan on using security in the future will this cause a problem???Thanks

View 3 Replies View Related

Multi User Environment

May 22, 2007

Hi,

I need to allow my MDB to have 15 users accessing at the same time. They will be updating different parts of the same table using different forms. The system will also do an automatic update from another system in 15 mins interval.

Is it possible? If so, how do I configure my access database?

Please help.

Thanks!!!

View 13 Replies View Related

Multi-User Database

Jan 29, 2008

I would like your opinion on this; I have a ms access database that will be used in a multi-user environment, across different Teams. Data will be loaded from text files several times a day in a MS Access table, users will retrieve the data from the tables and displayed in a form. Their job will be to add comments and select drop down boxes for actions they have taken. Since the data is downloaded in the tables and retrieved from the user instead of the user keying in the data from scratch I would like to know how to best design this. I’m thinking of having a query run to display the data in the user form but is there a way that I can have the data refreshed every so often so that users can be presented with the new records that are being downloaded. What best practice should I use to avoid conflicts like example splitting the database or using record locking options

Any help is appreciated! Thanks

View 2 Replies View Related

Multi-user Password

Mar 11, 2008

:Hi,
At the moment I'm writing a production database for work, which include parts in/out, production planning, kitting lists and other forms. What I'm after is a way that when the database opens it asks for a password and depending what it is, is what you can do. Administrator can do all, Stores can only enter parts and scheduler can only enter planning and so on.

How easy is this? :o

View 3 Replies View Related

Allow Multi-User Environment

Mar 14, 2008

1) I develop my application(Ms-Access 2k) and put into company network directory.

2) The problem here is only 1 user allow to access per time.

3) Is there any setting I miss out?

View 4 Replies View Related

Need Help On A Multi-user Database

Mar 17, 2008

Hello Everyone! I have a project that is driving me crazy!! :mad:
I have a form on a database that retrieves data from a query; this database is in a multi-user environment. What I am trying to accomplish is to allow the form to bring up the next available record that has not/or is NOT being worked on yet. The form I built does a re-query every time the user goes to the next record and looks for anything that has not been worked on yet. It does this by looking at the timestamp the user has placed once completed the record on the form. I also placed my record locking option to Edited Record. However when the users sign on simultaneously they still get the same item on their screen. Is there a way to create some sort of locking mechanism that would allow the form to display to the user the next available record that has not been or is not being worked on by a user at this time? Theoretically I am looking at something like this: Once a user opens the form and the record is displayed on the screen, lock the record and avoid any user from viewing or editing this record. All other users should be directed to the next available record, every time the user hits the next button move to the next available unlocked record and immediately lock it from viewing or editing from everyone else.

I appreciate any help you can provide me on this!!

View 1 Replies View Related

Multi User Enviroment

Nov 1, 2004

Hi everyone,
can anybody help me on this. I have two PCs connected and i am trying to execute an Access file from the client PC. This appears to be possible but the problem is that i cant save any new record and Active X or OLE seems to be the problem according to the message box appeared when i execute a form. The file works normally when executed from the server.
Any ideas?
It appears that the problem comes when Vba Code is executed for example i can save records from the tables but not from the forms where VBA code is attached

View 2 Replies View Related

Multi User Problem :(

Dec 9, 2004

Hi all, question about using a table for temporary storage. When a user clicks a button after selecting critiera, a form is displayed with fields bound to a TempTable. On this form is a subform which pulls 3 peices of data from a table called QuestionsTable. As a user clicks through the subform, two fields are populated by the user and get stored in the QuestionsTable.

Once done, the user clicks a button and a SQL statement grabs the data from the main form (TempTable) and subform (QuestionsTable) and shoves it into the Archive table. A SQL statement then runs to delete the contents of the TempTable, and Delete the *modified* data in the QuestionsTable (by simply setting the 3 fields which will change to " " or Null).

Now my problem. If two users are in the same form and one clicks save, the SQL statements eraase everything... so the 2nd user will be mid process and their data will poof.

I want to assign a Session ID each time the main form is loaded. This is set via AutoNum in the TempTable. My question is, how can I copy 3 fields (Question, Comment, Result) from the QuestionsTable and insert them into the TempTable, then have the subform load the 3 fields from the temptable (so in essence, everything is loaded from TempTable).

Did that make sense? Sorry if it didn't, I'm reaching my deadline on this and have a bad cold

View 3 Replies View Related

Multi-user Form

Jan 13, 2005

I have a form "log_file" that I am going to be placing a nework. All I have done is create a new DB, create a table, and create a form. Now I want to make it so users open up the DB file and only see the form and cannot access/edit the table. Basically, It is okay if they go back and forth through the records and change those, but I don't want them to be able to edit the form either.

I'm just not sure where to go from here. If there is more info I should provide please let me know.

Thanks in advance.

View 3 Replies View Related

Multi User Diary

Mar 22, 2005

i am looking for an outlook style planner in Ms Access for a booking sytem i am trying to put together, can anyone point me in the right direction of how best to tackle this please.

I have scoured the net for samples, and have come back to the most helpful place on the net for more assistance on where to go with this...

What i am looking to do is to set up something like this..

Click here to see example picture

how hard would this be to do?

Cheers

Andy

View 3 Replies View Related

How Do I Log Out On Users On A Multi-user System?

May 27, 2005

I run a multi-user system of over 200 users. The only facility I have for advising an office-wide logout is required is the email system. However, staff either don't read their email or forget so I have to run around like a headless chicken trying to get everyone to get out/stay out of the system while I perform maintenance etc. Is there a way to enforce a logout and keep users logged out until a requested time without spending a fortune on new software?
Any advice would save me a lot of hair pulling (not mine :)).

View 2 Replies View Related

Multi-user Remote Database

Jun 22, 2005

I am currently attempting to setup a database that will be used by many people. I have the database setup and it is split into a backend (tables and data) and a front end ( forms, queries, etc) which the users will download and use off their own machines. I'm attempting to house the backend on our webserver.

The backend is on our webserver and I'm attempting to link the tables from the front end to this location. I typed in the webaddress into the open menu after selecting the Get External Data --> Link Tables menu item. I am sure that this web address is correct because I copied from my browser (from which I was able to download the database from). After I put in the web address into the open box, I get an error about not a valid file name. Is there something I'm not thinking about? What could be my problem? Is it permissions maybe? Does there need to be something special setup with the backend or my webserver? Any ideas as to do with the problem would be greatly appreciated.

View 3 Replies View Related

Accessability/Security In A Multi-user Env.

Aug 20, 2005

I need to implement some type of security on my database to limit the forms/reports users can access. When implemented it will be a split database on a network. I'd like to set it up so only certain users can edit/add data on certain forms. Also I want to have more than one user be able to edit/add data at the same time. I'm confused as what I need to do to set up this type of security. I found another post on this forum by Oldsoftboss (Dave) that gave a good, working example of a database with user login screens and different user security levels. My questions are:

1. Can I use his system in place of the built-in Access security?
2 . Do I need to implement both? If I don't use or change the access rights in
Access security, won't everybody be logging in with "Admin" rights?
3. What do I need to do to let multiple users work in the database at the same
time? I've already changed the database to "shared".
4. I don't want the users being able to change the forms, queries or reports
so I'm distributing an MDE file. Is there anything else I need to do so
users can't access the "design" button?

Needless to say, this whole security thing confuses me. Any help would be appreciated.

Rod

View 1 Replies View Related

How To Make A Multi User Application

Aug 23, 2005

Hi, I have made an application, which records daily work done and generates some reports based on daily records updated.

I have about 40 team members, i want this application to be multi user, how can i do this.

Can i store this application on a sharedrive and give a replica to each user? if yes how shall i do it.

Please suggest. any help will be highly appreicated.

View 1 Replies View Related

Multi-user Database And Design Changes

May 4, 2006

My database is on a shared server and many people are able to access the database at any time. What would be the best method to create a way for me to make design changes, etc. without having to make sure everyone is out of the file to allow me to open exclusively?

View 6 Replies View Related

Timestamp, Multi-user Issues.

Jan 10, 2007

I use a timestamp field in my tables to help me with productivity metrics for about 6 individuals who use one of my databases.

The issue I have is that their system times are constantly "out of whack." We fix them, and it just happens again. It apparently another program on the computer that causes the issue, but I can't do anything about that.

Is there another timesource available for the timestamp when using now()? Is there a way to use the time of the server (shared) that the backend is on?

I have no idea how to fix this issue.:confused:

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved