Forum Discussion
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 Thanks. Yes, I know that the indexes are long integer but I haven't run into this "Large Number" so I took a guess---wrongly.
Thanks much.
Larry Woods
lwoodsusa I'm glad you were able to sort it out.
The Large Number datatype was added for compatibility with SQL Server's BigInt datatype. If you have not worked with a SQL Server back end, though, it might not have been something you'd take note of.
- Right you are. I come from the underworld of open software and (disgusting, I know) "MySQL!" 😉
Thanks, again.- 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.
- 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.
