Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Requerying OBDC databases

Discussion in 'Information Technology' started by N. Farr, Jul 28, 2006.

  1. N. Farr

    N. Farr
    Expand Collapse
    Guest

    Hello all,

    I imported external data via an ODBC database with no problems. Access is
    displaying the data fine, but I am now trying to refresh the data (or rather
    requery the database) to show newly added/deleted records but nothing's
    happening.

    I was first doing a Records -> Refresh, but that didn't work, so a little
    bit of searching showed that I should requery with Shift + F9, but that's not
    working either. I personally added records to the database and I see them
    added in phpmyadmin, but Access is not getting them.

    Any ideas?

    Thanks

    PS: I posted this in the import/export data newsgroup but it hasn't had any
    posts since 2004 so I'm posting it here also =)
     
  2. Pat Hartman\(MVP\)

    Pat Hartman\(MVP\)
    Expand Collapse
    Guest

    Does your form have a filter or where clause that is preventing the new
    records from showing?

    "N. Farr" <NFarr@discussions.microsoft.com> wrote in message
    news:BEAA3462-7B10-4BD8-A3D8-4C3B83025807@microsoft.com...
    > Hello all,
    >
    > I imported external data via an ODBC database with no problems. Access is
    > displaying the data fine, but I am now trying to refresh the data (or
    > rather
    > requery the database) to show newly added/deleted records but nothing's
    > happening.
    >
    > I was first doing a Records -> Refresh, but that didn't work, so a little
    > bit of searching showed that I should requery with Shift + F9, but that's
    > not
    > working either. I personally added records to the database and I see them
    > added in phpmyadmin, but Access is not getting them.
    >
    > Any ideas?
    >
    > Thanks
    >
    > PS: I posted this in the import/export data newsgroup but it hasn't had
    > any
    > posts since 2004 so I'm posting it here also =)
    >
     
  3. N. Farr

    N. Farr
    Expand Collapse
    Guest

    No it doesn't. I added a linked table instead of a just imprting data and the
    updating is working fine. I guess that's what I should have done to start
    with, but is there anyway I can make the linked table read-only? (i.e. linked
    only way)

    Thanks.

    "Pat Hartman(MVP)" wrote:

    > Does your form have a filter or where clause that is preventing the new
    > records from showing?
    >
    > "N. Farr" <NFarr@discussions.microsoft.com> wrote in message
    > news:BEAA3462-7B10-4BD8-A3D8-4C3B83025807@microsoft.com...
    > > Hello all,
    > >
    > > I imported external data via an ODBC database with no problems. Access is
    > > displaying the data fine, but I am now trying to refresh the data (or
    > > rather
    > > requery the database) to show newly added/deleted records but nothing's
    > > happening.
    > >
    > > I was first doing a Records -> Refresh, but that didn't work, so a little
    > > bit of searching showed that I should requery with Shift + F9, but that's
    > > not
    > > working either. I personally added records to the database and I see them
    > > added in phpmyadmin, but Access is not getting them.
    > >
    > > Any ideas?
    > >
    > > Thanks
    > >
    > > PS: I posted this in the import/export data newsgroup but it hasn't had
    > > any
    > > posts since 2004 so I'm posting it here also =)
    > >

    >
    >
    >
     
  4. Pat Hartman\(MVP\)

    Pat Hartman\(MVP\)
    Expand Collapse
    Guest

    You would need to use Access security to make the table read only. Before
    you attempt anything with security, make sure you have several backups and
    have read the Security FAQ available from the knowledgebase or MSDN library.

    "N. Farr" <NFarr@discussions.microsoft.com> wrote in message
    news:6C0D3157-1F2A-4E01-905F-E56CE08660BD@microsoft.com...
    > No it doesn't. I added a linked table instead of a just imprting data and
    > the
    > updating is working fine. I guess that's what I should have done to start
    > with, but is there anyway I can make the linked table read-only? (i.e.
    > linked
    > only way)
    >
    > Thanks.
    >
    > "Pat Hartman(MVP)" wrote:
    >
    >> Does your form have a filter or where clause that is preventing the new
    >> records from showing?
    >>
    >> "N. Farr" <NFarr@discussions.microsoft.com> wrote in message
    >> news:BEAA3462-7B10-4BD8-A3D8-4C3B83025807@microsoft.com...
    >> > Hello all,
    >> >
    >> > I imported external data via an ODBC database with no problems. Access
    >> > is
    >> > displaying the data fine, but I am now trying to refresh the data (or
    >> > rather
    >> > requery the database) to show newly added/deleted records but nothing's
    >> > happening.
    >> >
    >> > I was first doing a Records -> Refresh, but that didn't work, so a
    >> > little
    >> > bit of searching showed that I should requery with Shift + F9, but
    >> > that's
    >> > not
    >> > working either. I personally added records to the database and I see
    >> > them
    >> > added in phpmyadmin, but Access is not getting them.
    >> >
    >> > Any ideas?
    >> >
    >> > Thanks
    >> >
    >> > PS: I posted this in the import/export data newsgroup but it hasn't had
    >> > any
    >> > posts since 2004 so I'm posting it here also =)
    >> >

    >>
    >>
    >>
     

Share This Page