[AccessD] OpenDatabase error with linked table

[David Emerson]

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
https://urldefense.proofpoint.com/v2/url?u=http-3A__databaseadvisors.com_mai
lman_listinfo_accessd&d=DwIFAw&c=kn4_INW_mBCDHV_xJEVJkg&r=pQuzU2JPOWFA8d1LR0
ScRkf41KAmO3vze52XDXdA5D1EN8y5q3NCFsL309SJtnkO&m=o1aojNqiPVx-RxhtgBPIHRfYh1K
oJD6MPeSGkPkH590&s=DBYTF_2w0wEzeZgmD53ZWETPvraYucXiQxLWS6cKNrI&e=
Website:
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.databaseadvisors.com
&d=DwIFAw&c=kn4_INW_mBCDHV_xJEVJkg&r=pQuzU2JPOWFA8d1LR0ScRkf41KAmO3vze52XDXd
A5D1EN8y5q3NCFsL309SJtnkO&m=o1aojNqiPVx-RxhtgBPIHRfYh1KoJD6MPeSGkPkH590&s=Hy
r6evHOvoTJSbJw-c3-0RBTn7h9wLtm8usyBuI8zSo&e= 



--
AccessD mailing list
AccessD at databaseadvisors.com
https://urldefense.proofpoint.com/v2/url?u=http-3A__databaseadvisors.com_mai
lman_listinfo_accessd&d=DwIFAw&c=kn4_INW_mBCDHV_xJEVJkg&r=pQuzU2JPOWFA8d1LR0
ScRkf41KAmO3vze52XDXdA5D1EN8y5q3NCFsL309SJtnkO&m=o1aojNqiPVx-RxhtgBPIHRfYh1K
oJD6MPeSGkPkH590&s=DBYTF_2w0wEzeZgmD53ZWETPvraYucXiQxLWS6cKNrI&e=
Website:
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.databaseadvisors.com
&d=DwIFAw&c=kn4_INW_mBCDHV_xJEVJkg&r=pQuzU2JPOWFA8d1LR0ScRkf41KAmO3vze52XDXd
A5D1EN8y5q3NCFsL309SJtnkO&m=o1aojNqiPVx-RxhtgBPIHRfYh1KoJD6MPeSGkPkH590&s=Hy
r6evHOvoTJSbJw-c3-0RBTn7h9wLtm8usyBuI8zSo&e= 


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