Access with Sqlserver database with Access front end is on network drive

Hi Jim and Anders,
Thanks for fast reply.

-SQL server 2012 is on network (Windows 2012 Virtual machine)
-I setup with login sa/password
-Since my workstation (on same WAN) can connect, I assume port 1433 is open
-When I setup with SSMA, it does not require a password, and work on my station.  Do I need to not have SSMA create links, and just connect via file DSN?

Thanks, Larry

You need to either create the same DSN you used on your PC on all the other PCs or you need to write code to make a DSNless connection.

Pat - would that be a connection using IP address rather than the server name?
-Larry

Which ... DSN or DSNLess ?

The I.T. consultant installed SQL on the I;\ drive (data drive) instead of on the server's C:\ drive.
I:\ drive has only folder called "program files", in which is found Microsoft SQL server.
Shouldn't SQL have been installed on server's C:\ drive?

On my office server, I installed on C:\drive and I can connect to SQL server via its IP address (not via server name).
Is this the issue?

I do not know how to setup DSNless.

Hope this enlightens.

Thanks much, Larry

Yeah  sorry ... SQL Server setup is out of my league, and I'm a bit late to the SQL Server party (but I learn FAST). Our IT Dept sets up all SQL Server db. We have one for our group, with full admin rights. Currently, we have a Front End that my database loader copies from a share drive to user's local workstation, and the tables (~10) are linked (FAST) 'DSNless' on the fly - which is  just a few lines of VBA code - easily found on the internet.  It uses Windows Authentication (I think that is the correct term), which does not require any hard coded UserName or Password. Only needs the SQL Server Name, SQL Server Database Name, remote and local table (if different) Names in the Connection String ... and a couple of other parameters - which I think tells it to use Window Auth.
Approx 150-200 users connect daily with no issue.

Connections to the SQL server can come in several flavours. I don't really know how it looks when SSMS has set it up for you. You can mouseover a linked table to the the connection string, or to get it in a more copy/paste friendly format try the following code from your accesss frontent, in the Immediate Pane
? Currentdb.Tabledefs("InsertNameOfLinkedTable").Connect
This should return the connect string to your immediate Pane.

Then paste the connect string here, and we can likely proceed from there.

Experts,
Thanks to everyone.  The issue (suggested by Anders) was adding users and permissions.  When I created Db, it automatically assigned me as a user/admin and gave privileges.  So solution was to manually add the other users on Domain, and give certain privileges.

Thanks to everyone!
Blessings, Larry

Your welcome. Sometimes I have actually taken the approach of creating a SQL server login account with username and password and use that for Admin stuff, and leave my AD account as a "regular user". This also makes it easier to test, because I will break if I don't have the permissions. In essence I make sure that my AD account has the same permissions as any users who are going to use it.

Thank You Anders for useful followup advice.
Your help greatly appreciated.
God Bless, Larry