Access not Installed on Pc, Are user still able to use application?

[edisonl via AccessMonster.com]

Hi Everyone,

Not sure if this is the right group to pose my question about Using Access.

Understand that the normal way of using is User must have Ms Office-Access in
order to use the application.

As I had a fully operational application developed using Ms Office-Access,
but certain terminal in my company does not have Access installed.

Any suggestions, any one ? (Eg: I was suggested using Visuo software that
save as a .exe file to serve as a 'bridge' between User that do not have Ms
Access installed in their system and Access Applications that is residing in
company server)

Edison

 

[Gina Whipp]

Edison,

What version of Access is the database written in? The terminal that does
not have Access are there no plans to get Access for that terminal? Because
a database written in Access 2000 and up can be run in Access 2007.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Chris O'C via AccessMonster.com]

Any odbc compliant app can connect to the tables in the mdb file and
enter/update/delete data. They must have Access installed if they want to
open the mdb file and use the forms, reports, modules, etc.

If they don't want to buy an Access license for a pc, they can use the
runtime version of Access to open your db app, see forms and reports, and
enter/update/delete data. They just can't do any db design work.

Earlier versions of the Access runtime cost money for the distributor, but if
you have Access 2007 to do the design work, download and install the free
Access 2007 runtime.

http://www.microsoft.com/downloads/...D9-9DC6-4B38-9FA6-2C745A175AED&displaylang=en


Chris

 

[edisonl via AccessMonster.com]

Hi Gina,

Right application that resides in server was written using Access 2000.
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
~ ~ ~
Hi Chris,

Basically for non Access installed Pc requirement would be just open the form
input, update, retrievel, view queries from the form. No back end designing
is needed. However I believe one of the major constraint would be that the
application was written in ACCESS 2000, UNABLE TO USE 2007 RunTime
application though. Application was save in .mdb extension. Will there be any
'circumvent' to do it ?

Regards, Edison
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
~ ~ ~

Any odbc compliant app can connect to the tables in the mdb file and
enter/update/delete data. They must have Access installed if they want to
open the mdb file and use the forms, reports, modules, etc.

If they don't want to buy an Access license for a pc, they can use the
runtime version of Access to open your db app, see forms and reports, and
enter/update/delete data. They just can't do any db design work.

Earlier versions of the Access runtime cost money for the distributor, but if
you have Access 2007 to do the design work, download and install the free
Access 2007 runtime.

http://www.microsoft.com/downloads/...D9-9DC6-4B38-9FA6-2C745A175AED&displaylang=en

Chris

Understand that the normal way of using is User must have Ms Office-Access in
order to use the application.

[quoted text clipped - 6 lines]

Access installed in their system and Access Applications that is residing in
company server)

 

[edisonl via AccessMonster.com]

Hi Gina,

Right application that resides in server was written using Access 2000.
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
~ ~ ~
Hi Chris,

Basically for non Access installed Pc requirement would be just open the form
input, update, retrievel, view queries from the form. No back end designing
is needed. However I believe one of the major constraint would be that the
application was written in ACCESS 2000, UNABLE TO USE 2007 RunTime
application though. Application was save in .mdb extension. Will there be any
'circumvent' to do it ?

Regards, Edison
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
~ ~ ~

Any odbc compliant app can connect to the tables in the mdb file and
enter/update/delete data. They must have Access installed if they want to
open the mdb file and use the forms, reports, modules, etc.

If they don't want to buy an Access license for a pc, they can use the
runtime version of Access to open your db app, see forms and reports, and
enter/update/delete data. They just can't do any db design work.

Earlier versions of the Access runtime cost money for the distributor, but if
you have Access 2007 to do the design work, download and install the free
Access 2007 runtime.

http://www.microsoft.com/downloads/...D9-9DC6-4B38-9FA6-2C745A175AED&displaylang=en

Chris

Understand that the normal way of using is User must have Ms Office-Access in
order to use the application.

[quoted text clipped - 6 lines]

Access installed in their system and Access Applications that is residing in
company server)

 

[Gina Whipp]

Edison,

Without any version Access installed on the PC there is nothing that can be
done. Unless someone has found a work around that I am unfamilar with...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi Gina,

Right application that resides in server was written using Access 2000.
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
~ ~
~ ~ ~
Hi Chris,

Basically for non Access installed Pc requirement would be just open the
form
input, update, retrievel, view queries from the form. No back end
designing
is needed. However I believe one of the major constraint would be that the
application was written in ACCESS 2000, UNABLE TO USE 2007 RunTime
application though. Application was save in .mdb extension. Will there be
any
'circumvent' to do it ?

Regards, Edison
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
~ ~
~ ~ ~

