[AccessD] OpenDatabase error with linked table

[Jim Lawrence]

Great detective work and subsequent solution.

Jim

----- Original Message -----
From: "David Emerson" <newsgrps at dalyn.co.nz>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Friday, January 5, 2018 6:50:57 PM
Subject: Re: [AccessD] OpenDatabase error with linked table

Didn't seem to be trusted file problem as I was able to copy it to a local
folder with the same problems.  Ended up replacing the code with this:

    Dim lmdb_Exceptions As dao.Database
    Dim lrds_Exception_Records As dao.Recordset
    'Setup Recordset for Capacity Exception table
    Set lmdb_Exceptions = CurrentDB
    Set lrds_Exception_Records =
lmdb_Exceptions.OpenRecordset("tblCapacityException")

In summary, I reverted back to the current database and removed the ",
dbOpenTable" from the end of the OpenRecordset line.

I then deleted ant index references and changed Seek to Findfirst.  Seems to
have worked.  Didn't explain the problem but at least the client can
continue using the programme.

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand




-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
David Emerson
Sent: Saturday, 6 January 2018 12:42 p.m.
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] OpenDatabase error with linked table

Thanks for replying Lambert.  That is the same link as Gustav's.

I am testing some ideas today.

David

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Heenan, Lambert
Sent: Saturday, 6 January 2018 3:29 a.m.
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] OpenDatabase error with linked table

Does this help...

https://support.microsoft.com/en-us/help/319844/you-receive-a-activex-compon
ent-can-t-create-object-error-message-when

Lambert

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
David Emerson
Sent: Thursday, January 04, 2018 2:08 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] OpenDatabase error with linked table

Further information,  Prior to this the database had the tables in the same
file.  The line read:

    Set lmdb_Exceptions = CurrentDB

Everything worked fine.  Noqw with the tables in a separate database I am
getting the error.  I am thinking perhaps a trusted location problem?

David

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Gustav Brock
Sent: Thursday, 4 January 2018 10:04 p.m.
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] OpenDatabase error with linked table

Hi David

If I bing that, a whole page of options are listed, for example:

https://urldefense.proofpoint.com/v2/url?u=https-3A__support.microsoft.com_e
n-2Dus_help_319844_you-2Dreceive-2Da-2Dactivex-2Dcompon&d=DwIFAw&c=kn4_INW_m
BCDHV_xJEVJkg&r=pQuzU2JPOWFA8d1LR0ScRkf41KAmO3vze52XDXdA5D1EN8y5q3NCFsL309SJ
tnkO&m=o1aojNqiPVx-RxhtgBPIHRfYh1KoJD6MPeSGkPkH590&s=D8h9OGYkpy3YijGad5CNb-D
_HdlcI--Uq1kO95KrOqs&e=
ent-can-t-create-object-error-message-when

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af David
Emerson
Sendt: 4. januar 2018 09:42
Til: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Emne: Re: [AccessD] OpenDatabase error with linked table

429 - "ActiveX Component can't create object.".
It stops on the line indicated below.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Gustav Brock
Sent: Thursday, 4 January 2018 8:24 p.m.
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] OpenDatabase error with linked table

Hi David

It should work. What is the error?

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af David
Emerson
Sendt: 4. januar 2018 05:50
Til: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Emne: [AccessD] OpenDatabase error with linked table

I have the following lines in code:

    Dim lmdb_Exceptions As dao.Database

    Dim lrds_Exception_Records As dao.Recordset

    'Setup Recordset for Capacity Exception table

    Set lmdb_Exceptions =
OpenDatabase(Mid(DBEngine(0)(0).TableDefs("tblCapacityException").Connect,11
))  <-- Error here

    Set lrds_Exception_Records =
lmdb_Exceptions.OpenRecordset("tblCapacityException", dbOpenTable)

    lrds_Exception_Records.Index = "CapacityExceptionDate" 'Set Index for
dynaset

In the OpenDatabase line I get an error that "ActiveX Component can't create
object."

tblCapacityException is a linked table.
DBEngine(0)(0).TableDefs("tblCapacityException").Connect =
";DATABASE=\\PDS-SRV\ProdSched\Prod
Schedhttps://urldefense.proofpoint.com/v2/url?u=http-3A__Data.md&d=DwIFAw&c=
kn4_INW_mBCDHV_xJEVJkg&r=pQuzU2JPOWFA8d1LR0ScRkf41KAmO3vze52XDXdA5D1EN8y5q3N
CFsL309SJtnkO&m=o1aojNqiPVx-RxhtgBPIHRfYh1KoJD6MPeSGkPkH590&s=0e68P5gEkqObEg
HcaPLuyINMcGXyFDBWFvOeeRsX1Hw&e= b"

I have read that I need to connect directly with the table database to use
the Index property.

This is a legacy program.  Any suggested improvements on how to achieve this
would be appreciated.

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand 



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com