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!

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

Location Change

Status
Not open for further replies.

kjonnnnn

MIS
Aug 25, 2000
317
US
I have a Crystal report that is based on data stored in an Access Database. I recently upgraded to Access 2000 from 97 and I also moved the location of the Access database from my C dive to my D drive. When I try to change the location in crystal to look for the database I get all the way to the access file but before I can open that and specify which table to use it asks for a user and password under the header "Microsoft Access Open Session". The default user is "Admin". How do I skip this or set a password so that I can link the table to my crystal report?
 
Check your database properties (tools/security/password from the menu)in Access. The upgrade tends to change things (ie. data environment) as it works.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top