External Access Form

Question

I'd like to create a database where the data collection interface is a form not connected with Access.  I'm not sure if this is posible or is an available feature.  What I'm looking for is a form for users to fill out which will submit to a database but I don't want to give them access to the database.  I know I can create a form in Access then make that form the form which opens when the database is opened and hide the ribbon and nav bars, etc.  But I'm wondering if there's a way of making sort of a stand-alone Access Form or something like a Word Form with a "Submit" button or something like that.  What's the best way of doing something like this? 

Thanks,

Dax

Answer 1

Why not just make a separate front end with your form? Set Data Entry to Yes and make the form open with the app and have the app close when the form closes. Only link the table(s) needed for the form and hide the Nav Pane. Also make it an ACCDE. The users open the app, do their entry and close it.

Answer 2

Well, you cannot create an Access form outside of Access so that takes of the Data Collection within Access.  So, the only thing that comes to mind is doing something on the Outlook side... not my area but from this...

http://answers.microsoft.com/en-us/office/forum/office_2010-outlook/how-do-i-get-a-form-created-in-outlook-to-feed-to/f7b0f365-def7-4fbf-a53f-6fb357cf7a19?msgId=a4d44413-0721-40c3-be8c-5a00da388177

...doesn't sound easy.  Perhaps ypu can post in the Outlook section and see what you can find.  No matter what this is not a quick or easy way to do this.