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 Mike Lewis 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: JimStevens
- Order by date
-
Create an Alias for a Schema?
Hi Frederico, Thank you for your post. I set up the Schema and Synonym like you specified and it works in the SSMS but the application (web forms) returns the following error: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]The multi-part identifier "CustSchema.TblA.CallTypeID"...- JimStevens
- Post #6
- Forum: Microsoft SQL Server: Programming
-
Create an Alias for a Schema?
We've just moved our CRM database from Sybase to SQL Server 2008 r2. The migration went fine. My question relates to the schemas in SQL Server 2008 r2. In the Sybase, all calls for report data came in from various applications with a specific schema (lets call it "CustSchema") so that the SQL...- JimStevens
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
-
How to disable fields in Access 2000 & how to combine fields
Hermanator, The answer to both questions is Yes they can be done. Q1: in the "After Update" procedure of your persontype (Since you didn't give the field name, I'm using "persontype". this represents your student or teacher field and "idnumber" for your ID Number...- JimStevens
- Post #3
- Forum: Microsoft: Office
-
Error Using DLookup
I know this sounds elementary but, make sure that the machine on which it will not work has the associated library file. You can get the name of the file in the "References". Then check to insure that the library file is installed. I had this same problem and that was our fix.- JimStevens
- Post #3
- Forum: Microsoft: Access Other topics
