By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,790 Members | 1,407 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,790 IT Pros & Developers. It's quick & easy.

Putting my Access 97 database on the web

P: n/a
I have a large Access 97 database that's been split into a front and
back end. We've used it successfully with several computers networked
together, but now some of the people in my organization are saying that
since some of the people who need to get at it are all over the state,
it would be nice to put it up on the web and have a web interface for
it. Is there any way to do this without rewriting the entire front end
in some other language? Much of what the database does is written into
the VBA code.

Thank you for any insight you can give me,
Rebecca

Nov 12 '05 #1
Share this Question
Share on Google+
17 Replies


P: n/a
As far as I know, no.
I am going the path of implementing a limited FE functionality in ASP. I
will leave full VBA FE functionality for those who choose to work in the
main office :-)
Pavel

Rebecca wrote:

I have a large Access 97 database that's been split into a front and
back end. We've used it successfully with several computers networked
together, but now some of the people in my organization are saying that
since some of the people who need to get at it are all over the state,
it would be nice to put it up on the web and have a web interface for
it. Is there any way to do this without rewriting the entire front end
in some other language? Much of what the database does is written into
the VBA code.

Thank you for any insight you can give me,
Rebecca

Nov 12 '05 #2

P: n/a
Thanks for replying. I thought that maybe that was the case. It's true
that only one person (for now, anyway) really needs the majority of the
functionality of the db. All the others will only be working with the
one table and a few other small tables that relate to it and not much else.

How is ASP to work with? What's the easiest way to learn it? Do you
have a recommendation for a book or site?

Thanks,
Rebecca

Pavel Romashkin wrote:
As far as I know, no.
I am going the path of implementing a limited FE functionality in ASP. I
will leave full VBA FE functionality for those who choose to work in the
main office :-)
Pavel

Rebecca wrote:
I have a large Access 97 database that's been split into a front and
back end. We've used it successfully with several computers networked
together, but now some of the people in my organization are saying that
since some of the people who need to get at it are all over the state,
it would be nice to put it up on the web and have a web interface for
it. Is there any way to do this without rewriting the entire front end
in some other language? Much of what the database does is written into
the VBA code.

Thank you for any insight you can give me,
Rebecca


Nov 12 '05 #3

P: n/a
You could put the application on a Terminal server or PCAnyware computer,
then allow your remote user to connect though a VPN.

"Rebecca" <Re*****@JaxonFamily.net> wrote in message
news:uIBgb.696064$YN5.568014@sccrnsc01...
I have a large Access 97 database that's been split into a front and
back end. We've used it successfully with several computers networked
together, but now some of the people in my organization are saying that
since some of the people who need to get at it are all over the state,
it would be nice to put it up on the web and have a web interface for
it. Is there any way to do this without rewriting the entire front end
in some other language? Much of what the database does is written into
the VBA code.

Thank you for any insight you can give me,
Rebecca

Nov 12 '05 #4

P: n/a
Among others, three easy possibilities;
- Learn Frontpage
- Use www.genericdb.com
- If it is limited to few people, the use of Windows Terminal Service (the
easiest, IMO).

"Rebecca" <Re*****@JaxonFamily.net> wrote in message
news:uIBgb.696064$YN5.568014@sccrnsc01...
I have a large Access 97 database that's been split into a front and
back end. We've used it successfully with several computers networked
together, but now some of the people in my organization are saying that
since some of the people who need to get at it are all over the state,
it would be nice to put it up on the web and have a web interface for
it. Is there any way to do this without rewriting the entire front end
in some other language? Much of what the database does is written into
the VBA code.

Thank you for any insight you can give me,
Rebecca

Nov 12 '05 #5

P: n/a
That's interesting. Would it then behave just like it would on a local
network? Is it secure? Expensive? This is a not-for-profit
organization without a lot of excess in their budget.

Rebecca

paii wrote:
You could put the application on a Terminal server or PCAnyware computer,
then allow your remote user to connect though a VPN.

"Rebecca" <Re*****@JaxonFamily.net> wrote in message
news:uIBgb.696064$YN5.568014@sccrnsc01...
I have a large Access 97 database that's been split into a front and
back end. We've used it successfully with several computers networked
together, but now some of the people in my organization are saying that
since some of the people who need to get at it are all over the state,
it would be nice to put it up on the web and have a web interface for
it. Is there any way to do this without rewriting the entire front end
in some other language? Much of what the database does is written into
the VBA code.

