Hello all,
I created a project in Access 2007 that involves about 5 or 10 tables and a minimal amount of action queries (stored procedures) and select queries (views). I created the front end and everything was good. Then I changed roads and created a new front end using Visual C# to take advantage of cooler controls, sharper front end, lack of reliance on the Access Runtime etc. Now I'm wondering, is there a way I can build a type of file that mimics a relational-database so I can also convert the back-end to an independent file type? Basically, I chose Access over something like SQL server to begin with because I don't need a enterprise class server DB, I need a portable file type that doesn't leave a big footprint, but still supports all the relational-database features (i.e. Microsoft Project, but on a way smaller scale). Is this possible?