IxiRancid Posted June 23, 2004 Posted June 23, 2004 I'm having big trouble loging into an access 2003 database from my VS.NET 2003 app. Even when there is no password or even a user name, DataAdapter fails to generate anything except SELECT and asks for a password for un: Admin (why are settings like Include Password on Don't Include Password; written in plaintext format etc. even there??) :o I don't have ANY problems with Access 2002 (XP) or lower. Quote
Moderators Robby Posted June 23, 2004 Moderators Posted June 23, 2004 Did you create the Access DB as a different Owner then Admin? Quote Visit...Bassic Software
IxiRancid Posted June 24, 2004 Author Posted June 24, 2004 No, I made the database myself, this was on my workplace (where I'm part of a domain), BUT if I do it at my home (no domain, no multiusers, I'm the Admin) the doesn't work either - for the same reasons (unknown). Quote
Moderators Robby Posted June 24, 2004 Moderators Posted June 24, 2004 Open the security dialog and check who's the Owner listed Quote Visit...Bassic Software
IxiRancid Posted June 24, 2004 Author Posted June 24, 2004 Permissions: Me, admin and SYSTEM I'd say that's enough. But I've been checking some Google and quite a few people have this problem yet no anwser. The thing is - problem must be with Office being 2003 and not XP or lower (I never had any problem with those!). Quote
Moderators Robby Posted June 24, 2004 Moderators Posted June 24, 2004 No, I meant within Access, Menu item... Tools | Security | User and Group Permissions Verify the Owner name Quote Visit...Bassic Software
IxiRancid Posted June 28, 2004 Author Posted June 28, 2004 Checked it, it's set to Admin and under Groups - Users, Admins Still don't work, perhaps I should try generating an Adapter manualy? But that's not really what I had in my mind. Quote
IxiRancid Posted June 28, 2004 Author Posted June 28, 2004 Solved Dare I say that it was just a stoopid mistake, or should I say that MS did it different in 2003 than 2002 (can't imagine how Whidbey will be). Here's the deal (new conn): Choose provider (Jet OleDb 4.0) next page - path to mdb - THEN username is auto-set to "Admin", I should have deleted that... and that's it. Username: blank password: blank Well, what do ye say? :confused: Quote
IxiRancid Posted June 29, 2004 Author Posted June 29, 2004 OK... goddamit Doesn't work! Adapter is generated successfully, but if I try to ExecuteNonQuery an insert command this error pops-up: Format of the initialization string does not conform to the OLE DB specification. Out of total despaire I started using ODBC... my deadline is coming close. If anyone should ever have any idea how to fix this, please post! Thanks! Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.