Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / SQL Server / ADP / December 2004

Tip: Looking for answers? Try searching our database.

Changes in SQLserver

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Laura K - 23 Dec 2004 20:24 GMT
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
Mary Chipman - 27 Dec 2004 14:19 GMT
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

>Hi,
>
[quoted text clipped - 15 lines]
>
>Laura K
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.