Re: ADO / SQL Server ODBC / Bookmarks


"PK" <PK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:409099E5-77BF-44E2-BE0A-3DAFF2EDDD75@xxxxxxxxxxxxxxxx
> We have an Access 2003 application which works fine using linked tables to
> another Access database.
>
> The application uses ADO Bookmarks to store record positions. Everything
> works fine when the system is linked to Access.
>
> I am trying to upsize the database to SQL Server and use the SQL Server
> ODBC
> driver to link from Access to SQL.
>
> There appears to be some problem with the Bookmark functionality... for no
> obvious reason, it seems to lose its positioning at random intervals.
> Sometimes it brings up the correct record, sometimes it does not. I can
> not
> seem to find any pattern, nor any bug report.
>
> I've tried updating to the latest version of Jet as well as current MDAC
> on
> the SQL Server to no avail.
>
> Any ideas from anybody?

Bookmarks will not live through a requery, so if you have anything that's
implicitly (or explicitly) causing a requery, that is likely the problem.

Also, have you considered using an .ADP file instead of an .MDB? I believe
that .ADP files connect directly to the db server via OLEDB. That linked
table mechanism is ancient, and has weaknesses.

-Mark



.

Relevant Pages

  • Re: tool to re-reference forms after usizing?
    ... Speed Ferret (which I hate to admit that I've never been able to get to ... tblCustomerAddress, remember that changing tblCustomer to something else ... >>> I am in the process of upsizing an access database to sql server. ...
    (microsoft.public.access.conversion)
  • Re: ODBC parameters and system resources
    ... Install MSDE or use an existing SQL Server. ... I connect to an Access database of about 500MB in size. ... there is the "Not enough space on temporary disk". ... What can a "System resource" be apart from disk space and RAM? ...
    (comp.databases.ms-access)
  • Re: Migrating away from MS-Access
    ... Ive just stepped into a role to migrate an access database to VB.Net. ... At some stage we have to migrate the access backend to SQL Server. ... A dot-net front end with an MDB file back end is the worst of all worlds. ...
    (comp.databases.ms-access)
  • RE: ODBCDirect Workspace
    ... successfully ported my tables to SQL Server and have created an Access ... Are you using one Access database to work inside of another Access database? ... Set daoDbs = Nothing ... However if you are going to be using this query again to populate the combo ...
    (microsoft.public.access.modulesdaovba)
  • RE: ODBCDirect Workspace
    ... successfully ported my tables to SQL Server and have created an Access ... Are you using one Access database to work inside of another Access database? ... Dim strSql As String ... However if you are going to be using this query again to populate the combo ...
    (microsoft.public.access.modulesdaovba)