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

[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!

 

[BJ Freeman]

I use a Nona account with Owner rights to design.That way it will have the
dbo.