New to Access

I have created a database with forms, queries, reports, etc, and put it on a server.  Now how do I get the users to see the forms/database?  
Do they need to have Access installed on their computer?
Do I create a shortcut to the database that they just click on?


Thanks for any help.
TomBallaAsked:
Who is Participating?
 
Nick67Commented:
Do they need to have Access installed on their computer?
Yes.  Access or the free Access run-time.
Do I create a shortcut to the database that they just click on?
While that is possible, that is not recommended in the long run.
You should first 'split' your database into a front-end and back-end
Search in the Help of your version for 'split database'
The front end contains the UI elements for accessing, adding and manipulating data.

A copy of the front-end should be placed on the local hard drive of each user.
Users CAN share a front end placed on a server share.
I can drive a car with my feet.
Neither is recommended.

The back-end can remain on a server share.
If you have familiarity with the free SQL Server Express Edition (SSEE), I'd recommend using the SQL Server Migration Assistant for Access to upsize the backend to SSEE if this application will have a future as anything substantial.
All of your pain is then concentrated right NOW.  That's a recommendation only.  If that's a step too far for you at this point, don't be apprehensive.  Do it if you can; don't if you can't.

Even now, in 2015, with Access 2013, your files should adhere to 8.3 naming conventions and be no more than one folder deep in the file system for best performance.
0
 
GozrehCommented:
Yes each user needs Access installed on their computer, but you can install the runtime installation Microsoft Access 2013 Runtime

Microsoft suggest to split the database, so each user should get a copy of the front end, and only the back end should be placed on the server.
Split an Access database
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.