Last post Feb 09, 2009 02:21 AM by Mikesdotnetting
Feb 08, 2009 06:52 AM|programmernovice|LINK
In pure MS Access query, it is possible to join tables from different MDBs either using link or specifying the underlying MDB source. Is it possible to have the same kind of feature in ASP.NET with MS Access ?
Feb 08, 2009 09:52 AM|Mikesdotnetting|LINK
You can do it using ADOX, which is a COM dll. That means you will have to add a reference to it in your project. I haven't found any VB or C# code samples, but there are some classic VB examples:
Hans, another regular contributor here will point to a free classic ASP app that you can use to manage table linking:
Database Administrator for MS Access
Feb 08, 2009 06:24 PM|programmernovice|LINK
Feb 08, 2009 06:45 PM|hans_v|LINK
Hold on... I didn't make it!!! I just point to it regularly because I think it's a great tool. I don't mind it's in classic ASP, it just works, that's the most important thing. And since it is in classic ASP, you also can see how things are working ;-)
Feb 09, 2009 02:21 AM|Mikesdotnetting|LINK
Hmmm.... A .NET port??!?
Now that could be a project!