Excel/Access 2003 Issue

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

WT1059

Thread Starter
Joined
May 13, 2009
Messages
60
I have a tool that I inherited with the job and have to support which involves an Excel Spreadsheet over an Access Database using ADO. The Excel Spreadheet is located on the users (about 30 total users) desktop and the Access Database it located on a Network Drive. The origional setup used drive mapping but I updated it to use the UNC path and made a great gain in the speed of the data flow. The tool is used for lobby control and gathering metrics about the clients they are seeing. So a client comes in and is entered into the database by a clerk at the front desk. Then a specialist will open their Spreadsheet and click the Find Next Client button to select the client.

For the most part I don't have any problems with the tool. It runs well and I have updated it giving the users more functionality. However I do have 1 issue that I just can't seem to fix. There is 1 column where the data for an entry, once selected by a specialist will be overwritten by another specialist and that specialist will try to call back a client that is already being assisted. I have tried to prevent this from happening within the spreadsheet but nothing Ive done works. Is there any way of locking the data in this column down within Access once it is entered so that another specialist cannot select a client already selected? Very fustrating for the users.

Thanks
 

OBP

Joined
Mar 8, 2005
Messages
19,895
Have you looked at the Database Main Menu>Tools>Options>Advanced>Default Record Locking and set it to "Edited Record".
 

WT1059

Thread Starter
Joined
May 13, 2009
Messages
60
No, it was set to No locks. I changed it and will see what happens. Thanks for the reply.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top