473,782 Members | 2,505 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 2450
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.8025 0$EZ.70402@okep read07...
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******@nospa m.hotpop.com> wrote in message
news:eO******** ********@TK2MSF TNGP14.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.8025 0$EZ.70402@okep read07...
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.8025 4$EZ.50082@okep read07...
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******@nospa m.hotpop.com> wrote in message
news:eO******** ********@TK2MSF TNGP14.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.8025 0$EZ.70402@okep read07...
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.8025 4$EZ.50082@okep read07...
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******@nospa m.hotpop.com> wrote in message
news:eO******** ********@TK2MSF TNGP14.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.8025 0$EZ.70402@okep read07...
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.8025 4$EZ.50082@okep read07...
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******@nospa m.hotpop.com> wrote in message
news:eO******** ********@TK2MSF TNGP14.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.8025 0$EZ.70402@okep read07...
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******@nospa m.hotpop.com> wrote in message
news:%2******** **********@TK2M SFTNGP14.phx.gb l...
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.8025 4$EZ.50082@okep read07...
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******@nospa m.hotpop.com> wrote in message
news:eO******** ********@TK2MSF TNGP14.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.8025 0$EZ.70402@okep read07...
> 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.8025 0$EZ.70402@okep read07...
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******@nospa m.hotpop.com> wrote in message
news:ut******** ********@TK2MSF TNGP10.phx.gbl. ..
I am also available for hire.....

"D" <d@d.com> wrote in message news:O%prd.8025 4$EZ.50082@okep read07...
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******@nospa m.hotpop.com> wrote in message
news:eO******** ********@TK2MSF TNGP14.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.8025 0$EZ.70402@okep read07...
>> 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******@nospa m.hotpop.com> wrote in message
news:ut******** ********@TK2MSF TNGP10.phx.gbl. ..
I am also available for hire.....

"D" <d@d.com> wrote in message news:O%prd.8025 4$EZ.50082@okep read07...
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******@nospa m.hotpop.com> wrote in message
news:eO******** ********@TK2MSF TNGP14.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.8025 0$EZ.70402@okep read07...
>> 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

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

Similar topics

17
2908
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 knew db's and gave me long list of things to do with that particular database, first thing being that particular conversion. Truth is that I don't know a first thing about db's, let alone using mysql... I downloaded mysql form www.mysql.com and...
5
2304
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 following: SELECT OrderId, Sum((BackOrderQtyAvailable>0)*-1) AS ReadyBackOrderItems FROM OrderDetails INNER JOIN Items ON (OrderDetails.ClientId = Items.ClientId) AND (OrderDetails.ItemId = Items.ItemId) WHERE (NOT (SitesCustomerTypeId = 2
1
1775
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 interested in converting the layout of the forms and the queries. Any portion that I can convert will certainly be better than nothing. Thanks, Gary.
2
1671
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 97. Is there any so that this process will take minimum amount of time? Thanks in Advance
32
12519
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 Set wsName = DBEngine.Workspaces(0) Set dbName = wsName.OpenDatabase(CurrentProject.FullName) Set rsName = dbName.OpenRecordset("SQL Statement")
4
3195
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 get public members but not protected, private, static members"
9
2579
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) example: In Project RoObjDefs: RoPerson.cls file: Public Property Get FirstName() as String Public Property Get LastName() as String <end of file RoPerson.cls> RoPersons.cls file Public Function Count() as Integer
4
3323
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. I understand there are some data format differences in text field types and date types that need to be addressed if converting from Jet to Mysql. But other than things that have to be addressed when converting, what other changes must I make?...
1
2465
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 that has control or properties that microsoft access does not recognize and will ignore". have tried compacting and repairing and converting to MDE but to no avail. Is there anyone out there who could take a look at it. This is the first database...
28
3597
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 business basic. I need to re-write it, bring it kicking and screaming to run on Windows XP. This is for a video rental place, tracks movie and game rentals, customers, employee transactions, reservations, does reports,..... and on. I know some of...
0
10311
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10080
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8967
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7492
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5378
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5509
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4043
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3639
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2874
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.