Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JollyMan
Starting Member
1 Post |
 Posted - 2009-12-30 : 17:20:55
|
| We have a MS Access 2003 Application that uses linked tables to store data into sql server tables. Almost every day I have to re-index the sql server tables to repair the access's ability to store values into the fields of the tables via it's form.This error happends several times at random variables but every time a reindexing of the tables fixes the issue. I need to understand what is causing this but I can not see how reindexing is changing anything about the table or it's index.I have moved the database to different machines and recieve the same error. So I have ruled out hardware. It has to be something with the ms access application but I am at a loss to understand what.Let me know what information would be useful in diagnosing this issue. Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL 2005 DB keeps Crashing access application...