473,287 Members | 1,866 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

Converting Access 2k to Web

D
Hey guys- not sure where this post fits in, so I cc'd a few other groups as
well- hope you dont mind...

I have someone creating a database for me in Access 2000 (or is it called
XP?). When it's all done, I'd like it to be online via the web. Ultimately
I'd like just an online database accessed via ASP, PHP, CGI, etc- something
(doesn't matter) but where various employees can access the thing from
anywhere and do their work. It's been quite a while since I've programmed,
and my programmer doesn't know how to make it accessible on the web. How
easy/hard is this process? Beyond just the tables and a few forms, it will
have a NUMBER of queries setup. Is this a process, or fairly simple? Is it
even possible, or, do I need to find another developer to handle it and just
create it online to begin with?

Here's one more thing- I have seen a buddy do the same thing- his work
around was just doing the virtual/desktop sharing thing. He setup a mini
'server' on his pc, so you log in via the web. Then that automatically
allows you to use the Access database via desktop sharing. This COULD work,
but I get how it's not the best setup to go with. Your thoughts?
Thanks
D
Nov 13 '05 #1
14 2405
You have basically two options,
Easy Way: Terminal Services/Remote Desktop Connections
Hard Way: ASP
If you use ASP, all of you forms will need to be created using ASP/HTML
Basically all you will be able to do is use the tables and some of the
queries from the Access Database.
You will need an ASP capable web server to host the database and web pages.
It is a pretty daunting task, I have switched from classic access to asp
over the last 2 years.
You apps will be faster over the web, no ms office overhead.
You can look here for some direction:

http://asp101.com/
http://www.bullschmidt.com/DevTip.asp
http://www.w3schools.com/
http://www.webf1.com/ScriptDoc/
http://msdn.microsoft.com/library/de...ifunctions.asp
http://www.aspin.com/
http://www.connectionstrings.com/
http://www.iisfaq.com/
http://aspfaq.com/default.asp

"D" <d@d.com> wrote in message news:oCord.80250$EZ.70402@okepread07...
Hey guys- not sure where this post fits in, so I cc'd a few other groups as well- hope you dont mind...

I have someone creating a database for me in Access 2000 (or is it called
XP?). When it's all done, I'd like it to be online via the web. Ultimately
I'd like just an online database accessed via ASP, PHP, CGI, etc- something (doesn't matter) but where various employees can access the thing from
anywhere and do their work. It's been quite a while since I've programmed,
and my programmer doesn't know how to make it accessible on the web. How
easy/hard is this process? Beyond just the tables and a few forms, it will have a NUMBER of queries setup. Is this a process, or fairly simple? Is it even possible, or, do I need to find another developer to handle it and just create it online to begin with?

Here's one more thing- I have seen a buddy do the same thing- his work
around was just doing the virtual/desktop sharing thing. He setup a mini
'server' on his pc, so you log in via the web. Then that automatically
allows you to use the Access database via desktop sharing. This COULD work, but I get how it's not the best setup to go with. Your thoughts?
Thanks
D

Nov 13 '05 #2
D
Oh jeez- I was afraid of that. Hmmmm... can you explain how the Terminal
Services deal works? Can an employee login from home, upload some files
from their machine locally to the Access virtual database, and then enter
data as well? How does that work if there's more than 1 person using the
database at the same time? That MIGHT be an option...

Thanks for the reply and links- I'll check those out as well. My problem is
my programmer doesnt know ASP and whatnot, soo... Im stuck using him, or,
fidning someone else for the job. I'm open to either, I just need this done
asap.
Thanks again!
D
"shar0n82" <sh******@nospam.hotpop.com> wrote in message
news:eO****************@TK2MSFTNGP14.phx.gbl...
You have basically two options,
Easy Way: Terminal Services/Remote Desktop Connections
Hard Way: ASP
If you use ASP, all of you forms will need to be created using ASP/HTML
Basically all you will be able to do is use the tables and some of the
queries from the Access Database.
You will need an ASP capable web server to host the database and web
pages.
It is a pretty daunting task, I have switched from classic access to asp
over the last 2 years.
You apps will be faster over the web, no ms office overhead.
You can look here for some direction:

http://asp101.com/
http://www.bullschmidt.com/DevTip.asp
http://www.w3schools.com/
http://www.webf1.com/ScriptDoc/
http://msdn.microsoft.com/library/de...ifunctions.asp
http://www.aspin.com/
http://www.connectionstrings.com/
http://www.iisfaq.com/
http://aspfaq.com/default.asp

