If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Access & VB Combination

Re: Access & VB Combination

Absolutely. Indeed, for a long time (I'm really dating myself here folks!),
Access was sort of the "assumed" database for VB applications.

The easiest approach is usually just to set a reference to the Microsoft DAO
Object Library - much as you would probably do with ADO if you were
connecting to SQL Server or some other non-Access data source. Keep in mind
that sticking with ADO though (which you can also use to connect with JET
(aka Access) databases will probably put you in a somewhat better position
should you later decide you want to port your code over to use SQL Server or
some other major RDBMS system.