create a new database?



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.





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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question