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!
-
Defaulting ODBC User ID/Password
For once the Microsoft Knowledgebase paid off! After browsing several pages and getting the gist of a couple different problem solutions, here is the solution I implemented: Dim myDB As DAO.Database Dim myTable As DAO.TableDef Set myDB = CurrentDb() Set myTable =...- demedic
- Post #2
- Forum: Microsoft: Access Forms
-
Defaulting ODBC User ID/Password
I use a form that contains a style number field. When the user enters a style number a style description field is automatically poplulated. The style description is obtained from a linked table that is actually a mainframe DB2 table. The first time a user gets a style description Access...- demedic
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
-
ODBC - call failed (error 3146)
I have a Microsoft Access 2000 database that opens recordsets using a string that references DB2 tables. The OpenRecordset is returning 3146 ODBC call failed errors at about 60 seconds. First, is this a connection timeout? Second, if so, is there a way to increase the connection timeout limit...- demedic
- Post #2
- Forum: Microsoft: Access Forms
