Need to create database that is only accessed through a form.

[Gluefoot]

Hi everyone, I'm trying to create a database that a user will read and write
to from a form that I've created in VBA. But.. I don't want to have to load
either MS Access or MS Excel to load the form. Is there a way to do this in
either Excel or Access? Or am I just going to have to write it in VB? I like
the one I've created in Excel but I don't want the user to view the excel
sheet in the background all the time. If someone could point me in the right
direction I'd really appreciate it!

Thanks in advance!
Rob.

 

[Dirk Goldgar]

Hi everyone, I'm trying to create a database that a user will read and
write
to from a form that I've created in VBA. But.. I don't want to have to
load
either MS Access or MS Excel to load the form. Is there a way to do this
in
either Excel or Access? Or am I just going to have to write it in VB? I
like
the one I've created in Excel but I don't want the user to view the excel
sheet in the background all the time. If someone could point me in the
right
direction I'd really appreciate it!

You can't run an Access form without running Access. You can, however, hide
the database container window (or the Nav Pane, for Access 2007), or the
whole Access application window if you want (so that the form is the only
thing the user sees). If that's not good enough for you, you'll have to
write your application in VB or some other development environment, and make
your own connection to the database.