Link to data on CD

[MacDermott]

I need to programmaticall y create a link to a table in an MDB on a CD, so I
can read data from it.
Access objects that it can't create an LDB file in the same directory as the
MDB.
Is there any way I can write the linked table's Connect property (I'm using
DAO) to force exclusive access for this MDB? (That way no LDB would be
necessary.)

Or is there another solution possible?
- Turtle

[Tom van Stiphout]

Re: Link to data on CD

On Fri, 28 May 2004 00:03:57 GMT, "MacDermott " <macdermott@nos pam.com>
wrote:

Not sure if this would work, but try the /readonly command line
argument for msaccess.exe

-Tom.

[color=blue]
>I need to programmaticall y create a link to a table in an MDB on a CD, so I
>can read data from it.
>Access objects that it can't create an LDB file in the same directory as the
>MDB.
>Is there any way I can write the linked table's Connect property (I'm using
>DAO) to force exclusive access for this MDB? (That way no LDB would be
>necessary.)
>
>Or is there another solution possible?
> - Turtle
>[/color]

[Dimitri Furman]

Re: Link to data on CD

On May 28 2004, 05:30 am, Chuck Grimsby
<c.grimsby@worl dnet.att.net.in valid> wrote in
news:4c0eb0t9jr lqlhm25dcnipdi0 59rf7r5f9@4ax.c om:
[color=blue]
> On Fri, 28 May 2004 00:03:57 GMT, "MacDermott " <macdermott@nos pam.com>
> wrote:[color=green]
>>I need to programmaticall y create a link to a table in an MDB on a CD,
>>so I can read data from it.
>>Access objects that it can't create an LDB file in the same directory
>>as the MDB.
>>Is there any way I can write the linked table's Connect property (I'm
>>using DAO) to force exclusive access for this MDB? (That way no LDB
>>would be necessary.) Or is there another solution possible?[/color]
>
> In Message-ID 3B5EE7FC.2015BD 5C@uibk.ac.at, Helmut Kalb discovered
> that the secret is to use the undocumented /EMBEDDING switch.
>[/color]

But this only helps to prevent the "read-only" message when opening the
database from CD. The OP is trying to link to a database on CD, not open it
in the Access UI. When opening the linked table, Access attempts to create
the ldb file for the database on CD, which fails.

--
remove a 9 to reply by email

[MacDermott]

Re: Link to data on CD

Great idea, Tom,
but how do I use that when I'm trying to create a link programmaticall y?

"Tom van Stiphout" <tom7744@no.spa m.cox.net> wrote in message
news:qmedb0lnm1 2kkm2pm4fidvmoh kk75m4ukf@4ax.c om...[color=blue]
> On Fri, 28 May 2004 00:03:57 GMT, "MacDermott " <macdermott@nos pam.com>
> wrote:
>
> Not sure if this would work, but try the /readonly command line
> argument for msaccess.exe
>
> -Tom.
>
>[color=green]
> >I need to programmaticall y create a link to a table in an MDB on a CD, so[/color][/color]
I[color=blue][color=green]
> >can read data from it.
> >Access objects that it can't create an LDB file in the same directory as[/color][/color]
the[color=blue][color=green]
> >MDB.
> >Is there any way I can write the linked table's Connect property (I'm[/color][/color]
using[color=blue][color=green]
> >DAO) to force exclusive access for this MDB? (That way no LDB would be
> >necessary.)
> >
> >Or is there another solution possible?
> > - Turtle
> >[/color]
>[/color]

[MacDermott]

Re: Link to data on CD

Thanks, Dimitri!

That's my problem exactly.

Ideas, anyone?

- Turtle

"Dimitri Furman" <dfurman@cloud9 9.net> wrote in message
news:Xns94F7549 C6FDE2dfurmancl oud99@127.0.0.1 ...[color=blue]
> On May 28 2004, 05:30 am, Chuck Grimsby
> <c.grimsby@worl dnet.att.net.in valid> wrote in
> news:4c0eb0t9jr lqlhm25dcnipdi0 59rf7r5f9@4ax.c om:
>[color=green]
> > On Fri, 28 May 2004 00:03:57 GMT, "MacDermott " <macdermott@nos pam.com>
> > wrote:[color=darkred]
> >>I need to programmaticall y create a link to a table in an MDB on a CD,
> >>so I can read data from it.
> >>Access objects that it can't create an LDB file in the same directory
> >>as the MDB.
> >>Is there any way I can write the linked table's Connect property (I'm
> >>using DAO) to force exclusive access for this MDB? (That way no LDB
> >>would be necessary.) Or is there another solution possible?[/color]
> >
> > In Message-ID 3B5EE7FC.2015BD 5C@uibk.ac.at, Helmut Kalb discovered
> > that the secret is to use the undocumented /EMBEDDING switch.
> >[/color]
>
> But this only helps to prevent the "read-only" message when opening the
> database from CD. The OP is trying to link to a database on CD, not open[/color]
it[color=blue]
> in the Access UI. When opening the linked table, Access attempts to create
> the ldb file for the database on CD, which fails.
>
> --
> remove a 9 to reply by email[/color]

