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 12 1284
instead of spending lots of money redeveloping the application, why not
deploy via 'terminal server'
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.
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'
> 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.
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
"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? 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 :)
>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.
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.
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.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: John |
last post by:
Hi
We have an access app (front-end+backend) running on the company network. I
am trying to setup replication for laptop users who go into field and need
the data synched between their laptops...
|
by: Raphi |
last post by:
Hi,
I've been using an Access application I wrote for an office with the
front-end stored on all computers and the back-end on one of them serving as
an Access file server.
Now we're moving...
|
by: Nuno Fonseca |
last post by:
Anyone knows if it is possible to make a database connection over TCP/IP to
an MS ACCESS database? If yes please give me an example or any documentation
please.
Best regards,
Nuno
|
by: Cheryl Langdon |
last post by:
Hello everyone,
This is my first attempt at getting help in this manner. Please
forgive me if this is an inappropriate request.
I suddenly find myself in urgent need of instruction on how to...
|
by: Wayne Smith |
last post by:
I've come up against a major headache that I can't seem to find a solution
for but I'm sure there must be a workaround and I would really be grateful
of any help.
I'm currently building a web...
|
by: Anns via AccessMonster.com |
last post by:
My establishment has about 20 ms access db's that will be converted over (see
subject).
When we pull all the BE's over to SQL and the FE's on Sharepoint (.net)
surely we don't have to change...
|
by: Michael |
last post by:
Hello,
I am trying to develop a database solution for an organisation in
Indonesia.
This organization has a number of offices and users throughout the
country. They all need to maintain their...
|
by: raylopez99 |
last post by:
10 years ago, the below was written (see very end, after my signature
RL).
What, if anything, has changed?
I have Access 2003 and soon Access 2007 on a Windows XP Professional
or Windows...
|
by: p byers |
last post by:
Good Morning Folks
I have a LAN
Among the several connections to it are the following four devices:
A MAXSTOR network Storage Device
A PC running Microsoft Windows 2000 Server 5.0.2195 (SP4)
A...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
| |