Access Database Help

[chibearsfan6]

We want to put our whole database on a cd. Once it starts we want the navagation form to pop up so the user can enter their information. Can anybody guide us on how we can do something like this or give us info on how to. Please and Thank you.

[June7]

Where would the data entered by user be saved? Couldn't be back to the CD. A USB flash drive is another matter.

[chibearsfan6]

How could we do this by flash drive then? So it looks professional.

[June7]

You want to automatically open Access database when disc or drive is read by computer? Never seen this. Review http://www.samlogic.net/articles/aut...lash-drive.htm

If the data is on disc or drive then it is not shared. Is this what you want? Only one person at a time entering data then pass the drive to someone else? Hope you have backup of the file somewhere.

[chibearsfan6]

If we do this will the table, queries, and forms be on the side? We just want the form screen to be present.

[June7]

Be on what 'side'? Is this a split database? This thread describes how I manage a split database http://forums.aspfree.com/microsoft-...ue-323364.html

[chibearsfan6]

We figured out what we needed to make it look more professional. We just had to go under file then go to options, then click current database and deselect what we did not need.

[chibearsfan6]

I just have 2 more questions. Is there any way a navigation form can show up without any records already in it. In our navigation form the person with id#1 keeps displaying. Also is there any way would could add an error message if someone has used an id number already?

[June7]

One way is to set the form DataEntry property to Yes.

These ID numbers are not generated by an autonumber field?

[chibearsfan6]

Thank you that worked! No the ID numbers are not generated by an autonumber field, just a number field.

[June7]

Autonumber field not an option for this ID? Generating custom unique ID means code and can be tricky in a multi-user database. Common topic, search form and Google.

Here is one https://www.accessforums.net/forms/a...rms-14756.html