Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS access linked table security

Status
Not open for further replies.
ryanshaffer

ryanshaffer

MIS
Joined
Mar 29, 2012
Messages
4
Location
US
I've been handled off a crystal report that is pointed to an access database. The only problem is that the access database has linked tables that point to MS SQL server, and when I'm trying to run the report through Business Objects it fails because it doesn't have creditials to connect to SQL. does anyone know how to pass credentials to use to connect to the SQL database?
 
Sort by date Sort by votes
I have mine set as ODBC's, then save p/w with rpt
 
Upvote 0 Downvote
I don't think you can save the password with the report. However, in MS Access, you can save the password within the linked table properties.

hth,
- Ido

view, export, burst, email, and schedule Crystal Reports.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

zigstick
  • Locked
  • Question Question
Linked OLE word doc not refreshing when run in Enterprise.
Replies
5
Views
628
zigstick
zigstick
phellis
  • Locked
  • Question Question
Granting Data Access rights to Data Connections in .NET
Replies
2
Views
352
hilfy
hilfy
TomSalvato
  • Locked
  • Question Question
Publishing A Crystal Report Using MS Access
Replies
2
Views
298
hilfy
hilfy
wiplash
  • Locked
  • Question Question
Limiting access on historical reports
Replies
2
Views
265
wiplash
wiplash
crogers111
  • Locked
  • Question Question
One table causing a crystal report to run extremely slow, but only in BOE
Replies
2
Views
274
crogers111
crogers111

Part and Inventory Search

Sponsor

Back
Top