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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.