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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
access forms for SQL database
- Thread starter john74
- Start date
Yes, quite easily.
1) Setup an ODBC connection to you SQL Database. Be sure to configure your client connection with TCP/IP - it will usually default to NetBIOS. There are a few threads here that detail the steps - otherwise let me know.
2) In Access - select File, Get External Data, Link Tables,
then select Files of Data Type = ODBC databases() and your SQL database name will appear here - Select the proper Database (configured in 1- above) and OK - there are your SSQL Tables.
Takes a little practice - but it works great,
Jack
jon@netisphere.com
1) Setup an ODBC connection to you SQL Database. Be sure to configure your client connection with TCP/IP - it will usually default to NetBIOS. There are a few threads here that detail the steps - otherwise let me know.
2) In Access - select File, Get External Data, Link Tables,
then select Files of Data Type = ODBC databases() and your SQL database name will appear here - Select the proper Database (configured in 1- above) and OK - there are your SSQL Tables.
Takes a little practice - but it works great,
Jack
jon@netisphere.com
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question