Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Can't Detach Database
You can check if someone is connecting to the DB.- stephh
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Copy Database
You can try backup the original and restore with a new name. Steph- stephh
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Record Not Updateable: Linked Table to SQL Server 2k
Thank you sooooo much!!!!!! It works great!!!! It actually need Both PK and Unique Index to be in the database. I was just kinda wondering how come SQL Server was able to recognize the records without PK and Unique Index when the origninal .mdb upsized to SQL Server DB. Now, I'm trying...- stephh
- Post #6
- Forum: Microsoft: Access Tables and Relationships
-
Record Not Updateable: Linked Table to SQL Server 2k
Yes, I did relink the table sucessfully in Access using Linked Table Manager after setting Primary Key. However, the data is still not updateable. One thing I'd like to mention is I take the backup of SQL Server database and restore it to a new Server. Then, relink the Access application to...- stephh
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
Record Not Updateable: Linked Table to SQL Server 2k
Hi, all, I'm read the thread on Lined MS Access table Not Updateable, which is really great!!! I have an Access .mdb file with a linked table to SQL Server 2K. When trying to update/add record in Access, it shows: the recordset is not updateable. I checked the Primary Key Constraint...- stephh
- Thread
- Replies: 5
- Forum: Microsoft: Access Tables and Relationships