[Dimitri Furman]

Re: Link to data on CD

Take a look at

http://support.microsoft.com/default.aspx?scid=kb;en-us;208431

If that doesn't work, here's something else you can try: Before creating a
link, use SetOption to programmaticall y change the default database open
mode from shared to exclusive. Most likely, it applies only to databases
opened in Access UI, but it's worth a try.

On May 28 2004, 09:39 pm, "MacDermott " <macdermott@NoS pam.com> wrote in
news:lRRtc.1416 6$Tn6.11005@new sread1.news.pas .earthlink.net:
[color=blue]
> Thanks, Dimitri!
>
> That's my problem exactly.
>
> Ideas, anyone?
>
> - Turtle
>
> "Dimitri Furman" <dfurman@cloud9 9.net> wrote in message
> news:Xns94F7549 C6FDE2dfurmancl oud99@127.0.0.1 ...[color=green]
>> On May 28 2004, 05:30 am, Chuck Grimsby
>> <c.grimsby@worl dnet.att.net.in valid> wrote in
>> news:4c0eb0t9jr lqlhm25dcnipdi0 59rf7r5f9@4ax.c om:
>>[color=darkred]
>> > On Fri, 28 May 2004 00:03:57 GMT, "MacDermott " <macdermott@nos pam.com>
>> > wrote:
>> >>I need to programmaticall y create a link to a table in an MDB on a CD,
>> >>so I can read data from it. Access objects that it can't create an LDB
>> >>file in the same directory as the MDB.
>> >>Is there any way I can write the linked table's Connect property (I'm
>> >>using DAO) to force exclusive access for this MDB? (That way no LDB
>> >>would be necessary.) Or is there another solution possible?
>> >
>> > In Message-ID 3B5EE7FC.2015BD 5C@uibk.ac.at, Helmut Kalb discovered
>> > that the secret is to use the undocumented /EMBEDDING switch.
>> >[/color]
>>
>> But this only helps to prevent the "read-only" message when opening the
>> database from CD. The OP is trying to link to a database on CD, not open
>> it in the Access UI. When opening the linked table, Access attempts to
>> create the ldb file for the database on CD, which fails.[/color][/color]

--
remove a 9 to reply by email

[Michael Hopwood]

Re: Link to data on CD

Can't you copy the DB from the CD onto the local drive?

--
Michael Hopwood


"MacDermott " <macdermott@nos pam.com> wrote in message
news:Nlvtc.2081 $Yd3.1291@newsr ead3.news.atl.e arthlink.net...[color=blue]
> I need to programmaticall y create a link to a table in an MDB on a CD, so[/color]
I[color=blue]
> can read data from it.
> Access objects that it can't create an LDB file in the same directory as[/color]
the[color=blue]
> MDB.
> Is there any way I can write the linked table's Connect property (I'm[/color]
using[color=blue]
> DAO) to force exclusive access for this MDB? (That way no LDB would be
> necessary.)
>
> Or is there another solution possible?
> - Turtle
>
>[/color]

[MacDermott]

Re: Link to data on CD

Many thanks to all who replied here.

To the last question -
yes, if it were just me, I could copy from a CD to a local file.
But I'm writing this application for some folks who are not especially
technically inclined, and they will be receiving the source data on a CD,
so I'm trying to make it as easy as possible for them.

My face is a bit red now, because I'm pretty sure I've tracked the problem
down.
This being personal information, I had secured it pretty tightly with a
workgroup file.
In my zeal, I had removed permission for anybody but the "Administra tor"
group to open the file exclusively.
Hope nobody else has this problem, but if you do -
check your permissions!

- Turtle

"MacDermott " <macdermott@nos pam.com> wrote in message
news:Nlvtc.2081 $Yd3.1291@newsr ead3.news.atl.e arthlink.net...[color=blue]
> I need to programmaticall y create a link to a table in an MDB on a CD, so[/color]
I[color=blue]
> can read data from it.
> Access objects that it can't create an LDB file in the same directory as[/color]
the[color=blue]
> MDB.
> Is there any way I can write the linked table's Connect property (I'm[/color]
using[color=blue]
> DAO) to force exclusive access for this MDB? (That way no LDB would be
> necessary.)
>
> Or is there another solution possible?
> - Turtle
>
>[/color]