Access runtime version

[Ian Davies]

Is the runtime version of Access for distribution, that is available with
the developer extensions a fully functional version of Access apart from the
ability to create, edit and code a database? I am particularly interested to
know if the Linked Table Manager will function, as I make use of this in one
of my applications as a way the user can reconnnect to the backend if they
should choose to move it to a different location after installation.

If it will not work can anyone point me in the direction of some code that
will duplicate the linked table manager. Someone posted such a link some
time ago but I have lost it?

Version of Access is 2003.

Thanks
Ian

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/tables/tbl0009.htm at "The Access
Web" for one approach.

To be honest, I don't know whether the Linked Table Manager works with the
runtime, but even if it does, I've never considered it to be a particularly
well designed interface.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Ian Davies" <ia***************@virgin.net> wrote in message
news:2r****************@newsfe4-win.ntli.net...

Is the runtime version of Access for distribution, that is available with
the developer extensions a fully functional version of Access apart from
the
ability to create, edit and code a database? I am particularly interested
to
know if the Linked Table Manager will function, as I make use of this in
one
of my applications as a way the user can reconnnect to the backend if they
should choose to move it to a different location after installation.

If it will not work can anyone point me in the direction of some code that
will duplicate the linked table manager. Someone posted such a link some
time ago but I have lost it?

Version of Access is 2003.

Thanks
Ian

[Ian Davies]

Thanks Douglas

That was the link I was looking for.
I have incorporated the code in my App and it works fine. However I noticed
that the DAO Object Library ref needs to be selected for the code to work. I
think this is not ticked by default. Is there a way of doing this in code to
save my users from getting an error message and having to select the missing
ref themselves?

Ian

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:rN********************@rogers.com...

Take a look at http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web" for one approach.

To be honest, I don't know whether the Linked Table Manager works with the
runtime, but even if it does, I've never considered it to be a particularly well designed interface.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Ian Davies" <ia***************@virgin.net> wrote in message
news:2r****************@newsfe4-win.ntli.net...

Is the runtime version of Access for distribution, that is available with the developer extensions a fully functional version of Access apart from
the
ability to create, edit and code a database? I am particularly interested to
know if the Linked Table Manager will function, as I make use of this in
one
of my applications as a way the user can reconnnect to the backend if they should choose to move it to a different location after installation.

If it will not work can anyone point me in the direction of some code that will duplicate the linked table manager. Someone posted such a link some
time ago but I have lost it?

Version of Access is 2003.

Thanks
Ian

[Rick Brandt]

Ian Davies wrote:

Thanks Douglas

That was the link I was looking for.
I have incorporated the code in my App and it works fine. However I
noticed that the DAO Object Library ref needs to be selected for the
code to work. I think this is not ticked by default. Is there a way
of doing this in code to save my users from getting an error message
and having to select the missing ref themselves?

The ref travels with the file. If it is "checked" on your machine it will be
there on theirs.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Ian Davies]

Thanks
Thats good to know
What is the difference between the DAO object library and the DAO
compatibility library. I am trying to establish which library would be the
best to select DAO 2.5/3.51 compatibility library, DAO 3.51 or DAO 3.6
Object library, for best compatibility with users computers (Ive had
problems with missing refs in the past and would like to eliminate this
happening again). The app works with the earlier 2.5 should I choose this as
it is the one most likely to be on most of the users computers as opposed to
the latter which may only be on machines with newer versions of Access or
those that have been regularly updated with MS downloads? or would it be
best to tick 3.6 and inform users that if there is problem they should
download latest DAO components?

Ian

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:nY****************@newssvr30.news.prodigy.com ...

Ian Davies wrote:

Thanks Douglas

That was the link I was looking for.
I have incorporated the code in my App and it works fine. However I
noticed that the DAO Object Library ref needs to be selected for the
code to work. I think this is not ticked by default. Is there a way
of doing this in code to save my users from getting an error message
and having to select the missing ref themselves?

The ref travels with the file. If it is "checked" on your machine it will

be there on theirs.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Douglas J. Steele]

What version of Access are you using?

The DAO 2.5/3.51 Compatibility Library is only intended for use in Access 97
with databases created in earlier versions of Access.

DAO 3.51 is the "proper" library for use with Access 97, DAO 3.6 is the one
for Access 2000 and newer.

Realistically, all your users should be on the same SP as you. I realize
that's sometimes difficult, but you're far more likely to run into problems
if they aren't.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Ian Davies" <ia***************@virgin.net> wrote in message
news:6l*****************@newsfe2-win.ntli.net...

Thanks
Thats good to know
What is the difference between the DAO object library and the DAO
compatibility library. I am trying to establish which library would be the
best to select DAO 2.5/3.51 compatibility library, DAO 3.51 or DAO 3.6
Object library, for best compatibility with users computers (Ive had
problems with missing refs in the past and would like to eliminate this
happening again). The app works with the earlier 2.5 should I choose this
as
it is the one most likely to be on most of the users computers as opposed
to
the latter which may only be on machines with newer versions of Access or
those that have been regularly updated with MS downloads? or would it be
best to tick 3.6 and inform users that if there is problem they should
download latest DAO components?

Ian

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:nY****************@newssvr30.news.prodigy.com ...

Ian Davies wrote:

> Thanks Douglas
>
> That was the link I was looking for.
> I have incorporated the code in my App and it works fine. However I
> noticed that the DAO Object Library ref needs to be selected for the
> code to work. I think this is not ticked by default. Is there a way
> of doing this in code to save my users from getting an error message
> and having to select the missing ref themselves?
>

The ref travels with the file. If it is "checked" on your machine it will

be

there on theirs.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Ian Davies]

