creating an Access copy of SQL 2005 DB

Last Post 29 Apr 2009 09:06 AM by pcarlet. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
pcarlet
New Member
New Member

--
29 Apr 2009 09:06 AM
I have been having a problem doing this for a long time now.

I am trying to create a READ ONLY access copy of a database so certain users can write reports and not change anything.

I am able to create an ODBC connection and connect to it via MS Access, however is not read-only and always prompts for a user name and password.

I am not an expert in SQL Server and was hoping that someone has done this before and knows how to do this right...thanks
You are not authorized to post a reply.

Acceptable Use Policy