Any odbc compliant app can connect to the tables in the mdb file and
enter/update/delete data. They must have Access installed if they want to
open the mdb file and use the forms, reports, modules, etc.

If they don't want to buy an Access license for a pc, they can use the
runtime version of Access to open your db app, see forms and reports, and
enter/update/delete data. They just can't do any db design work.

Earlier versions of the Access runtime cost money for the distributor, but
if
you have Access 2007 to do the design work, download and install the free
Access 2007 runtime.

http://www.microsoft.com/downloads/...D9-9DC6-4B38-9FA6-2C745A175AED&displaylang=en

Chris

Understand that the normal way of using is User must have Ms
Office-Access in
order to use the application.

[quoted text clipped - 6 lines]

Access installed in their system and Access Applications that is residing
in
company server)

 

[Chris O'C via AccessMonster.com]

Why?

Chris

However I believe one of the major constraint would be that the
application was written in ACCESS 2000, UNABLE TO USE 2007 RunTime
application though.

 

[edisonl via AccessMonster.com]

Hi Chris,

Is Access 2007 Runtime able to support Access 2000 Application ? From past
experiences I failed to do so. Not sure if I got the setting right though.
One of Forums MVP (If I am correct) comments on the drawbacks of 2007 runtime
unable to support access 2000 remote usage.

Regards, Edison

 

[Rick Brandt]

Hi Chris,

Is Access 2007 Runtime able to support Access 2000 Application ? From
past experiences I failed to do so. Not sure if I got the setting right
though. One of Forums MVP (If I am correct) comments on the drawbacks of
2007 runtime unable to support access 2000 remote usage.

2007 can run anything from 2000 file format on up. There might be a few
things that don't work properly unless tweaked, but as far as actually
opening the older file formats you are not in trouble until you go back
to 97.

 

[Gina Whipp]

Rick,

I thought the Runtime, not full version of Access 2007 couldn't run Access
2000? I knew full version can but apparently this particular machine has no
plans of getting Access at all.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[edisonl via AccessMonster.com]

Hi Rick,

Glad that it actually shine some light. But configuration on remote PC
(Without Access 2000 Installed) seems like required some configurations on
the OS in which I have a slight challenge.

Regards, Edison

 

[edisonl via AccessMonster.com]

Hi Rick,

Yup, agreed with Gina. Apprently Not practical to extend hardisk just to
install Office on an old system, in costs perspectives not very convincing to
involve party too.

Rick,

I thought the Runtime, not full version of Access 2007 couldn't run Access
2000? I knew full version can but apparently this particular machine has no
plans of getting Access at all.
[quoted text clipped - 7 lines]

opening the older file formats you are not in trouble until you go back
to 97.

 

[Chris O'C via AccessMonster.com]

As Rick says, Access 2007 runtime runs 2000 and up. You need a startup form
and some type of switchboard because the nav pane doesn't show for users to
select objects when they use the runtime to open the db app. You may need
some other tweaks, which you can do with the retail version of Access
(preferably 2007, but often earlier versions are ok).

I don't know anybody who would say Access 2007 doesn't support Access 2000.
It does.

Chris

 

[Chris O'C via AccessMonster.com]

There wasn't enough disk space to install Access 2007 runtime?

Chris

 

[Gina Whipp]

Cool... I just learned something. I thought the runtime would only run
2007!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[edisonl via AccessMonster.com]

Hi Chris,

Will there be any resource for Access Runtime Configuration or system
requirment articles that I can refer to ?

Regards, Edison

 

[Chris O'C via AccessMonster.com]

System Requirements:
Supported Operating Systems: Windows Vista; Windows XP Service Pack 2

Articles:

http://msdn.microsoft.com/en-us/library/cc136539.aspx

http://msdn.microsoft.com/en-us/office/bb229700.aspx

http://msdn.microsoft.com/en-us/library/bb501030.aspx

Each article has more links at the bottom if you're interested.

Chris

 

[edisonl via AccessMonster.com]

Hi Chris,

Read about it .. thank you for the infor sharing.. was wondering (as I
couldn't find it) if there is an online guide or manual for the
configurations or set up ?

Regards, Edison

 

[Chris O'C via AccessMonster.com]

Not sure I understand what problems you're having after you install it from
the Access developer extensions that you want to configure it specially for
your company's environment. Ideally the Access runtime runs whenever you
open a db file. Are you getting error messages after installing the runtime?
What are they?

Chris

 

[David W. Fenton]

I thought the Runtime, not full version of Access 2007 couldn't
run Access 2000?

I'm running an A2K-format MDB in the runtime, though it was
developed in A2K3.

A2K, A2K2 and A2K3 are all native formats for A2K7.