How to create tables in MS Access through VB 6

Dev Shed Forums Sponsor:

Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!

July 21st, 2003, 04:15 AM

lisa25

Registered User

Join Date: Jul 2003

Location: India

Posts: 14

Time spent in forums: 1 h 53 m 48 sec
Reputation Power: 0

How to create tables in MS Access through VB 6

I want to create tables in MS Access dynamically through VB 6 codes. Can anyone of you help me do this?

Thanks in advance
Lisa

July 21st, 2003, 04:52 AM

epl

Contributing User

Join Date: Mar 2001

Location: Dublin

Posts: 413

Time spent in forums: 2 h 18 m 18 sec
Reputation Power: 8

either run create table queries or else TableDefs.Add

if you're new to this then try it out from within an access module to see how it works, then you can add a reference to DAO in vb and copy in your code.

July 21st, 2003, 11:46 AM

Tewl

Contributing User

Join Date: Oct 2002

Posts: 47

Time spent in forums: 1 h 57 m 13 sec
Reputation Power: 6

You can also use the ado extensions to create databases an tables

__________________
Tewl

Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > How to create tables in MS Access through VB 6

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump

Get Flash