Member Avatar for charlie69

Hi All,

I have a requirement to create n Access 2007 database & some related tables from my application at runtime.

I used to be able to do this ages ago in VB5 but having difficulties doing it in VS (VB) 2010.

Any pointers would be gratefully accepted.

Thanks

Charles

  • 2 Contributors
  • 1 Reply
  • 111 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by Oxiegen
Member Avatar for Oxiegen

You can create a SQL file (a textfile) that you then can read and exexute at runtime and direct it towards an Access 2007 database file.

Here is an example of how to create it using ADOX (Microsoft ADO Ext): http://www.vbforums.com/archive/index.php/t-251384.html

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.