Thank you for any insight you can give me,
Rebecca



Nov 12 '05 #6

P: n/a
Well, there is certainly a cost. However, that cost is often much less then
re-writing the part and the cost of setting up a web server.

If you are running windows 2000 server edition, you can enable remote
access, and anyone anywhere on the internet can use the application. You are
allowed two free remote users at the SAME TIME. If you need MORE THEN two
remote users at the same time, then you have to start shelling out some
money.

I would also of course for reasons of security use a VPN. Regardless,
setting up your own web server, or terminal server does requite someone with
experience in these areas (TS is way easier to setup then a web server
anyway. And, you don't have to change, or re-write your application).

For some reading on this issue, you can read the following of mine:

Using a wan with ms-access? How fast, how far?
http://www.attcanada.net/~kallal.msn/Wan/Wans.html

--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
ka****@msn.com
http://www.attcanada.net/~kallal.msn
Nov 12 '05 #7

P: n/a
Nice simple article, Albert! The sensitivity of file share mode to
dropouts on the netowork is exactly why I feel that the VPN is not a
good idea and if one wants multi-user, wide area access, they should use
a client-server approach.
I would like to add that to deploy a small database it is not necessary
to set up a web server. There are tons of commercial providers out there
with IIS deployed who will sell you web hosting with SQL server / Access
DB (OLEDB, ODBC) support for $10-100 a month, depending on the space and
reliability requirements.

Cheers,
Pavel

"Albert D. Kallal" wrote:

Well, there is certainly a cost. However, that cost is often much less then
re-writing the part and the cost of setting up a web server.

If you are running windows 2000 server edition, you can enable remote
access, and anyone anywhere on the internet can use the application. You are
allowed two free remote users at the SAME TIME. If you need MORE THEN two
remote users at the same time, then you have to start shelling out some
money.

I would also of course for reasons of security use a VPN. Regardless,
setting up your own web server, or terminal server does requite someone with
experience in these areas (TS is way easier to setup then a web server
anyway. And, you don't have to change, or re-write your application).

For some reading on this issue, you can read the following of mine:

Using a wan with ms-access? How fast, how far?
http://www.attcanada.net/~kallal.msn/Wan/Wans.html

--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
ka****@msn.com
http://www.attcanada.net/~kallal.msn

Nov 12 '05 #8

P: n/a
The application is running on the local network when using Terminal server.
Terminal server CALs cost $60 per user, if you already have Windows 2000
server.

"Rebecca" <Re*****@JaxonFamily.net> wrote in message
news:T4Fgb.697149$YN5.568509@sccrnsc01...
That's interesting. Would it then behave just like it would on a local
network? Is it secure? Expensive? This is a not-for-profit
organization without a lot of excess in their budget.

Rebecca

paii wrote:
You could put the application on a Terminal server or PCAnyware computer, then allow your remote user to connect though a VPN.

"Rebecca" <Re*****@JaxonFamily.net> wrote in message
news:uIBgb.696064$YN5.568014@sccrnsc01...
I have a large Access 97 database that's been split into a front and
back end. We've used it successfully with several computers networked
together, but now some of the people in my organization are saying that
since some of the people who need to get at it are all over the state,
it would be nice to put it up on the web and have a web interface for
it. Is there any way to do this without rewriting the entire front end
in some other language? Much of what the database does is written into
the VBA code.

Thank you for any insight you can give me,
Rebecca


Nov 12 '05 #9

P: n/a
Is it reliable? I went to the site that Albert Kallal suggested (above)
where he discusses it, and he suggests that since the VPN is subject to
occasional disconnects, the database can be corrupted. What do you
think about that? Of course, I don't want that to happen, but a VPN
does seem like the perfect solution otherwise.

Rebecca

paii wrote:
The application is running on the local network when using Terminal server.
Terminal server CALs cost $60 per user, if you already have Windows 2000
server.

"Rebecca" <Re*****@JaxonFamily.net> wrote in message
news:T4Fgb.697149$YN5.568509@sccrnsc01...
That's interesting. Would it then behave just like it would on a local
network? Is it secure? Expensive? This is a not-for-profit
organization without a lot of excess in their budget.

Rebecca

paii wrote:
You could put the application on a Terminal server or PCAnyware
computer,
then allow your remote user to connect though a VPN.

"Rebecca" <Re*****@JaxonFamily.net> wrote in message
news:uIBgb.696064$YN5.568014@sccrnsc01...
I have a large Access 97 database that's been split into a front and
back end. We've used it successfully with several computers networked
together, but now some of the people in my organization are saying that
since some of the people who need to get at it are all over the state,
it would be nice to put it up on the web and have a web interface for
it. Is there any way to do this without rewriting the entire front end
in some other language? Much of what the database does is written into
the VBA code.

Thank you for any insight you can give me,
Rebecca



Nov 12 '05 #10

P: n/a
Running the application on Terminal server is as reliable as running on a
desktop. VPN disconnects will not affect Terminal server because your login
and the application remain open. You will have the same environment when you
reconnect and login.

I have been running Access on Terminal server since 1999, without any major
problems. I you go this route, check the Microsoft site for setup
information for Terminal server and the version of Access you are planning
to use.

Access is a resource hog. Size your server and memory for Power user for
each Access user.
Setup a private copy of your front end for each user, just like on a
desktop.

"Rebecca" <Re*****@JaxonFamily.net> wrote in message
news:79dhb.720484$uu5.119370@sccrnsc04...
Is it reliable? I went to the site that Albert Kallal suggested (above)
where he discusses it, and he suggests that since the VPN is subject to
occasional disconnects, the database can be corrupted. What do you
think about that? Of course, I don't want that to happen, but a VPN
does seem like the perfect solution otherwise.

Rebecca

paii wrote:
The application is running on the local network when using Terminal server. Terminal server CALs cost $60 per user, if you already have Windows 2000
server.

"Rebecca" <Re*****@JaxonFamily.net> wrote in message
news:T4Fgb.697149$YN5.568509@sccrnsc01...
That's interesting. Would it then behave just like it would on a local
network? Is it secure? Expensive? This is a not-for-profit
organization without a lot of excess in their budget.

Rebecca

paii wrote:

You could put the application on a Terminal server or PCAnyware


computer,
then allow your remote user to connect though a VPN.

"Rebecca" <Re*****@JaxonFamily.net> wrote in message
news:uIBgb.696064$YN5.568014@sccrnsc01...
>I have a large Access 97 database that's been split into a front and
>back end. We've used it successfully with several computers networked
>together, but now some of the people in my organization are saying that>since some of the people who need to get at it are all over the state,
>it would be nice to put it up on the web and have a web interface for
>it. Is there any way to do this without rewriting the entire front end>in some other language? Much of what the database does is written into>the VBA code.
>
>Thank you for any insight you can give me,
>Rebecca
>


Nov 12 '05 #11

P: n/a
If you want to try something inexpensive, Install PCAnyware on a desktop
Then access PCAnyware remotely thought the VPN. The VPN should make it
secure and running the application locally should protect you from
disconnect problems. You could test it without the VPN, but you would have
to open some ports on your firewall and carefully setup security on the
PCAnyware computer.

I have only tried this once back in the mid 90's using a modem on the
PCAnyware computer. The application ran OK but very slow. I would assume
that the technology has improved.

"Rebecca" <Re*****@JaxonFamily.net> wrote in message
news:79dhb.720484$uu5.119370@sccrnsc04...
Is it reliable? I went to the site that Albert Kallal suggested (above)
where he discusses it, and he suggests that since the VPN is subject to
occasional disconnects, the database can be corrupted. What do you
think about that? Of course, I don't want that to happen, but a VPN
does seem like the perfect solution otherwise.

Rebecca

paii wrote:
The application is running on the local network when using Terminal server. Terminal server CALs cost $60 per user, if you already have Windows 2000
server.

"Rebecca" <Re*****@JaxonFamily.net> wrote in message
news:T4Fgb.697149$YN5.568509@sccrnsc01...
That's interesting. Would it then behave just like it would on a local
network? Is it secure? Expensive? This is a not-for-profit
organization without a lot of excess in their budget.

Rebecca

paii wrote:

You could put the application on a Terminal server or PCAnyware


computer,
then allow your remote user to connect though a VPN.

"Rebecca" <Re*****@JaxonFamily.net> wrote in message
news:uIBgb.696064$YN5.568014@sccrnsc01...
>I have a large Access 97 database that's been split into a front and
>back end. We've used it successfully with several computers networked
>together, but now some of the people in my organization are saying that>since some of the people who need to get at it are all over the state,
>it would be nice to put it up on the web and have a web interface for
>it. Is there any way to do this without rewriting the entire front end>in some other language? Much of what the database does is written into>the VBA code.
>
>Thank you for any insight you can give me,
>Rebecca
>


Nov 12 '05 #12

P: n/a
Thank you. It's good to know that this is being done with no problems.

Now we have some research to do.

Rebecca

paii wrote:
Running the application on Terminal server is as reliable as running on a
desktop. VPN disconnects will not affect Terminal server because your login
and the application remain open. You will have the same environment when you
reconnect and login.

I have been running Access on Terminal server since 1999, without any major
problems. I you go this route, check the Microsoft site for setup
information for Terminal server and the version of Access you are planning
to use.

Access is a resource hog. Size your server and memory for Power user for
each Access user.
Setup a private copy of your front end for each user, just like on a
desktop.

"Rebecca" <Re*****@JaxonFamily.net> wrote in message
news:79dhb.720484$uu5.119370@sccrnsc04...
Is it reliable? I went to the site that Albert Kallal suggested (above)
where he discusses it, and he suggests that since the VPN is subject to
occasional disconnects, the database can be corrupted. What do you
think about that? Of course, I don't want that to happen, but a VPN
does seem like the perfect solution otherwise.

Rebecca

paii wrote:
The application is running on the local network when using Terminal
server.
Terminal server CALs cost $60 per user, if you already have Windows 2000
server.

"Rebecca" <Re*****@JaxonFamily.net> wrote in message
news:T4Fgb.697149$YN5.568509@sccrnsc01...
That's interesting. Would it then behave just like it would on a local
network? Is it secure? Expensive? This is a not-for-profit
organization without a lot of excess in their budget.

Rebecca

paii wrote:
>You could put the application on a Terminal server or PCAnyware

computer,
>then allow your remote user to connect though a VPN.
>
>"Rebecca" <Re*****@JaxonFamily.net> wrote in message
>news:uIBgb.696064$YN5.568014@sccrnsc01...
>
>
>
>>I have a large Access 97 database that's been split into a front and
>>back end. We've used it successfully with several computers networked
>>together, but now some of the people in my organization are saying
that
since some of the people who need to get at it are all over the state,
>>it would be nice to put it up on the web and have a web interface for
>>it. Is there any way to do this without rewriting the entire front
end
in some other language? Much of what the database does is written
into
the VBA code.
>>
>>Thank you for any insight you can give me,
>>Rebecca
>>
>
>
>



Nov 12 '05 #13

P: n/a
Thanks to all who responded to my post. You've given me a lot of ideas,
and I'm sure we'll find the right solution among them.

Rebecca

Rebecca wrote:
I have a large Access 97 database that's been split into a front and
back end. We've used it successfully with several computers networked
together, but now some of the people in my organization are saying that
since some of the people who need to get at it are all over the state,
it would be nice to put it up on the web and have a web interface for
it. Is there any way to do this without rewriting the entire front end
in some other language? Much of what the database does is written into
the VBA code.

Thank you for any insight you can give me,
Rebecca


Nov 12 '05 #14

P: n/a
I asked our IT yesterday avout this and they said, no way they would
support TS in App mode for a large number of users because of the cost
of CAL licenses in the first place and hassle of maintaining the license
server, too. They are already frustrated maintaining a license server.
However, this is for a very large enterprise - your mileage may vary.
Just like Albert likes to repeat - decide based upon how many seats you
will be maintaining.

Pavel

Rebecca wrote:

Thank you. It's good to know that this is being done with no problems.

Now we have some research to do.

Rebecca

paii wrote:
Running the application on Terminal server is as reliable as running on a
desktop. VPN disconnects will not affect Terminal server because your login
and the application remain open. You will have the same environment when you
reconnect and login.

I have been running Access on Terminal server since 1999, without any major
problems. I you go this route, check the Microsoft site for setup
information for Terminal server and the version of Access you are planning
to use.

Access is a resource hog. Size your server and memory for Power user for
each Access user.
Setup a private copy of your front end for each user, just like on a
desktop.

"Rebecca" <Re*****@JaxonFamily.net> wrote in message
news:79dhb.720484$uu5.119370@sccrnsc04...
Is it reliable? I went to the site that Albert Kallal suggested (above)
where he discusses it, and he suggests that since the VPN is subject to
occasional disconnects, the database can be corrupted. What do you
think about that? Of course, I don't want that to happen, but a VPN
does seem like the perfect solution otherwise.

Rebecca

paii wrote:

The application is running on the local network when using Terminal


server.
Terminal server CALs cost $60 per user, if you already have Windows 2000
server.

"Rebecca" <Re*****@JaxonFamily.net> wrote in message
news:T4Fgb.697149$YN5.568509@sccrnsc01...
>That's interesting. Would it then behave just like it would on a local
>network? Is it secure? Expensive? This is a not-for-profit
>organization without a lot of excess in their budget.
>
>Rebecca
>
>paii wrote:
>
>
>>You could put the application on a Terminal server or PCAnyware

computer,
>>then allow your remote user to connect though a VPN.
>>
>>"Rebecca" <Re*****@JaxonFamily.net> wrote in message
>>news:uIBgb.696064$YN5.568014@sccrnsc01...
>>
>>
>>
>>>I have a large Access 97 database that's been split into a front and
>>>back end. We've used it successfully with several computers networked
>>>together, but now some of the people in my organization are saying


that
>>>since some of the people who need to get at it are all over the state,
>>>it would be nice to put it up on the web and have a web interface for
>>>it. Is there any way to do this without rewriting the entire front


end
>>>in some other language? Much of what the database does is written


into
>>>the VBA code.
>>>
>>>Thank you for any insight you can give me,
>>>Rebecca
>>>
>>
>>
>>


Nov 12 '05 #15

P: n/a
Rebecca was only talking about 2 or 3 users. The whole thing could run on 1
server, using a small number of CALs. Also it you stick to Windows 2000
server, any Windows 2000 or NT 4 clients would not need a CAL.

"Pavel Romashkin" <pa*************@hotmail.com> wrote in message
news:3F***************@hotmail.com...
I asked our IT yesterday avout this and they said, no way they would
support TS in App mode for a large number of users because of the cost
of CAL licenses in the first place and hassle of maintaining the license
server, too. They are already frustrated maintaining a license server.
However, this is for a very large enterprise - your mileage may vary.
Just like Albert likes to repeat - decide based upon how many seats you
will be maintaining.

Pavel

Rebecca wrote:

Thank you. It's good to know that this is being done with no problems.

Now we have some research to do.

Rebecca

paii wrote:
Running the application on Terminal server is as reliable as running on a desktop. VPN disconnects will not affect Terminal server because your login and the application remain open. You will have the same environment when you reconnect and login.

I have been running Access on Terminal server since 1999, without any major problems. I you go this route, check the Microsoft site for setup
information for Terminal server and the version of Access you are planning to use.

Access is a resource hog. Size your server and memory for Power user for each Access user.
Setup a private copy of your front end for each user, just like on a
desktop.

"Rebecca" <Re*****@JaxonFamily.net> wrote in message
news:79dhb.720484$uu5.119370@sccrnsc04...

>Is it reliable? I went to the site that Albert Kallal suggested (above)>where he discusses it, and he suggests that since the VPN is subject to>occasional disconnects, the database can be corrupted. What do you
>think about that? Of course, I don't want that to happen, but a VPN
>does seem like the perfect solution otherwise.
>
>Rebecca
>
>paii wrote:
>
>>The application is running on the local network when using Terminal

server.

>>Terminal server CALs cost $60 per user, if you already have Windows 2000>>server.
>>
>>"Rebecca" <Re*****@JaxonFamily.net> wrote in message
>>news:T4Fgb.697149$YN5.568509@sccrnsc01...
>>
>>
>>>That's interesting. Would it then behave just like it would on a local>>>network? Is it secure? Expensive? This is a not-for-profit
>>>organization without a lot of excess in their budget.
>>>
>>>Rebecca
>>>
>>>paii wrote:
>>>
>>>
>>>>You could put the application on a Terminal server or PCAnyware
>>
>>computer,
>>
>>
>>>>then allow your remote user to connect though a VPN.
>>>>
>>>>"Rebecca" <Re*****@JaxonFamily.net> wrote in message
>>>>news:uIBgb.696064$YN5.568014@sccrnsc01...
>>>>
>>>>
>>>>
>>>>>I have a large Access 97 database that's been split into a front and>>>>>back end. We've used it successfully with several computers networked>>>>>together, but now some of the people in my organization are saying

that

>>>>>since some of the people who need to get at it are all over the state,>>>>>it would be nice to put it up on the web and have a web interface for>>>>>it. Is there any way to do this without rewriting the entire front
end

>>>>>in some other language? Much of what the database does is written

into

>>>>>the VBA code.
>>>>>
>>>>>Thank you for any insight you can give me,
>>>>>Rebecca
>>>>>
>>>>
>>>>
>>>>
>>

Nov 12 '05 #16

P: n/a
And there are free remote client software.

"paii" <pa**@packairinc.com> wrote in message
news:vo************@corp.supernews.com...
Rebecca was only talking about 2 or 3 users. The whole thing could run on 1 server, using a small number of CALs. Also it you stick to Windows 2000
server, any Windows 2000 or NT 4 clients would not need a CAL.

"Pavel Romashkin" <pa*************@hotmail.com> wrote in message
news:3F***************@hotmail.com...
I asked our IT yesterday avout this and they said, no way they would
support TS in App mode for a large number of users because of the cost
of CAL licenses in the first place and hassle of maintaining the license
server, too. They are already frustrated maintaining a license server.
However, this is for a very large enterprise - your mileage may vary.
Just like Albert likes to repeat - decide based upon how many seats you
will be maintaining.

Pavel

Rebecca wrote:

Thank you. It's good to know that this is being done with no problems.
Now we have some research to do.

Rebecca

paii wrote:
> Running the application on Terminal server is as reliable as running on a > desktop. VPN disconnects will not affect Terminal server because your
login
> and the application remain open. You will have the same environment when you > reconnect and login.
>
> I have been running Access on Terminal server since 1999, without
any
major > problems. I you go this route, check the Microsoft site for setup
> information for Terminal server and the version of Access you are planning > to use.
>
> Access is a resource hog. Size your server and memory for Power user for > each Access user.
> Setup a private copy of your front end for each user, just like on a
> desktop.
>
> "Rebecca" <Re*****@JaxonFamily.net> wrote in message
> news:79dhb.720484$uu5.119370@sccrnsc04...
>
>>Is it reliable? I went to the site that Albert Kallal suggested (above) >>where he discusses it, and he suggests that since the VPN is subject to >>occasional disconnects, the database can be corrupted. What do you
>>think about that? Of course, I don't want that to happen, but a VPN
>>does seem like the perfect solution otherwise.
>>
>>Rebecca
>>
>>paii wrote:
>>
>>>The application is running on the local network when using Terminal
>
> server.
>
>>>Terminal server CALs cost $60 per user, if you already have Windows 2000 >>>server.
>>>
>>>"Rebecca" <Re*****@JaxonFamily.net> wrote in message
>>>news:T4Fgb.697149$YN5.568509@sccrnsc01...
>>>
>>>
>>>>That's interesting. Would it then behave just like it would on a local >>>>network? Is it secure? Expensive? This is a not-for-profit
>>>>organization without a lot of excess in their budget.
>>>>
>>>>Rebecca
>>>>
>>>>paii wrote:
>>>>
>>>>
>>>>>You could put the application on a Terminal server or PCAnyware
>>>
>>>computer,
>>>
>>>
>>>>>then allow your remote user to connect though a VPN.
>>>>>
>>>>>"Rebecca" <Re*****@JaxonFamily.net> wrote in message
>>>>>news:uIBgb.696064$YN5.568014@sccrnsc01...
>>>>>
>>>>>
>>>>>
>>>>>>I have a large Access 97 database that's been split into a front and >>>>>>back end. We've used it successfully with several computers networked >>>>>>together, but now some of the people in my organization are
saying >
> that
>
>>>>>>since some of the people who need to get at it are all over the
state, >>>>>>it would be nice to put it up on the web and have a web interface for
>>>>>>it. Is there any way to do this without rewriting the entire front >
> end
>
>>>>>>in some other language? Much of what the database does is

written >
> into
>
>>>>>>the VBA code.
>>>>>>
>>>>>>Thank you for any insight you can give me,
>>>>>>Rebecca
>>>>>>
>>>>>
>>>>>
>>>>>
>>>
>
>


Nov 12 '05 #17

P: n/a
Right. At most, I think about 5 or so people total, but probably no
more than two at a time - if that.

What we've done in the past when we only had two people who needed it,
is put the back end up on our ftp site and trade it back and forth.
That's cumbersome of course, and you have to remember who "has" it at
the moment, so you both don't go in there and change things. Now, those
two people are trying to delegate more of their tasks and that means
that more people need to be able to input data.

Rebecca

paii wrote:
Rebecca was only talking about 2 or 3 users. The whole thing could run on 1
server, using a small number of CALs. Also it you stick to Windows 2000
server, any Windows 2000 or NT 4 clients would not need a CAL.

"Pavel Romashkin" <pa*************@hotmail.com> wrote in message
news:3F***************@hotmail.com...
I asked our IT yesterday avout this and they said, no way they would
support TS in App mode for a large number of users because of the cost
of CAL licenses in the first place and hassle of maintaining the license
server, too. They are already frustrated maintaining a license server.
However, this is for a very large enterprise - your mileage may vary.
Just like Albert likes to repeat - decide based upon how many seats you
will be maintaining.

Pavel

Rebecca wrote:
Thank you. It's good to know that this is being done with no problems.

Now we have some research to do.

Rebecca

paii wrote:

Running the application on Terminal server is as reliable as running
on a
desktop. VPN disconnects will not affect Terminal server because your
login
and the application remain open. You will have the same environment
when you
reconnect and login.

I have been running Access on Terminal server since 1999, without any
major
problems. I you go this route, check the Microsoft site for setup
information for Terminal server and the version of Access you are
planning
to use.

Access is a resource hog. Size your server and memory for Power user
for
each Access user.
Setup a private copy of your front end for each user, just like on a
desktop.

"Rebecca" <Re*****@JaxonFamily.net> wrote in message
news:79dhb.720484$uu5.119370@sccrnsc04...
>Is it reliable? I went to the site that Albert Kallal suggested
(above)
where he discusses it, and he suggests that since the VPN is subject
to
occasional disconnects, the database can be corrupted. What do you
>think about that? Of course, I don't want that to happen, but a VPN
>does seem like the perfect solution otherwise.
>
>Rebecca
>
>paii wrote:
>
>
>>The application is running on the local network when using Terminal

server.
>>Terminal server CALs cost $60 per user, if you already have Windows
2000
server.
>>
>>"Rebecca" <Re*****@JaxonFamily.net> wrote in message
>>news:T4Fgb.697149$YN5.568509@sccrnsc01...
>>
>>
>>
>>>That's interesting. Would it then behave just like it would on a
local
>network? Is it secure? Expensive? This is a not-for-profit
>>>organization without a lot of excess in their budget.
>>>
>>>Rebecca
>>>
>>>paii wrote:
>>>
>>>
>>>
>>>>You could put the application on a Terminal server or PCAnyware
>>
>>computer,
>>
>>
>>
>>>>then allow your remote user to connect though a VPN.
>>>>
>>>>"Rebecca" <Re*****@JaxonFamily.net> wrote in message
>>>>news:uIBgb.696064$YN5.568014@sccrnsc01.. .
>>>>
>>>>
>>>>
>>>>
>>>>>I have a large Access 97 database that's been split into a front
and
>>>back end. We've used it successfully with several computers
networked
>>>together, but now some of the people in my organization are saying

that
>>>>>since some of the people who need to get at it are all over the
state,
>>>it would be nice to put it up on the web and have a web interface
for
>>>it. Is there any way to do this without rewriting the entire
front
end
>>>>>in some other language? Much of what the database does is written

into
>>>>>the VBA code.
>>>>>
>>>>>Thank you for any insight you can give me,
>>>>>Rebecca
>>>>>
>>>>
>>>>
>>>>



Nov 12 '05 #18

This discussion thread is closed

Replies have been disabled for this discussion.