General discussion


Problem with SQL DB

I view a SQL server database through a MS Access ODBC. Agents input new customer information into the database via a bespoke application which was built along side the database, In some of the tables, records have been deleted/gone missing for no reason. Thay are not continually deleting (for example around 3 months ago I found 1130 cells in one of the tables had been cleared, that number is still the same) Does anyone know if this is likely to be a problem between tables on the database/my ODBC or the application that feeds into the database?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by lradon In reply to Problem with SQL DB

Can you please tell me how you configured your ODBC SQL connnection so that your agents can input new customer info into your SQL database. I am at a point where I can see the data through Access, but, I cannot edit or add addition records. I've spent an enormous time troubleshooting this and am hoping for some insite. Thank you, Laura

Related Discussions

Related Forums