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 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
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
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
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
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
"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 > >
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
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 >> >> > >
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 >> >> > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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...
|
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
|
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.
|
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
|
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")
| |
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"
|
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
|
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?...
|
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...
|
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...
|
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...
| |
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,...
|
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...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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...
| |