"D" <d@d.com> wrote in message news:oCord.80250$EZ.70402@okepread07...
Hey guys- not sure where this post fits in, so I cc'd a few other groups

as
well- hope you dont mind...

I have someone creating a database for me in Access 2000 (or is it called
XP?). When it's all done, I'd like it to be online via the web.
Ultimately
I'd like just an online database accessed via ASP, PHP, CGI, etc-

something
(doesn't matter) but where various employees can access the thing from
anywhere and do their work. It's been quite a while since I've
programmed,
and my programmer doesn't know how to make it accessible on the web. How
easy/hard is this process? Beyond just the tables and a few forms, it

will
have a NUMBER of queries setup. Is this a process, or fairly simple? Is

it
even possible, or, do I need to find another developer to handle it and

just
create it online to begin with?

Here's one more thing- I have seen a buddy do the same thing- his work
around was just doing the virtual/desktop sharing thing. He setup a mini
'server' on his pc, so you log in via the web. Then that automatically
allows you to use the Access database via desktop sharing. This COULD

work,
but I get how it's not the best setup to go with. Your thoughts?
Thanks
D


Nov 13 '05 #3
D,

With terminal services you would have windows server with however many
client licenses you need terminal services. A user would access the server
over the web and log in, just as they would to a Windows Domain. Each user
would have a profile on the server with a copy of the front end of the
database on their desktop. It would interact with the backend placed
somewhere on the server. This is a common setup. You would also have to
have access installed on the server. Access is a multi user RDMS therefore
no problems for more than one user.

FYI

"D" <d@d.com> wrote in message news:O%prd.80254$EZ.50082@okepread07...
Oh jeez- I was afraid of that. Hmmmm... can you explain how the Terminal
Services deal works? Can an employee login from home, upload some files
from their machine locally to the Access virtual database, and then enter
data as well? How does that work if there's more than 1 person using the
database at the same time? That MIGHT be an option...

Thanks for the reply and links- I'll check those out as well. My problem is my programmer doesnt know ASP and whatnot, soo... Im stuck using him, or,
fidning someone else for the job. I'm open to either, I just need this done asap.
Thanks again!
D
"shar0n82" <sh******@nospam.hotpop.com> wrote in message
news:eO****************@TK2MSFTNGP14.phx.gbl...
You have basically two options,
Easy Way: Terminal Services/Remote Desktop Connections
Hard Way: ASP
If you use ASP, all of you forms will need to be created using ASP/HTML
Basically all you will be able to do is use the tables and some of the
queries from the Access Database.
You will need an ASP capable web server to host the database and web
pages.
It is a pretty daunting task, I have switched from classic access to asp
over the last 2 years.
You apps will be faster over the web, no ms office overhead.
You can look here for some direction:

http://asp101.com/
http://www.bullschmidt.com/DevTip.asp
http://www.w3schools.com/
http://www.webf1.com/ScriptDoc/
http://msdn.microsoft.com/library/de...ifunctions.asp http://www.aspin.com/
http://www.connectionstrings.com/
http://www.iisfaq.com/
http://aspfaq.com/default.asp

"D" <d@d.com> wrote in message news:oCord.80250$EZ.70402@okepread07...
Hey guys- not sure where this post fits in, so I cc'd a few other groups
as
well- hope you dont mind...

I have someone creating a database for me in Access 2000 (or is it
called XP?). When it's all done, I'd like it to be online via the web.
Ultimately
I'd like just an online database accessed via ASP, PHP, CGI, etc-

something
(doesn't matter) but where various employees can access the thing from
anywhere and do their work. It's been quite a while since I've
programmed,
and my programmer doesn't know how to make it accessible on the web. How easy/hard is this process? Beyond just the tables and a few forms, it

will
have a NUMBER of queries setup. Is this a process, or fairly simple? Is it
even possible, or, do I need to find another developer to handle it and

just
create it online to begin with?

Here's one more thing- I have seen a buddy do the same thing- his work
around was just doing the virtual/desktop sharing thing. He setup a

mini 'server' on his pc, so you log in via the web. Then that automatically
allows you to use the Access database via desktop sharing. This COULD

work,
but I get how it's not the best setup to go with. Your thoughts?
Thanks
D



Nov 13 '05 #4
Forgot to reply to the upload data issue. That is a bit more complicated.
I would probably
lean toward asp to do that. Terminal services does not natively offer a
file transfer process,
although there are server freeware add-on apps to do it. I guess it could
be done....
"D" <d@d.com> wrote in message news:O%prd.80254$EZ.50082@okepread07...
Oh jeez- I was afraid of that. Hmmmm... can you explain how the Terminal
Services deal works? Can an employee login from home, upload some files
from their machine locally to the Access virtual database, and then enter
data as well? How does that work if there's more than 1 person using the
database at the same time? That MIGHT be an option...

Thanks for the reply and links- I'll check those out as well. My problem is my programmer doesnt know ASP and whatnot, soo... Im stuck using him, or,
fidning someone else for the job. I'm open to either, I just need this done asap.
Thanks again!
D
"shar0n82" <sh******@nospam.hotpop.com> wrote in message
news:eO****************@TK2MSFTNGP14.phx.gbl...
You have basically two options,
Easy Way: Terminal Services/Remote Desktop Connections
Hard Way: ASP
If you use ASP, all of you forms will need to be created using ASP/HTML
Basically all you will be able to do is use the tables and some of the
queries from the Access Database.
You will need an ASP capable web server to host the database and web
pages.
It is a pretty daunting task, I have switched from classic access to asp
over the last 2 years.
You apps will be faster over the web, no ms office overhead.
You can look here for some direction:

http://asp101.com/
http://www.bullschmidt.com/DevTip.asp
http://www.w3schools.com/
http://www.webf1.com/ScriptDoc/
http://msdn.microsoft.com/library/de...ifunctions.asp http://www.aspin.com/
http://www.connectionstrings.com/
http://www.iisfaq.com/
http://aspfaq.com/default.asp

"D" <d@d.com> wrote in message news:oCord.80250$EZ.70402@okepread07...
Hey guys- not sure where this post fits in, so I cc'd a few other groups
as
well- hope you dont mind...

I have someone creating a database for me in Access 2000 (or is it
called XP?). When it's all done, I'd like it to be online via the web.
Ultimately
I'd like just an online database accessed via ASP, PHP, CGI, etc-

something
(doesn't matter) but where various employees can access the thing from
anywhere and do their work. It's been quite a while since I've
programmed,
and my programmer doesn't know how to make it accessible on the web. How easy/hard is this process? Beyond just the tables and a few forms, it

will
have a NUMBER of queries setup. Is this a process, or fairly simple? Is it
even possible, or, do I need to find another developer to handle it and

just
create it online to begin with?

Here's one more thing- I have seen a buddy do the same thing- his work
around was just doing the virtual/desktop sharing thing. He setup a

mini 'server' on his pc, so you log in via the web. Then that automatically
allows you to use the Access database via desktop sharing. This COULD

work,
but I get how it's not the best setup to go with. Your thoughts?
Thanks
D



Nov 13 '05 #5
I am also available for hire.....

"D" <d@d.com> wrote in message news:O%prd.80254$EZ.50082@okepread07...
Oh jeez- I was afraid of that. Hmmmm... can you explain how the Terminal
Services deal works? Can an employee login from home, upload some files
from their machine locally to the Access virtual database, and then enter
data as well? How does that work if there's more than 1 person using the
database at the same time? That MIGHT be an option...

Thanks for the reply and links- I'll check those out as well. My problem is my programmer doesnt know ASP and whatnot, soo... Im stuck using him, or,
fidning someone else for the job. I'm open to either, I just need this done asap.
Thanks again!
D
"shar0n82" <sh******@nospam.hotpop.com> wrote in message
news:eO****************@TK2MSFTNGP14.phx.gbl...
You have basically two options,
Easy Way: Terminal Services/Remote Desktop Connections
Hard Way: ASP
If you use ASP, all of you forms will need to be created using ASP/HTML
Basically all you will be able to do is use the tables and some of the
queries from the Access Database.
You will need an ASP capable web server to host the database and web
pages.
It is a pretty daunting task, I have switched from classic access to asp
over the last 2 years.
You apps will be faster over the web, no ms office overhead.
You can look here for some direction:

http://asp101.com/
http://www.bullschmidt.com/DevTip.asp
http://www.w3schools.com/
http://www.webf1.com/ScriptDoc/
http://msdn.microsoft.com/library/de...ifunctions.asp http://www.aspin.com/
http://www.connectionstrings.com/
http://www.iisfaq.com/
http://aspfaq.com/default.asp

"D" <d@d.com> wrote in message news:oCord.80250$EZ.70402@okepread07...
Hey guys- not sure where this post fits in, so I cc'd a few other groups
as
well- hope you dont mind...

I have someone creating a database for me in Access 2000 (or is it
called XP?). When it's all done, I'd like it to be online via the web.
Ultimately
I'd like just an online database accessed via ASP, PHP, CGI, etc-

something
(doesn't matter) but where various employees can access the thing from
anywhere and do their work. It's been quite a while since I've
programmed,
and my programmer doesn't know how to make it accessible on the web. How easy/hard is this process? Beyond just the tables and a few forms, it

will
have a NUMBER of queries setup. Is this a process, or fairly simple? Is it
even possible, or, do I need to find another developer to handle it and

just
create it online to begin with?

Here's one more thing- I have seen a buddy do the same thing- his work
around was just doing the virtual/desktop sharing thing. He setup a

mini 'server' on his pc, so you log in via the web. Then that automatically
allows you to use the Access database via desktop sharing. This COULD

work,
but I get how it's not the best setup to go with. Your thoughts?
Thanks
D



Nov 13 '05 #6

"shar0n82" <sh******@nospam.hotpop.com> wrote in message
news:%2******************@TK2MSFTNGP14.phx.gbl...
Forgot to reply to the upload data issue. That is a bit more complicated.
I would probably
lean toward asp to do that. Terminal services does not natively offer a
file transfer process,
Actually Server 2003 supports full redirection....
although there are server freeware add-on apps to do it. I guess it could
be done....
"D" <d@d.com> wrote in message news:O%prd.80254$EZ.50082@okepread07...
Oh jeez- I was afraid of that. Hmmmm... can you explain how the Terminal
Services deal works? Can an employee login from home, upload some files
from their machine locally to the Access virtual database, and then enter
data as well? How does that work if there's more than 1 person using the
database at the same time? That MIGHT be an option...

Thanks for the reply and links- I'll check those out as well. My problem

is
my programmer doesnt know ASP and whatnot, soo... Im stuck using him, or,
fidning someone else for the job. I'm open to either, I just need this

done
asap.
Thanks again!
D
"shar0n82" <sh******@nospam.hotpop.com> wrote in message
news:eO****************@TK2MSFTNGP14.phx.gbl...
You have basically two options,
Easy Way: Terminal Services/Remote Desktop Connections
Hard Way: ASP
If you use ASP, all of you forms will need to be created using ASP/HTML
Basically all you will be able to do is use the tables and some of the
queries from the Access Database.
You will need an ASP capable web server to host the database and web
pages.
It is a pretty daunting task, I have switched from classic access to asp
over the last 2 years.
You apps will be faster over the web, no ms office overhead.
You can look here for some direction:

http://asp101.com/
http://www.bullschmidt.com/DevTip.asp
http://www.w3schools.com/
http://www.webf1.com/ScriptDoc/

http://msdn.microsoft.com/library/de...ifunctions.asp
http://www.aspin.com/
http://www.connectionstrings.com/
http://www.iisfaq.com/
http://aspfaq.com/default.asp

"D" <d@d.com> wrote in message news:oCord.80250$EZ.70402@okepread07...
> Hey guys- not sure where this post fits in, so I cc'd a few other groups as
> well- hope you dont mind...
>
> I have someone creating a database for me in Access 2000 (or is it called> XP?). When it's all done, I'd like it to be online via the web.
> Ultimately
> I'd like just an online database accessed via ASP, PHP, CGI, etc-
something
> (doesn't matter) but where various employees can access the thing from
> anywhere and do their work. It's been quite a while since I've
> programmed,
> and my programmer doesn't know how to make it accessible on the web. How> easy/hard is this process? Beyond just the tables and a few forms, it
will
> have a NUMBER of queries setup. Is this a process, or fairly simple? Is it
> even possible, or, do I need to find another developer to handle it and
just
> create it online to begin with?
>
> Here's one more thing- I have seen a buddy do the same thing- his work
> around was just doing the virtual/desktop sharing thing. He setup a mini> 'server' on his pc, so you log in via the web. Then that automatically
> allows you to use the Access database via desktop sharing. This COULD
work,
> but I get how it's not the best setup to go with. Your thoughts?
> Thanks
> D
>
>



Nov 13 '05 #7
Before you go much further, I'd advise you to consider what server options
you have available.
If you're not using a Windows server, there will be extra costs in
supporting even ASP.
If you have a Windows server, but no Terminal Server, or no licenses, be
sure you factor those costs (and the time/costs of getting them set up) into
your project costs as you consider that alternative.

If your web hosting is a purchased service (you're not hosting this
in-house), you'll need to know what your provider can offer- and whether
that will change the price you're paying.

Without knowing these things, it would be difficult to make a decision on
whether to build a web-enabled front end for your tables/queries, or to use
an Access front-end over a Terminal Server.

BTW -
Whichever route you go, you can include as many queries as you like in
your back-end; they will be available just like the tables.
"D" <d@d.com> wrote in message news:oCord.80250$EZ.70402@okepread07...
Hey guys- not sure where this post fits in, so I cc'd a few other groups as well- hope you dont mind...

I have someone creating a database for me in Access 2000 (or is it called
XP?). When it's all done, I'd like it to be online via the web. Ultimately
I'd like just an online database accessed via ASP, PHP, CGI, etc- something (doesn't matter) but where various employees can access the thing from
anywhere and do their work. It's been quite a while since I've programmed,
and my programmer doesn't know how to make it accessible on the web. How
easy/hard is this process? Beyond just the tables and a few forms, it will have a NUMBER of queries setup. Is this a process, or fairly simple? Is it even possible, or, do I need to find another developer to handle it and just create it online to begin with?

Here's one more thing- I have seen a buddy do the same thing- his work
around was just doing the virtual/desktop sharing thing. He setup a mini
'server' on his pc, so you log in via the web. Then that automatically
allows you to use the Access database via desktop sharing. This COULD work, but I get how it's not the best setup to go with. Your thoughts?
Thanks
D

Nov 13 '05 #8
D
So let me get this right. Each 'employee' would have a copy of the front end
of the database on their own computers. Then, they do this Terminal Services
thing, tap into my server for the backend database. So, they have all their
forms and whatnot on the front end, sitting on their local machine, then,
the database itself, tables, etc will be sitting on the server. So, using
their front end forms/reports, they can tap into the backend (on the
server), access and modify records, export, import, create reports, etc
which will change on the backend.

Do I have this right?

How does the terminal services deal work? Is it just say, an IP address and
a password or something, and they login and now have access to it? Are
there any OS restrictions for the front end, or, will they all be able to
use the front end on XP, 2k, etc?

Last question- what do you charge per hour? Would you be up for creating a
system via ASP on teh web?
Thanks!
D
"shar0n82" <sh******@nospam.hotpop.com> wrote in message
news:ut****************@TK2MSFTNGP10.phx.gbl...
I am also available for hire.....

"D" <d@d.com> wrote in message news:O%prd.80254$EZ.50082@okepread07...
Oh jeez- I was afraid of that. Hmmmm... can you explain how the Terminal
Services deal works? Can an employee login from home, upload some files
from their machine locally to the Access virtual database, and then enter
data as well? How does that work if there's more than 1 person using the
database at the same time? That MIGHT be an option...

Thanks for the reply and links- I'll check those out as well. My problem

is
my programmer doesnt know ASP and whatnot, soo... Im stuck using him, or,
fidning someone else for the job. I'm open to either, I just need this

done
asap.
Thanks again!
D
"shar0n82" <sh******@nospam.hotpop.com> wrote in message
news:eO****************@TK2MSFTNGP14.phx.gbl...
> You have basically two options,
> Easy Way: Terminal Services/Remote Desktop Connections
> Hard Way: ASP
> If you use ASP, all of you forms will need to be created using ASP/HTML
> Basically all you will be able to do is use the tables and some of the
> queries from the Access Database.
> You will need an ASP capable web server to host the database and web
> pages.
> It is a pretty daunting task, I have switched from classic access to
> asp
> over the last 2 years.
> You apps will be faster over the web, no ms office overhead.
> You can look here for some direction:
>
> http://asp101.com/
> http://www.bullschmidt.com/DevTip.asp
> http://www.w3schools.com/
> http://www.webf1.com/ScriptDoc/
> http://msdn.microsoft.com/library/de...ifunctions.asp > http://www.aspin.com/
> http://www.connectionstrings.com/
> http://www.iisfaq.com/
> http://aspfaq.com/default.asp
>
>
>
> "D" <d@d.com> wrote in message news:oCord.80250$EZ.70402@okepread07...
>> Hey guys- not sure where this post fits in, so I cc'd a few other groups > as
>> well- hope you dont mind...
>>
>> I have someone creating a database for me in Access 2000 (or is it called >> XP?). When it's all done, I'd like it to be online via the web.
>> Ultimately
>> I'd like just an online database accessed via ASP, PHP, CGI, etc-
> something
>> (doesn't matter) but where various employees can access the thing from
>> anywhere and do their work. It's been quite a while since I've
>> programmed,
>> and my programmer doesn't know how to make it accessible on the web. How >> easy/hard is this process? Beyond just the tables and a few forms, it
> will
>> have a NUMBER of queries setup. Is this a process, or fairly simple? Is > it
>> even possible, or, do I need to find another developer to handle it
>> and
> just
>> create it online to begin with?
>>
>> Here's one more thing- I have seen a buddy do the same thing- his work
>> around was just doing the virtual/desktop sharing thing. He setup a mini >> 'server' on his pc, so you log in via the web. Then that automatically
>> allows you to use the Access database via desktop sharing. This COULD
> work,
>> but I get how it's not the best setup to go with. Your thoughts?
>> Thanks
>> D
>>
>>
>
>



Nov 13 '05 #9
D
Going with the Terminal Service route- how fast/slow is this? How prone is
it to crashing? Is there a limit to a # of users at one time? Will it run
slow if there's 2-3 people working in it at one time from different
locations?
Thanks!
D

"shar0n82" <sh******@nospam.hotpop.com> wrote in message
news:ut****************@TK2MSFTNGP10.phx.gbl...
I am also available for hire.....

"D" <d@d.com> wrote in message news:O%prd.80254$EZ.50082@okepread07...
Oh jeez- I was afraid of that. Hmmmm... can you explain how the Terminal
Services deal works? Can an employee login from home, upload some files
from their machine locally to the Access virtual database, and then enter
data as well? How does that work if there's more than 1 person using the
database at the same time? That MIGHT be an option...

Thanks for the reply and links- I'll check those out as well. My problem

is
my programmer doesnt know ASP and whatnot, soo... Im stuck using him, or,
fidning someone else for the job. I'm open to either, I just need this

done
asap.
Thanks again!
D
"shar0n82" <sh******@nospam.hotpop.com> wrote in message
news:eO****************@TK2MSFTNGP14.phx.gbl...
> You have basically two options,
> Easy Way: Terminal Services/Remote Desktop Connections
> Hard Way: ASP
> If you use ASP, all of you forms will need to be created using ASP/HTML
> Basically all you will be able to do is use the tables and some of the
> queries from the Access Database.
> You will need an ASP capable web server to host the database and web
> pages.
> It is a pretty daunting task, I have switched from classic access to
> asp
> over the last 2 years.
> You apps will be faster over the web, no ms office overhead.
> You can look here for some direction:
>
> http://asp101.com/
> http://www.bullschmidt.com/DevTip.asp
> http://www.w3schools.com/
> http://www.webf1.com/ScriptDoc/
> http://msdn.microsoft.com/library/de...ifunctions.asp > http://www.aspin.com/
> http://www.connectionstrings.com/
> http://www.iisfaq.com/
> http://aspfaq.com/default.asp
>
>
>
> "D" <d@d.com> wrote in message news:oCord.80250$EZ.70402@okepread07...
>> Hey guys- not sure where this post fits in, so I cc'd a few other groups > as
>> well- hope you dont mind...
>>
>> I have someone creating a database for me in Access 2000 (or is it called >> XP?). When it's all done, I'd like it to be online via the web.
>> Ultimately
>> I'd like just an online database accessed via ASP, PHP, CGI, etc-
> something
>> (doesn't matter) but where various employees can access the thing from
>> anywhere and do their work. It's been quite a while since I've
>> programmed,
>> and my programmer doesn't know how to make it accessible on the web. How >> easy/hard is this process? Beyond just the tables and a few forms, it
> will
>> have a NUMBER of queries setup. Is this a process, or fairly simple? Is > it
>> even possible, or, do I need to find another developer to handle it
>> and
> just
>> create it online to begin with?
>>
>> Here's one more thing- I have seen a buddy do the same thing- his work
>> around was just doing the virtual/desktop sharing thing. He setup a mini >> 'server' on his pc, so you log in via the web. Then that automatically
>> allows you to use the Access database via desktop sharing. This COULD
> work,
>> but I get how it's not the best setup to go with. Your thoughts?
>> Thanks
>> D
>>
>>
>
>



Nov 13 '05 #10
On Wed, 1 Dec 2004 17:46:59 -0700, "D" <d@d.com> wrote:

TS requires a beefy server: after all it has to run a Windows session
for each logged in user. The CPU(s) and memory of the server will be
used to service all these sessions kind of round-robin.
We have clients using TS successfully with more than 10 concurrent
users. Citrix is often used with these higher user loads, because it
is more efficient and configurable.

-Tom.

Going with the Terminal Service route- how fast/slow is this? How prone is
it to crashing? Is there a limit to a # of users at one time? Will it run
slow if there's 2-3 people working in it at one time from different
locations?
Thanks!
D

<clip>
Nov 13 '05 #11
D
Hmmm- yeah that seems way more than what I want to do. I think the best
option is to find a programmer to put it together for me. Hmmm- maybe the
Indians on Elance will do it?
Thanks
D
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:9j********************************@4ax.com...
On Wed, 1 Dec 2004 17:46:59 -0700, "D" <d@d.com> wrote:

TS requires a beefy server: after all it has to run a Windows session
for each logged in user. The CPU(s) and memory of the server will be
used to service all these sessions kind of round-robin.
We have clients using TS successfully with more than 10 concurrent
users. Citrix is often used with these higher user loads, because it
is more efficient and configurable.

-Tom.

Going with the Terminal Service route- how fast/slow is this? How prone
is
it to crashing? Is there a limit to a # of users at one time? Will it run
slow if there's 2-3 people working in it at one time from different
locations?
Thanks!
D

<clip>

Nov 13 '05 #12
"D" <d@d.com> wrote in message news:Oltrd.80329$EZ.45603@okepread07...
So let me get this right. Each 'employee' would have a copy of the front end of the database on their own computers. Then, they do this Terminal Services thing, tap into my server for the backend database. [Snip]


Incorrect. Terminal Services lets the user "remotely" run programs on the
server. The ONLY program required on the client is the Terminal Server
client. However; each user running programs on the Terminal Server is
required to hold valid licenses for any software they run on the server in
addition to a Terminal Server license.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #13
> So let me get this right. Each 'employee' would have a copy of the front

Each 'employee' would have a copy of the front end of the
database in their profile (for example, in their documents
folder) on the server.

TS clients run on XP, 2K etc.

TS clients login to the server: normally you configure them
as normal windows users. They login, go to MyDocuments,
and open the database front end.

"D" <d@d.com> wrote in message news:Oltrd.80329$EZ.45603@okepread07...
So let me get this right. Each 'employee' would have a copy of the front end of the database on their own computers. Then, they do this Terminal Services thing, tap into my server for the backend database. So, they have all their forms and whatnot on the front end, sitting on their local machine, then,
the database itself, tables, etc will be sitting on the server. So, using
their front end forms/reports, they can tap into the backend (on the
server), access and modify records, export, import, create reports, etc
which will change on the backend.

Do I have this right?

How does the terminal services deal work? Is it just say, an IP address and a password or something, and they login and now have access to it? Are
there any OS restrictions for the front end, or, will they all be able to
use the front end on XP, 2k, etc?

Last question- what do you charge per hour? Would you be up for creating a system via ASP on teh web?
Thanks!
D
"shar0n82" <sh******@nospam.hotpop.com> wrote in message
news:ut****************@TK2MSFTNGP10.phx.gbl...
I am also available for hire.....

"D" <d@d.com> wrote in message news:O%prd.80254$EZ.50082@okepread07...
Oh jeez- I was afraid of that. Hmmmm... can you explain how the Terminal Services deal works? Can an employee login from home, upload some files from their machine locally to the Access virtual database, and then enter data as well? How does that work if there's more than 1 person using the database at the same time? That MIGHT be an option...

Thanks for the reply and links- I'll check those out as well. My problem
is
my programmer doesnt know ASP and whatnot, soo... Im stuck using him,
or, fidning someone else for the job. I'm open to either, I just need this

done
asap.
Thanks again!
D
"shar0n82" <sh******@nospam.hotpop.com> wrote in message
news:eO****************@TK2MSFTNGP14.phx.gbl...
> You have basically two options,
> Easy Way: Terminal Services/Remote Desktop Connections
> Hard Way: ASP
> If you use ASP, all of you forms will need to be created using ASP/HTML > Basically all you will be able to do is use the tables and some of the > queries from the Access Database.
> You will need an ASP capable web server to host the database and web
> pages.
> It is a pretty daunting task, I have switched from classic access to
> asp
> over the last 2 years.
> You apps will be faster over the web, no ms office overhead.
> You can look here for some direction:
>
> http://asp101.com/
> http://www.bullschmidt.com/DevTip.asp
> http://www.w3schools.com/
> http://www.webf1.com/ScriptDoc/
>

http://msdn.microsoft.com/library/de...ifunctions.asp
> http://www.aspin.com/
> http://www.connectionstrings.com/
> http://www.iisfaq.com/
> http://aspfaq.com/default.asp
>
>
>
> "D" <d@d.com> wrote in message news:oCord.80250$EZ.70402@okepread07... >> Hey guys- not sure where this post fits in, so I cc'd a few other

groups
> as
>> well- hope you dont mind...
>>
>> I have someone creating a database for me in Access 2000 (or is it

called
>> XP?). When it's all done, I'd like it to be online via the web.
>> Ultimately
>> I'd like just an online database accessed via ASP, PHP, CGI, etc-
> something
>> (doesn't matter) but where various employees can access the thing from >> anywhere and do their work. It's been quite a while since I've
>> programmed,
>> and my programmer doesn't know how to make it accessible on the web.

How
>> easy/hard is this process? Beyond just the tables and a few forms, it > will
>> have a NUMBER of queries setup. Is this a process, or fairly simple?

Is
> it
>> even possible, or, do I need to find another developer to handle it
>> and
> just
>> create it online to begin with?
>>
>> Here's one more thing- I have seen a buddy do the same thing- his work >> around was just doing the virtual/desktop sharing thing. He setup a

mini
>> 'server' on his pc, so you log in via the web. Then that automatically >> allows you to use the Access database via desktop sharing. This COULD > work,
>> but I get how it's not the best setup to go with. Your thoughts?
>> Thanks
>> D
>>
>>
>
>



Nov 13 '05 #14
"D" <d@d.com> wrote in message news:Owtrd.80435$EZ.34614@okepread07...
Going with the Terminal Service route- how fast/slow is this? How prone
is it to crashing? Is there a limit to a # of users at one time? Will it
run slow if there's 2-3 people working in it at one time from different
locations?
Thanks!
D


TS is very reliable. And, no, it don't run slow with 2 or 5 remote people.
TS is a great solution for allowing your sales force, or people working at
home to use your application across the internet. If you are running windows
2000, or 2003 server, then TS is included. You can actually enable TS, and
then reboot the server..and you are up and running (I am not a network
guy..and this process is just a simple check box..and a re-boot). Once done,
you are allowed to have two free remote users at the same time. So, assuming
you will never have more then two remote users at the SAME TIME, then this
in effect is free for you to do this.

However, if you need MORE then 2 remote users at the same time, then you
have to start purchasing additional licenses to make this process happen.

Further, while it is a no brainier snap to enable TS, it certainly is NOT
EASY TO setup security correctly. In other words, if you are to expose your
server to the web, then you need very VERY competent server admin who know
how to do this. You likely would setup and use a Secure VPN to the server.

Also, TS is of course the same idea as remote desktop (in fact, it is based
on the same technology).

You can read about TS, and some other solutions to deploying ms-access to a
wide area network here:
http://www.attcanada.net/~kallal.msn/Wan/Wans.html
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.attcanada.net/~kallal.msn
Nov 13 '05 #15

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

17
by: chicha | last post by:
Hey people, I have to convert MS Access 2000 database into mysql database, the whole thing being part of this project I'm doing for one of my faculty classes. My professor somehow presumed I...
5
by: Terry Bell | last post by:
I'm upsizing an Access database. Got the data converted, working on the front end, converting queries to views, but having trouble converting queries that use logical expressions like the...
1
by: gary | last post by:
I am interesting in converting all or at least any portions of a Access 2002 frontend.mdb and backend.mdb into VB.net. Are there any conversion tools for such a monstrous task? I am especially...
2
by: Rohit | last post by:
Hi, My organisation is using Access 97 and going to replace it with access 2000. Users have n number mdb files created in 97. After installation of Access 2000 I need to conver ALL the mdbs to...
32
by: robert d via AccessMonster.com | last post by:
I'm looking at converting DAO to ADO in my app. All of my DAO connections are of the following structure: Dim wsName As DAO.Workspace Dim dbName As DAO.Database Dim rsName As DAO.Recordset ...
4
by: gg9h0st | last post by:
i'm a newbie studying php. i was into array part on tutorial and it says i'll get an array having keys that from member variable's name by converting an object to array. i guessed "i can...
9
by: Terry | last post by:
I am converting (attempting) some vb6 code that makes vast use of interfaces. One of the major uses is to be able to split out Read-only access to an obect. Let me give you a simple (contrived)...
4
by: Bob Alston | last post by:
Anyone have experience with converting an access app from Jet database to Mysql? I am specifically looking for any changes I would have to make to my access forms, queries, modules, vba code, etc....
1
by: murraystewart | last post by:
I have spent days building a database in access 2003 and the found it needs to run on Access 97, I did the conversion but the form is not opening with an error message "you loaded a form or report...
28
by: Randy Reimers | last post by:
(Hope I'm posting this correctly, otherwise - sorry!, don't know what else to do) I wrote a set of programs "many" years ago, running in a type of basic, called "Thoroughbred Basic", a type of...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.