create a new database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I'm very familiar with VBA as it opplies to Excel... Access? Not so much.

I have some stuff that I'm going to need to do in Excel, but will need to
run a few things through Access along the way.

Here's my start:


Dim objAcc As Object
Set objAcc = CreateObject("Access.Application")
objAcc.Visible = 1

to get Access open and running.

From there, how do I create a new database? I know how to open an existing
database with the OpenCurrentDatabase method, but how do I create a new one?

Everything I've tried throws object errors.

Thanks.
 
Ahh... got it.

I put in OpenCurrentDatabase , and then did the F1 help thing, and found
that the answer to my novice question is the 'NewCurrentDatabase' method.

Got it. Thanks.

I had tried that Help approach before, but hadn't thought of the right way
to find. it.
 
Back
Top