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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query with Inner Join fails when using SQL Server BE
Well this is interseting. I went into the properties of the main query and change the recordtype from "Dynaset" default to "Dynaset (Inconsistent Updates)" and the bloody thing now works. I don't get it, but it works.- thirt
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Query with Inner Join fails when using SQL Server BE
I just upsized my current Access BE to SQL Server. I'm cleaning up the Access front end and came accross subforms not displaying data correctly. I'm looking at the underlying query and found out that the inner join is only showing matched records, and not all the records on the left as it...- thirt
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
dot1q vlans
You can either use on the router side: encapsulation dot1Q 1 native (since 12.1(3)T) or In the earlier Cisco IOS versions, it is important not to configure VLAN1 interface as a sub-interface. The router then expects a tag dot1q frame on VLAN1 and the switch is not expecting a tag on VLAN1. As... -
3Com NIC & Cisco Switch Compatibility Issues
Just Enabling "spanning-tree portfast" on all links to this NIC. Don't enable fast on Switch to Switch links !- thirt
- Post #3
- Forum: HP Networking solutions
