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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: BOSSupport
- Order by date
-
HELP! Access Upsizing to SQL Server
You may try to upsize the table without data and then use the DTS Import Data Wizard to import the data. It is very good a showing you the record number and the error. Go to the Access Table, find and fix and then import the data again until success.- BOSSupport
- Post #10
- Forum: Microsoft SQL Server: Programming
-
Access subforms linked to SQL Tables Show Inserted records as deleted
After upsizing my Access 2003 application to SQL Server I am noticing some strange behavior in sub forms. I can insert a record but as soon as I save it the record shows #deleted. If I requery the subform the record returns. The Primar Key is an autonumber being managed by the MS created Insert...- BOSSupport
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
Can't See Other Drives in SQL File Dialouges
I have just taken over an SQL server 2000 box with a C: and D: drive. The D: is to be used for Data. However I can't attach to data on the D: drive or use it for back up because the File dialouge only shows the C: drive. Can anyone point me in the right direction to get SQL Server to...- BOSSupport
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Setup and Administration
