Access Databases and the Internet

[John Ortt]

Hi There ,

I am currently managing a number of Access Databases for the company I work
for.

Recently a number of employees moved to a different site and as such can no
longer connect to our access databases.

For this reason I am considdering converting the database into a web
database but I have to confess to having no idea of how to do it.

I want to allow them to use internet explorer to connect to a specific
website and use it as they had the access database.

If it is atall possible to do it without using a dedicated program (apart
from Access 97 running on windows NT) that would be good, as our company is
notoriously tight when it comes to spending money on software and the
certification takes approx 1 year even if they did sanction it.

Assuming no software is needed, what are the different standards and
languages that are appropriate and any pointers to websites which can teach
me it would be much appreciated. Furthermore if anyone knows of any courses
in the UK which can teach somebody the techniques I would appreciate it
also.

If software is required, what do people use and or recomend?

Thanks in advance,

John

[lesperancer]

instead of spending lots of money redeveloping the application, why not
deploy via 'terminal server'

[lylefair]

A company that makes a move without planning how its database will be
accessed and is "tight" with software money either doesn't need a
database, or will be bankrupt shortly. So why sweat it? It should just
sort itself out shortly in end of the company or termination of the use
of the database.

In your situation, if I felt compelled to do something standard I would
try a Terminal Server solution.
I do not feel standard today, so probably I would rent internet MS-SQL
database space, (cheap enough, even for a tight company), transfer my
db there and write HTA applications to provide GUI for the users. I'd
have one Access 2003 ADP involved for reports.
I'm guessing the cost, minus scripting would be less than $500 USD
(annually) for the server and < $150 USD for Access 2003. The scripting
would cost whatever you wanted to pay; it would be worth the same
amount.

[John Ortt]

More info please.....
<le*********@natpro.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...

instead of spending lots of money redeveloping the application, why not
deploy via 'terminal server'

[John Ortt]

> A company that makes a move without planning how its database will be

accessed and is "tight" with software money either doesn't need a
database, or will be bankrupt shortly.
Unfortunately, neither is the case. It is a large government funded company
(without giving too much away) so we aren't about to go bancrupt in a hurry
and the database is extremely helpful when it comes to managing the orders.
They mananged for 50 years without computerised databases but lets say our
performance was less than pleasing.

I won't defend the management who won't fund development and make
organisational changes without consulting the workers, but unfortunately
I've gotta put up with it.
In your situation, if I felt compelled to do something standard I would
try a Terminal Server solution.
What's this and how do you do it......an url link to an explaination will be
fine
I do not feel standard today, so probably I would rent internet MS-SQL
database space, (cheap enough, even for a tight company), transfer my
db there
With you up to this point (and I think we may already have an appropriate
server)
and write HTA applications
HTA?
to provide GUI for the users.
I'm OK with GUI :)
I'd have one Access 2003 ADP involved for reports.
What's Access ADP? Is it different to normal Access 2003 on my PC?
I'm guessing the cost, minus scripting would be less than $500 USD
(annually) for the server and < $150 USD for Access 2003.
OK
The scripting would cost whatever you wanted to pay; it would be worth the

same amount.

I'm with you, I.E. You get what you pay for....

If I were a glutten for punishment could I do this myself? That way maybe I
could get it working reasonably quickly/cheaply and refine it over time as
my skills improve.

[John Ortt]

Ok, I've found the answer to the following question on the web:

What's Access ADP? Is it different to normal Access 2003 on my PC?

by looking here:
http://office.microsoft.com/en-us/as...731031033.aspx

[John Ortt]

I would rent internet MS-SQL database space, (cheap enough, even for a tight company), transfer my db there and write HTA applications

Ok, I have found what the above is too:

http://www.vbwm.com/articles/2002/abarfield/hta01/

[Mike MacSween]

The simplest way, as others have said is Terminal Services.

http://en.wikipedia.org/wiki/Terminal_Services

or just Google for it.

Depends a bit on connection speeds. But ADSL should be OK. Depends a bit I
suppose on what the application is like, how 'intensely' it is used.

I agree with Lyle. If your managers work like:

'Let's move our staff to a different office'.

'Oh, they can't get at the database in the old office anymore'

then they're obviously a bunch of hopeless idiots who shouldn't be running
anything.

Perhaps they need an IS strategy.

"John Ortt" <Jo******@Idontwantspamsonoreturnaddress.com> wrote in message
news:42********@glkas0286.greenlnk.net...

Hi There ,

I am currently managing a number of Access Databases for the company I
work
for.

Recently a number of employees moved to a different site and as such can
no
longer connect to our access databases.

For this reason I am considdering converting the database into a web
database but I have to confess to having no idea of how to do it.

I want to allow them to use internet explorer to connect to a specific
website and use it as they had the access database.

If it is atall possible to do it without using a dedicated program (apart
from Access 97 running on windows NT) that would be good, as our company
is
notoriously tight when it comes to spending money on software and the
certification takes approx 1 year even if they did sanction it.

Assuming no software is needed, what are the different standards and
languages that are appropriate and any pointers to websites which can
teach
me it would be much appreciated. Furthermore if anyone knows of any
courses
in the UK which can teach somebody the techniques I would appreciate it
also.

If software is required, what do people use and or recomend?

Thanks in advance,

John

[Mike MacSween]

"John Ortt" <Jo******@Idontwantspamsonoreturnaddress.com> wrote in message
news:42**********@glkas0286.greenlnk.net...

A company that makes a move without planning how its database will be
accessed and is "tight" with software money either doesn't need a
database, or will be bankrupt shortly.

Unfortunately, neither is the case. It is a large government funded
company
(without giving too much away) so we aren't about to go bancrupt in a
hurry

Oh great. Companies who are 'funded' by the government aren't allowed to go
bankrupt eh? So that's where my taxes are going is it?

[John Ortt]

Oh great. Companies who are 'funded' by the government aren't allowed to go bankrupt eh? So that's where my taxes are going is it?

Fraid so..

I won't tell you the company, but lets just say we produce low volume
military aircraft for the government (and export to a few other countries)

I am certain that if we were producing cars we would have gone out of
business years ago, there is huge resistance to change within the company
and contractual stipulations (mainly from the government) make any kind of
significant process change difficult.

Fortunately for us there is a fairly small choice in aerospace manufacturers
and if you want to retain a national capability in the sector that choice
becomes even smaller.

Having said that I can safely say that we are positively lean when compared
to other government funded institutions....such as the NHS for instance.
Based on info from friends who work for consultancy companies...

Ooops, I've probrably just given away the company.........Oh well :)

[Gord]

>I've probrably just given away the company

You didn't have to. The message header...

Organization: BAE SYSTEMS

....in your postings already did it for you.

[John Ortt]

Doh, That'll teach me to use the preview window and not view my posts
properly :)

Thanks for the heads-up anyway...

"Gord" <gd*@kingston.net> wrote in message
news:11*********************@g43g2000cwa.googlegro ups.com...

I've probrably just given away the company

You didn't have to. The message header...

Organization: BAE SYSTEMS

...in your postings already did it for you.

[Jozef]

Ya, I hate working for MI5.....they still owe me money! ;)

"John Ortt" <Jo******@Idontwantspamsonoreturnaddress.com> wrote in message
news:42********@glkas0286.greenlnk.net...

Doh, That'll teach me to use the preview window and not view my posts
properly :)

Thanks for the heads-up anyway...

"Gord" <gd*@kingston.net> wrote in message
news:11*********************@g43g2000cwa.googlegro ups.com...

>I've probrably just given away the company

You didn't have to. The message header...

Organization: BAE SYSTEMS

...in your postings already did it for you.