Deploying Data Capture Form accross network

[Guest]

Hi
I am new to Access and need some help on my first application.
I have create a simple 2 column table to capture Name and Email address. I
have created a form based on this table and can add data to the table.

I want to have a link/shortcut to this on each users desktop that will only
bring up the form and not the full Access panel. Each user will update the
central database.

Thanks in advance
Paddy

 

[gibsonsgman]

Well to start, if you want to have access open that form on startup you
are going to have to set its start up properties. Just go to
tools>startup and choose your options from there. Now if I understand
the rest of your question right, your database is on a network? What
you are going to have to do is split it into a back and front end, the
back end containing the data and the front end containing the form. To
do this, go to tools>database Utilities>database splitter. follow the
directions on the wizard that appears. Now your data will be contained
in a separate backend database. Now if you would like each user to
have their own copy of this on their computer, convert your front end
database into a MDE file. this is under tools>database utilities>make
MDE. now write a .bat file which will copy this file to the users
desktop. to do this, click the start menu, go to accessories and open
notepad. then paste this code into notepad.

@echo off
cls
copy "your path here" "C:\Documents and Settings\%Username%\desktop"
cls

the 'your path here' part is the directory of the MDE file you just
made.
after you do that save the notepad as any name you want. Ex:
install.bat The important thing to remember here though is the .bat
extension. If you forget that it won't work. Save this and everyone
who is going to use the database needs to click this file before tehy
can use the database. This will copy the mde file to thier desktop,
then they can freely access the information.

this should do exactly what you need. let me know how this works out.