mdb to sql server 2005 express

[Richard]

Hi

I have beed testing mdb front-end to msde / sql server 2005 express backend.

I took away permissions for users in windows authentication to prevent
importing of tables. So I used sql authentication to link the tables. It
works in msde but when I tried the same method with sql 2005, the mdb cannot
query the tables citing no permissions. It seems that sql 2005 link will
automatically goes to windows authentication. Did I configure sql 2005
wrongly or this is the way it works.

How do I overcome this issue?

Many thanks in advance
Richard

 

[Larry Linson]

Sounds to me like an SQL Server issue, even though you are accessing it via
Access. You might well find a better answer in one of the SQL Server
networks.

Larry

 

[Br@dley]

Sounds to me like an SQL Server issue, even though you are accessing
it via Access. You might well find a better answer in one of the SQL
Server networks.

Larry

When you installed SQL server it did you set it to mixed mode or Windows
authentication only?
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response