i have a simple form that a user fills out then stores in a table in Access
no i want to have the same form on another computer so two users can fill in forms and information gets saved to the 1 table how will i go about this?
is it as easy as setting up a shortcut to the access database on the second computer? i dont think that would be the best way to do it. Im not that very good with Access Databases but all of your ideas and time is much appreciated thanks *snaps for you for helping
If I understand correctly, you have an application (no front end and back end splitting) on a server and you want mutilple users to use it. If tats the case yes your right just give them the shortcut to use the app.
Now there are many many ways how to deal with concurrent appends/updates to the table. You may have to do a little bit of research to see which approach best suits you. but if there are just two users entering data in one form then probably you won't get into much problem.