Discussion Locked

Problem with SQL DB

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

1 reply

by lradon

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

This discussion is closed to new replies.