Access.Application

[UniDevSA]

hi all,

my issue is this; from what i understand, if i add a reference to 'microsoft office 12.0 object library", then in my VBA i should be able to create a class like this:

dim oAcc as Access.Application
 

now, i have done this in my VBA project and to no avail. using:

dim oAcc as Object
 
set oAcc = CreateObject("Access.Application")
 

seems to work quite well; but i have problems with opening the database.

can some please explain to me how to get things so the first option to work as i am fairly new to VBA and having access to all the procs/functions of a class would be very useful.

thanks in advance...

[UniDevSA]

hi again all;

ok, i should have used the "Microsoft Access 12.0 Object Lib..." etc...

worked it out... :)

cheers and thanks

[NeoPa]

No worries and thanks for posting back.

Application Automation may provide some extra assistance for you.

Welcome to TheScripts :)