Access front end to SQL server

[NickyJay]

Hi,

New to SQL Server authentication issues and am trying to create an Access front end to a sql server db.

I have domain admin rights and created the access front end using SQL windows authentication. This works fine for me. However, when a colleague (not domain admin) tries the app errors asking for a SQL login/pwd every time an attempt is made to navigate/access forms etc.

Does anyone know where it's going wrong?

(ps: the database is only a contacts-type database so does not require major security)

Thanks.

 

[SQLBI]

Does the other user have a valid SQL login mapped to their Windows login?


Cheers,
Leigh

"If you had one shot, one opportunity, to seize everything you ever wanted, in one moment, would you capture it, or let it slip?" - Eminem

 

[Crowley16]

what is the front end? .mdb with linked tables or .adp?

when you link tables, you have to specify the login type against every table individually, and they sometimes get "lost" so you have to re-link or refresh the links...

--------------------
Procrastinate Now!

 

[NickyJay]

No, that's probably the problem ;0) I don't have a SQL user account mapped to my windows login though either, but don't know whether this is working because I have domain admin rights?

How do you map a user account to a windows account?

 

[NickyJay]

The front end is adp.

 

[NickyJay]

sorry - tried two ways. Tried adp but couldn't make a macro this way as the option wasn't available. So then exported the forms into an mdb and linked the tables to the db and changed each object's property to the revised connection. (Thought that an ade made from an adp would be more secure - ie. not allow access to the tables/database schema etc. etc. as that is what researching MS sites intimated at?)

The data pulls through it's just that access asks for authentication all the time!

 

[Crowley16]

Tried adp but couldn't make a macro

well, that's your problem right there, don't ever use macros...

--------------------
Procrastinate Now!

 

[NickyJay]

I thought (wrongly) that adp would allow you to use the access dev shortcuts (macros etc.) but doesn't so decided to try mdb and linking the front end to the server - then the authentication issues ;0(

Would like to be clever enough NOT to use macros but there's not enough research out there to give proper syntax to coding!!! ;0(

Even if there was a macro in the mdb one, this shouldn't ask for authentication every time?