[dba-VB] Create a Module and Write to It

Good point. My old code was for MDB tables but I hardly ever use them any
more anyway. But nevertheless, the question remains: how does one create an
Access module and write to it programmatically?

On Sun, Mar 11, 2012 at 2:14 PM, Dan Waters <df.waters at comcast.net> wrote:

> Hi Arthur,
>
> If you are using SQL Server tables it's likely that you can skip all this
> entirely by using Linq-to-SQL.  With this method you can drag a table to
> the
> Linq-to-SQL screen to create the class.  Then in code you do things like
> Submit() to have LINQ-to-SQL update the data in the database.  It's a
> change, but it's a good one.
>
> Just do a search and you'll find a lot of explanation.
>
> Dan
>
>