Re: DAP & SQL 2000

From: John Campbell (john.campbell6_at_btinternet.com)
Date: 11/07/04

  • Next message: Sylvain Lafontaine: "Re: DAP & SQL 2000" 
    Date: Sun, 7 Nov 2004 20:29:47 -0000

    ok, lets see

    I'll try and answer your questions as fully as possible (im not 100% sure
    about sql, access, so i hope i hav given you the correct info)

    > What does the column Owner tell when you take a look at the tables from
    > the Enterprise Manager and is there only one table or multiple tables with
    > the same name but different owner?

    I imported everything I had in Access to SQL (including queries etc), so
    everything I imported has the owner "quote"
    Everything else that was there before has the owner "dbo"

    > Second, what is the queries and the connection string (stripped from the
    > password) that you are using.

    my connection string is:

    Provider=SQLOLEDB.1;Persist Security Info=False;User ID=quote;Initial
    Catalog=quote;Data Source=192.168.62.45;Use Procedure for Prepare=1;Auto
    Translate=True;Packet Size=4096;Workstation ID=P4;Use Encryption for
    Data=False;Tag with column collation when possible=False

    Im assuming that the Data Source should be its web address, so it can be
    accessed via the internet??

    Im not too sure where to get the query info you require.

    > Third, did you make sure that each of your tables has a primary key
    > defined? Not having a primary key for a table is a common mistake and will
    > render your tables read-only under DAP.

    At the very beginning I had 3 tables, this has now shrunk down to 1 cos i
    could not get the relationships working properly and it works a lot easier.
    Even tho I imported 3 tables I only use 1 (which does have a primary key)

    > Fourth, what is the source and the name of your queries that is displayed
    > on the Data Outline view and, in the case of the source, has the owner be
    > specified (for example, dbo.MyQuery or user.MyQuery instead of only
    > MyQuery).

    Data Outline View shows:

    Data Model
    > quote_PC
    > quote_PC
    > ID
    >Name
                ..........and it carrys on, displaying all the columns

    Hope this helps
    John

    "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
    wrote in message news:OcsWpYQxEHA.2540@TK2MSFTNGP09.phx.gbl...
    > Usually, this can be easily solved; however, we don't have enough
    > information at the moment.
    >
    > What does the column Owner tell when you take a look at the tables from
    > the Enterprise Manager and is there only one table or multiple tables with
    > the same name but different owner?
    >
    > Second, what is the queries and the connection string (stripped from the
    > password) that you are using.
    >
    > Third, did you make sure that each of your tables has a primary key
    > defined? Not having a primary key for a table is a common mistake and will
    > render your tables read-only under DAP.
    >
    > Fourth, what is the source and the name of your queries that is displayed
    > on the Data Outline view and, in the case of the source, has the owner be
    > specified (for example, dbo.MyQuery or user.MyQuery instead of only
    > MyQuery).
    >
    > S. L.
    >
    > "John Campbell" <john.campbell6@btinternet.com> wrote in message
    > news:uHs4EQQxEHA.1988@TK2MSFTNGP12.phx.gbl...
    >> Thanks for the reply.
    >>
    >> Is this a problem thats probably not going to be solved very easily? as I
    >> am not a whizz kid with sql or access at the best of times
    >>
    >> To give you a bit more detail, I have a database called quote and within
    >> that a table called PC.
    >>
    >> I then have a user called quote with full access to the database, so I am
    >> struggling to see that this is a permission thing as I am able to see the
    >> database & move the fields onto the DAP from within Access. Its just
    >> when I try and add records from within the DAP, i find it does not allow
    >> me to do anything.
    >>
    >> Thanks
    >> John
    >>
    >> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
    >> wrote in message news:%23aWDXIQxEHA.1956@TK2MSFTNGP14.phx.gbl...
    >>> Probably a permission problem or a mix beetween the default owner dbo.
    >>> and your username as the owner. If the table dbo.PC exists, a search
    >>> for user.PC won't find it and vice-versa if the table user.PC exists but
    >>> not dbo.PC.
    >>>
    >>> The problem with the dbo. owner is recurrent with DAP for newbies.
    >>>
    >>> S. L.
    >>>
    >>> "John Campbell" <john.campbell6@btinternet.com> wrote in message
    >>> news:eEAM9xPxEHA.3908@TK2MSFTNGP12.phx.gbl...
    >>>> Hi all,
    >>>>
    >>>> Im totally stuck and seriously need some help.
    >>>> Im creating a PC quote system, involving 1 MS Access table and a .htm
    >>>> file which links to a fancy page for printing quots etc.
    >>>> I need to access this system from 2 computers in different locations so
    >>>> need a way of accessing it via the internet.
    >>>> I decided to import it into Microsoft SQL 2000 with no problems
    >>>> When i configure the DAP to use the SQL server I get the error:
    >>>>
    >>>> an error occurred trying to use the table "PC" check to see that the
    >>>> object exists
    >>>>
    >>>> After looking through the internet for a day I found NO solution to
    >>>> this. However if i created a new DAP and imported the fields from the
    >>>> SQL database i found that I could read the data but not create a new
    >>>> record or modify/delete what was already there.
    >>>>
    >>>> This is where I am completly stuck........ I can't get access to the
    >>>> SQL from my original design but can from a new but not add/modify
    >>>>
    >>>> Can someone please, please help. I've been at this for 4 days and need
    >>>> it working soon :-s
    >>>>
    >>>> Thanks for any help
    >>>>
    >>>> John
    >>>>
    >>>
    >>>
    >>
    >>
    >
    >

  • Next message: Sylvain Lafontaine: "Re: DAP & SQL 2000"

    Relevant Pages

    • Re: DAP & SQL 2000
      ... >> What does the column Owner tell when you take a look at the tables from ... what is the queries and the connection string (stripped from the ... did you make sure that each of your tables has a primary key ... >> on the Data Outline view and, in the case of the source, has the owner be ...
      (microsoft.public.access.dataaccess.pages)
    • Re: table update best practices
      ... more fields you must replace the entire segment. ... I'm guessing that having an SQL ... the Primary key would be the combined (owner, ...
      (comp.databases)
    • Re: Missing table
      ... execute the commands within Query Analyzer. ... The first piece of sql displays the table owner, type, and the name of the table. ...
      (microsoft.public.sqlserver.server)
    • RE: Is the Folowing Applicationb Possible
      ... Therfore are you saying it is possible to create a useable app ... that uses SQL properly - but based around Sharepoint 'front end' AND is easy ... Then have a drop down list so that a users could easliy pick the owner. ...
      (microsoft.public.sharepoint.windowsservices)
    • Re: Permissions and ODBC
      ... objects have the same owner. ... case of dbo-owned objects in different databases, ... See the SQL 2003 SP3 Books Online for more ... > The Ms Access program executes a stored procedure that resides in SQL ...
      (microsoft.public.sqlserver.server)