Changes in SQLserver

  • Thread starter Thread starter Laura K
  • Start date Start date
L

Laura K

Hi,

I have an access front end which is attached to a remotely hosted sql
server. My lovely database developer wandered off on an extended vacation
for an indefinite period of time without telling me. I am an ASP.net
programmer with experience in Access and database design but I have never
worked with the programming end of Access.


I had a problem in my web application with a number of tables in SQL because
the owner of the table was the user and not dbo. I changed the owner to dbo
in SQL server and fixed the WebPages. Now I have to fix the Access front
end. I have no idea where to do this. Basically I need to go from
ownername.tablename to dbo.tablename somewhere in Access. Can someone point
me in the right direction. I do not even know where the coding is located
in Access.

HELP!

Laura K
 
You will need to look at all of the form and report recordsources to
find all of the hard-coded ownername.tablename references as well as
the VBA code or macros, if any. You also may need to revise views and
stored procedure code, so there's a lot of places to look. If you open
the ADP in Access you should be able to see everything in the designer
window.

--Mary
 
Back
Top