Hi, Please help me.
I recently installed a very simple data entry application using a Access 97 front end and SQL server 2000. Basically it is a small call center and calls are logged in a single table. Unfortunately there seems to be upto 10% less calls logged on our systems as are directed to them by the call center switch system. They say all calls are filled in by the agent and no error messages are reported. Is there anyway that this could happen before I get all the agents - about 10 too log all their entries on paper to test this?
I had to upsize this from an access 97 backend. I have an identity id field as the primary key. Should I have a timestamp (I heard this somewhere).
I am pretty new to SQL server. So thanks in advance.
Will
I recently installed a very simple data entry application using a Access 97 front end and SQL server 2000. Basically it is a small call center and calls are logged in a single table. Unfortunately there seems to be upto 10% less calls logged on our systems as are directed to them by the call center switch system. They say all calls are filled in by the agent and no error messages are reported. Is there anyway that this could happen before I get all the agents - about 10 too log all their entries on paper to test this?
I had to upsize this from an access 97 backend. I have an identity id field as the primary key. Should I have a timestamp (I heard this somewhere).
I am pretty new to SQL server. So thanks in advance.
Will