What version of Access are you using?
Im using Access 2k but would like my Application to be available to users
who have any version of Access so I have also installed an old version of
Access (97) and have compiled a copy with this too.
I want to also compile a copy with Access 2k3 and distribute the 3 versions
to cover any senario.


The DAO 2.5/3.51 Compatibility Library is only intended for use in Access 97 with databases created in earlier versions of Access.
Would it be advisable to select different libraries for each app compiled
with the different versions of Access or should I just go for the 3.6?

DAO 3.51 is the "proper" library for use with Access 97, DAO 3.6 is the one for Access 2000 and newer.

Realistically, all your users should be on the same SP as you. I realize
that's sometimes difficult, but you're far more likely to run into problems if they aren't.
Could I distribute the DAO 3.6 with the application, or is this not allowed
by Microsoft?

I am thinking about getting the Developer extensions along with Access 2003
and distributing the app with the run time. Would this affect users who have
a full version of Access installed (such as 97 or 2000)?
I am new to trying to sell applications and would be interested to know what
developers usually do to try and make their apps compatible with as many
potential customers as possible.
I am actually a teacher but have developed some useful stuff that has helped
me with my administration chores. I would like to make them available to
other teachers and possible profit a bit from it.
Ian



--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Ian Davies" <ia***************@virgin.net> wrote in message
news:6l*****************@newsfe2-win.ntli.net...

Thanks
Thats good to know
What is the difference between the DAO object library and the DAO
compatibility library. I am trying to establish which library would be the best to select DAO 2.5/3.51 compatibility library, DAO 3.51 or DAO 3.6
Object library, for best compatibility with users computers (Ive had
problems with missing refs in the past and would like to eliminate this
happening again). The app works with the earlier 2.5 should I choose this as
it is the one most likely to be on most of the users computers as opposed to
the latter which may only be on machines with newer versions of Access or those that have been regularly updated with MS downloads? or would it be
best to tick 3.6 and inform users that if there is problem they should
download latest DAO components?

Ian

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:nY****************@newssvr30.news.prodigy.com ...

Ian Davies wrote:
> Thanks Douglas
>
> That was the link I was looking for.
> I have incorporated the code in my App and it works fine. However I
> noticed that the DAO Object Library ref needs to be selected for the
> code to work. I think this is not ticked by default. Is there a way
> of doing this in code to save my users from getting an error message
> and having to select the missing ref themselves?
>

The ref travels with the file. If it is "checked" on your machine it

will be

there on theirs.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Douglas J. Steele]

Access 97 should use DAO 3.5. Access 2000 and Access 2003 would both use DAO
3.6. However, recognize that the default file format for Access 2003 is
actually the Access 2000 format, so there's really no reason to have a
separate Access 2003 version.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Ian Davies" <ia***************@virgin.net> wrote in message
news:kj*****************@newsfe2-win.ntli.net...

What version of Access are you using?

Im using Access 2k but would like my Application to be available to users
who have any version of Access so I have also installed an old version of
Access (97) and have compiled a copy with this too.
I want to also compile a copy with Access 2k3 and distribute the 3
versions
to cover any senario.

The DAO 2.5/3.51 Compatibility Library is only intended for use in Access

97

with databases created in earlier versions of Access.

Would it be advisable to select different libraries for each app compiled
with the different versions of Access or should I just go for the 3.6?

DAO 3.51 is the "proper" library for use with Access 97, DAO 3.6 is the

one

for Access 2000 and newer.

Realistically, all your users should be on the same SP as you. I realize
that's sometimes difficult, but you're far more likely to run into

problems

if they aren't.

Could I distribute the DAO 3.6 with the application, or is this not
allowed
by Microsoft?

I am thinking about getting the Developer extensions along with Access
2003
and distributing the app with the run time. Would this affect users who
have
a full version of Access installed (such as 97 or 2000)?
I am new to trying to sell applications and would be interested to know
what
developers usually do to try and make their apps compatible with as many
potential customers as possible.
I am actually a teacher but have developed some useful stuff that has
helped
me with my administration chores. I would like to make them available to
other teachers and possible profit a bit from it.
Ian

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Ian Davies" <ia***************@virgin.net> wrote in message
news:6l*****************@newsfe2-win.ntli.net...

> Thanks
> Thats good to know
> What is the difference between the DAO object library and the DAO
> compatibility library. I am trying to establish which library would be the > best to select DAO 2.5/3.51 compatibility library, DAO 3.51 or DAO 3.6
> Object library, for best compatibility with users computers (Ive had
> problems with missing refs in the past and would like to eliminate this
> happening again). The app works with the earlier 2.5 should I choose this > as
> it is the one most likely to be on most of the users computers as opposed > to
> the latter which may only be on machines with newer versions of Access or > those that have been regularly updated with MS downloads? or would it
> be
> best to tick 3.6 and inform users that if there is problem they should
> download latest DAO components?
>
> Ian
>
> "Rick Brandt" <ri*********@hotmail.com> wrote in message
> news:nY****************@newssvr30.news.prodigy.com ...
>> Ian Davies wrote:
>> > Thanks Douglas
>> >
>> > That was the link I was looking for.
>> > I have incorporated the code in my App and it works fine. However I
>> > noticed that the DAO Object Library ref needs to be selected for the
>> > code to work. I think this is not ticked by default. Is there a way
>> > of doing this in code to save my users from getting an error message
>> > and having to select the missing ref themselves?
>> >
>>
>> The ref travels with the file. If it is "checked" on your machine it will > be
>> there on theirs.
>>
>> --
>> I don't check the Email account attached
>> to this message. Send instead to...
>> RBrandt at Hunter dot com
>>
>>
>
>