Search results

We have a database to track errors during testing. The database has MS Access front-end and SQL server back-end. The project team is located in Europe and US. To increase access performance for the US team we want to replicate the back-end database to an US server. The main table containing...

We are using a form to update a table which is on a SQL-server. Sometime it happens that the record is not updated, but we don't see an error message (e.g. set a date to 31.12.2100) How can we capture those errors? Christof.

We moved the backend of an MS Access app from Access to SQL-Server. Now we see the following behaviour - We can create new records - We can update old records - We CANNOT update new records: We get the famous WriteConflict message with "Save Record" greyed out. Any explanation for this...

We migrated a database using autonumber fields from Access to SQL-Server. After a while we detected the IDENTIFIER type. Now we have the following problem. When adding a new record in Access, the new number is provided as soon as the first field is entered. In SQL the record behaves different...