Forum Discussion
lwoodsusa
Jun 26, 2021Copper Contributor
Can't setup Referential Integrity
I created a DB with two tables: Property table propID autonumber primary key address short text city short text state short text Residents table ...
George_Hepworth
Silver Contributor
Access does link to a wide variety of data sources, including SQL Server, MySQL, even Oracle, as well as SharePoint lists and even csv files. In other words, it's about as close to being data agnostic as it gets. I only worked with MySQL on one project, and an open source db product called "Firebird" one time in my career. They were challenging, but ultimately, it's part of expanding one's skill set.
lwoodsusa
Jun 26, 2021Copper Contributor
One last question then I will leave you alone. I am just getting back into the MS game and wonder if the "free" version of SQL Server is still available, along with a reasonable set of tools? I would like to connect my Access app to SQL Server if possible but not prepared to pay the price of the full version.
- George_HepworthJun 26, 2021Silver Contributor
Yes, SQL Server Express Download is free. SQL Server Management Studio is, IIRC, part of the package.
If you are more comfortable with MySQL, that is also a good option.