Let me start off by saying that this is the first time I have ever used MSQL server. My office has a SQL database that a company built for us, and it is stored on our SQL server. My boss wanted me to export this database into an Access database. I was able to transfer the data tables without a problem. However, when I open the access database, the relationships between the tables are not present. Is there a way that I can export the relationships from the MSQL server, or do I need to establish them manually? Thanks for your help.
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!
Exporting sql db to access, how do i export relationships
- Thread starter swimtiger
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question