MS Access Databases 2003

I created a database for my work and was wondering about one issue.
forms, queries, switchboard, etc.
how can i make it a stand alone?
where you can click on the file and it opens, with out access opening. i understand that it needs access to function, but the people that will be using this are (forgive me for saying it) very technology ignorant (more then me :rolleyes: ). i want to make it as easy as possible.
i want the file to open directly to the switchboard, w/o anything to add to the confusion.

You can't. Access' .db files are designed to open only in access. You can do various write protection and locking to the database to prevent people from doing anything but what you want them to do, though.

is there a way to have it were you click on the file, and it goes directly to the switchboard?

By "switchboard", I assume you mean some sort of menu. And yes, you can use the autoexec command in Access to open a form when Access opens the file.

But keep in mind that anyone that has the developer tools installed can blow right by that by closing the form (not that it seems that would be the case).

I'm also hoping that you would have an alternative. Using Access for multiple users is a really bad idea.

Life would probably be sunnier with a gentle north-easterly breeze if you made the forms and whatever other interfacy things you have in a programming language and ADO in to your .MDB. Visual Basic is the fastest for that sort of thing bar none.

>> how can i make it a stand alone? <<

Deploying Microsoft Access Applications using the Access Runtime

Quote:

---

Life would probably be sunnier with a gentle north-easterly breeze if you made the forms and whatever other interfacy things you have in a programming language and ADO in to your .MDB. Visual Basic is the fastest for that sort of thing bar none.

---

how would i do this?
can i do this with the visual basic editor that is included with access? or would i need the stand alone vb editor with ms studio?

Quote:

---

>> how can i make it a stand alone? <<

Deploying Microsoft Access Applications using the Access Runtime

---

This is interesting, but i'm unable to find the packaging wizard on my access or the run times.

Quote:

---

By "switchboard", I assume you mean some sort of menu. And yes, you can use the autoexec command in Access to open a form when Access opens the file.

---

thanks that helped.

Quote:

---

Originally Posted by xddxogm3

how would i do this?
can i do this with the visual basic editor that is included with access? or would i need the stand alone vb editor with ms studio?

---

I'm talking about stand-alone VB, yes. I dunno what VB.NET is like with Access databases, but I know VB6 has plenty of controls (combo boxes, grids, etc.) that can be bound to a data source with the minimum of fuss. That would get you an .EXE as well as your .MDB. (Oh, and the VB runtime DLL as well if they don't have it)

As for one file that does it all, then Access runtime is probably the way to go.