Accessx XP / SQL 2000 / "sa" vs "non sa" user

  • Thread starter Thread starter Kyle Jedrusiak
  • Start date Start date
K

Kyle Jedrusiak

I have my app almost complete. I did all the development using the sql "sa"
account for the connection.

I set up a new sql user which has public and dbo rights.

When I change the apps connection to this new user my forms blow up.

Anywhere I reference an SP or a view Access wants it prefixed by "dbo." in
order to work.

Is there a way around this?

Kyle!
 
Back
Top