Find Jobs
Hire Freelancers

Access LAN-Based mini-CRM

$100-500 USD

Completed
Posted almost 20 years ago

$100-500 USD

Paid on delivery
Mini Client Request Management System Access 2000 database deployed on a network via linked tables **Context** We need to install the database on a LAN using one master DB with separate DBs and, on each user's PC, a separate DB with a linked table to the master DB. I've used Access' default record locking. **The problem: ** It installs fine, but locks up the system as soon as we do anything remotely complicated, such as switching languages (which closes a subform and opens another) and changing the data in the *historique* field (which is on the main form but is fed from the subform). I may have skipped certain elementary DB design steps, given that this is only my 2nd real Access project to date. I do have SOME knowledge, however, so while the problem is at a fairly low level, I don't think it's that serious and I imagine it's fairly easy to fix. I think the problem lies in two sections: *Subform*: Right now, it’s a select query, but users will be updating the database from the subform.. *Historique* Right now, this field reads the value from the subform. Two needs here: 1) have it change value when user changes record in subform, and 2) allow users to type in comments. Right now, I update the field by VB, but I doubt this is the way to go. Perhaps we need to put this field in a table all on its own, but how would we make it update when we change records? **Background: ** We receives requests from its Web form. The database allows us to keep track of requests, who is handling them, and how they are being resolved. **Administrator**: The administrator receives requests by e-mail and pastes their content into the database (frmAdmin form, Courriel field). VB populates a few fields (request type, date, language of the request, etc.), and the administrator assigns the request to an employee. **Employees** The employees use the frmCallManagement form to track clients’ requests. Employees indicate what actions they have taken to resolve the request (Action field). Each action that is taken is recorded in the Historique field. When the request is finished, we set the Action field to 99 (Terminé). ## Deliverables 1) Identify the problem. 2) Fix it. 3) Send it back. ## Platform Access 2000, Windows NT LAN. Don't know the specifics, but it's a Microsoft-all-the-way company.
Project ID: 3209913

About the project

9 proposals
Remote project
Active 20 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$127.50 USD in 7 days
0.0 (0 reviews)
2.2
2.2
9 freelancers are bidding on average $177 USD for this job
User Avatar
See private message.
$170 USD in 7 days
4.9 (355 reviews)
7.7
7.7
User Avatar
See private message.
$85 USD in 7 days
4.9 (507 reviews)
7.0
7.0
User Avatar
See private message.
$297.50 USD in 7 days
4.8 (13 reviews)
5.0
5.0
User Avatar
See private message.
$340 USD in 7 days
5.0 (7 reviews)
4.6
4.6
User Avatar
See private message.
$85 USD in 7 days
0.0 (1 review)
0.0
0.0
User Avatar
See private message.
$297.50 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$102 USD in 7 days
0.0 (1 review)
2.4
2.4
User Avatar
See private message.
$85 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Canada
0.0
0
Member since May 12, 2004

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.