Hi folks,
I built a access 2000 database years ago as a front end to sql server 7.0 and it has been working well for quite some time. Last week, I upgraded sql server 7.0 to sql server 2000 and had no problems for the first few days. Now all of a sudden, whenever an individual uses the database to enter a new record, the database accepts and saves the record without problem but if the user then enters another record, as soon as the user attempts to save that record all fields in the forms say #DELETED on them and the user must exit out of the access application and re-open the application to find that the record did indeed save. Please help ... I have troubleshot this application so many different ways already and am getting nowhere on trying to figure out what the problem is. Any ideas would be greatly appreciated!
Thank you very much,
Joe
I built a access 2000 database years ago as a front end to sql server 7.0 and it has been working well for quite some time. Last week, I upgraded sql server 7.0 to sql server 2000 and had no problems for the first few days. Now all of a sudden, whenever an individual uses the database to enter a new record, the database accepts and saves the record without problem but if the user then enters another record, as soon as the user attempts to save that record all fields in the forms say #DELETED on them and the user must exit out of the access application and re-open the application to find that the record did indeed save. Please help ... I have troubleshot this application so many different ways already and am getting nowhere on trying to figure out what the problem is. Any ideas would be greatly appreciated!
Thank you very much,
Joe
