| Author |
Help with MSAccess to SQL server
|
|
| Derek White 2002-07-27, 5:25 pm |
| Ok here's the deal...
I have a MS Access database that Im working on pulling apart and
rebuilding under MySQL (or some other SQL database im not sure yet)
under a Linux server...
The database itself is used as a Point Of Sale system.
What im hoping to do is rebuild and redesign the structure of the
database into the SQL server.
What I really want to do is use a web-based front end interface for
entering data into the system... such as entering products, etc. I
also want to use a webbased interface for retrieving the same data...
and building reports and such.
I would love to go to an all web-based interface... and eventually build
it where I can enter sales information from a remote location.
I know that in MS Access you can use subforms and queries to enter a
sale (like what they have on the sample Northwind Database) My
question is... is this extremely complicated to do with HTML/ASP/etc...
I would like to know if there are any websites out there that would give
me the information Im looking for.
| |
| Duane Arnold 2002-07-27, 9:25 pm |
| What are you talking about here? Taking the access tables and uploading
data and table structures into MS SQL Server so you can work there?
"Derek White" <dw.white@verizon.net> wrote in message
news:3D432670.8C42869B@verizon.net...
> Ok here's the deal...
>
> I have a MS Access database that Im working on pulling apart and
> rebuilding under MySQL (or some other SQL database im not sure yet)
> under a Linux server...
>
> The database itself is used as a Point Of Sale system.
>
> What im hoping to do is rebuild and redesign the structure of the
> database into the SQL server.
>
> What I really want to do is use a web-based front end interface for
> entering data into the system... such as entering products, etc. I
> also want to use a webbased interface for retrieving the same data...
> and building reports and such.
>
> I would love to go to an all web-based interface... and eventually build
> it where I can enter sales information from a remote location.
>
> I know that in MS Access you can use subforms and queries to enter a
> sale (like what they have on the sample Northwind Database) My
> question is... is this extremely complicated to do with HTML/ASP/etc...
>
> I would like to know if there are any websites out there that would give
> me the information Im looking for.
>
>
>
| |
| Derek White 2002-07-27, 10:25 pm |
| Not exactly....
Ill be taking the data already in the Access tables and entering it into MySQL
server on a Linux Server.
Duane Arnold wrote:
> What are you talking about here? Taking the access tables and uploading
> data and table structures into MS SQL Server so you can work there?
>
> "Derek White" <dw.white@verizon.net> wrote in message
> news:3D432670.8C42869B@verizon.net...
> > Ok here's the deal...
> >
> > I have a MS Access database that Im working on pulling apart and
> > rebuilding under MySQL (or some other SQL database im not sure yet)
> > under a Linux server...
> >
> > The database itself is used as a Point Of Sale system.
> >
> > What im hoping to do is rebuild and redesign the structure of the
> > database into the SQL server.
> >
> > What I really want to do is use a web-based front end interface for
> > entering data into the system... such as entering products, etc. I
> > also want to use a webbased interface for retrieving the same data...
> > and building reports and such.
> >
> > I would love to go to an all web-based interface... and eventually build
> > it where I can enter sales information from a remote location.
> >
> > I know that in MS Access you can use subforms and queries to enter a
> > sale (like what they have on the sample Northwind Database) My
> > question is... is this extremely complicated to do with HTML/ASP/etc...
> >
> > I would like to know if there are any websites out there that would give
> > me the information Im looking for.
> >
> >
> >
| |
| Duane Arnold 2002-07-28, 12:25 am |
| When you say entering it into MySql, you mean uploading right?
I bring this up because my company is moving to MySql on a project. I am a
MS SQL guy and I really don't want to have any contact with MySql, but I may
not have a choice.
How is Mysql compared to MS Sql Server? I hear there is no tech support for
MySql.
You cannot import table objects and data right from Access into MySql like
you can with SQL Server?
"Derek White" <dw.white@verizon.net> wrote in message
news:3D436E9B.81A5064F@verizon.net...
> Not exactly....
>
> Ill be taking the data already in the Access tables and entering it into
MySQL
> server on a Linux Server.
>
>
>
> Duane Arnold wrote:
>
> > What are you talking about here? Taking the access tables and uploading
> > data and table structures into MS SQL Server so you can work there?
> >
> > "Derek White" <dw.white@verizon.net> wrote in message
> > news:3D432670.8C42869B@verizon.net...
> > > Ok here's the deal...
> > >
> > > I have a MS Access database that Im working on pulling apart and
> > > rebuilding under MySQL (or some other SQL database im not sure yet)
> > > under a Linux server...
> > >
> > > The database itself is used as a Point Of Sale system.
> > >
> > > What im hoping to do is rebuild and redesign the structure of the
> > > database into the SQL server.
> > >
> > > What I really want to do is use a web-based front end interface for
> > > entering data into the system... such as entering products, etc. I
> > > also want to use a webbased interface for retrieving the same data...
> > > and building reports and such.
> > >
> > > I would love to go to an all web-based interface... and eventually
build
> > > it where I can enter sales information from a remote location.
> > >
> > > I know that in MS Access you can use subforms and queries to enter a
> > > sale (like what they have on the sample Northwind Database) My
> > > question is... is this extremely complicated to do with
HTML/ASP/etc... [colo
r=darkred]
> > >
> > > I would like to know if there are any websites out there that would[/color]
give[
color=darkred]
> > > me the information Im looking for.
> > >
> > >
> > >
>[/color]
| |
| Michael Heiming 2002-07-28, 1:25 am |
| Duane Arnold (<S_L09.192705$uw.102288@rwcrnsc51.ops.asp.att.net> ):
> When you say entering it into MySql, you mean uploading right?
>
> I bring this up because my company is moving to MySql on a
> project. I am a MS SQL guy and I really don't want to have any
> contact with MySql, but I may not have a choice.
>
> How is Mysql compared to MS Sql Server? I hear there is no tech
> support for MySql.
>
> You cannot import table objects and data right from Access into
> MySql like you can with SQL Server?
Sure?
Haven't used it but it sounds promising:
http://www.accessmysql.com/
MyAccess is an AddIn for MS Access 97/2000 which allows you to
manage MySQL databases from within Access. Main functions are:
Create/Modify Tables
Execute Queries against MySQL
Synchronize tables between Access and MySQL
Import/Export tables from Access to MySQL and vice versa
Log Changes
Database Documentation Report
Michael Heiming
PS: Could you please stop top-posting.
--
Remove the +SIGNS case mail bounces.
| |
| unknown 2002-07-28, 4:25 am |
| On Sun, 28 Jul 2002 01:01:19 +0200, Derek White wrote:
> Ok here's the deal...
>
> I have a MS Access database that Im working on pulling apart and
> rebuilding under MySQL (or some other SQL database im not sure yet)
> under a Linux server...
>
> The database itself is used as a Point Of Sale system.
>
> What im hoping to do is rebuild and redesign the structure of the
> database into the SQL server.
>
> What I really want to do is use a web-based front end interface for
> entering data into the system... such as entering products, etc. I
> also want to use a webbased interface for retrieving the same data...
> and building reports and such.
>
> I would love to go to an all web-based interface... and eventually build
> it where I can enter sales information from a remote location.
>
> I know that in MS Access you can use subforms and queries to enter a
> sale (like what they have on the sample Northwind Database) My
> question is... is this extremely complicated to do with HTML/ASP/etc...
>
> I would like to know if there are any websites out there that would give
> me the information Im looking for.
http://otn.oracle.com
look for BC4J
Cheers,
dmz17
| |
| Jeff Cochran 2002-07-28, 8:25 am |
| >When you say entering it into MySql, you mean uploading right?
>
>I bring this up because my company is moving to MySql on a project. I am a
>MS SQL guy and I really don't want to have any contact with MySql, but I may
>not have a choice.
>
>How is Mysql compared to MS Sql Server? I hear there is no tech support for
>MySql.
>
>You cannot import table objects and data right from Access into MySql like
>you can with SQL Server?
It's not direct, no. But you can always export/import data and for
the most part, any SQL statements are usually fine, with a possibility
of some syntax issues.
Also, you can load MySQL and use MyAccess to have an Access front-end,
though if you're getting away from Access this isn't the way to go.
Jeff
| |
| John Hasler 2002-07-28, 10:25 am |
| Derek White writes:
> What I really want to do is use a web-based front end interface for
> entering data into the system... such as entering products, etc. I also
> want to use a webbased interface for retrieving the same data... and
> building reports and such.
Take a look at sql-ledger at <http://www.sql-ledger.com/> .
--
John Hasler
john@dhh.gt.org
Dancing Horse Hill
Elmwood, Wisconsin
| |
| Derek White 2002-07-28, 12:25 pm |
| No I wont be uploading due to changes in the table structure (i.e. ill be
removing certain columns in the tables that are no longer applicable to the
company... and adding other things to other tables that need to be added)
Duane Arnold wrote:
> When you say entering it into MySql, you mean uploading right?
>
> I bring this up because my company is moving to MySql on a project. I am a
> MS SQL guy and I really don't want to have any contact with MySql, but I may
> not have a choice.
>
> How is Mysql compared to MS Sql Server? I hear there is no tech support for
> MySql.
>
> You cannot import table objects and data right from Access into MySql like
> you can with SQL Server?
>
> "Derek White" <dw.white@verizon.net> wrote in message
> news:3D436E9B.81A5064F@verizon.net...
> > Not exactly....
> >
> > Ill be taking the data already in the Access tables and entering it into
> MySQL
> > server on a Linux Server.
> >
> >
> >
> > Duane Arnold wrote:
> >
> > > What are you talking about here? Taking the access tables and uploading
> > > data and table structures into MS SQL Server so you can work there?
> > >
> > > "Derek White" <dw.white@verizon.net> wrote in message
> > > news:3D432670.8C42869B@verizon.net...
> > > > Ok here's the deal...
> > > >
> > > > I have a MS Access database that Im working on pulling apart and
> > > > rebuilding under MySQL (or some other SQL database im not sure yet)
> > > > under a Linux server...
> > > >
> > > > The database itself is used as a Point Of Sale system.
> > > >
> > > > What im hoping to do is rebuild and redesign the structure of the
> > > > database into the SQL server.
> > > >
> > > > What I really want to do is use a web-based front end interface for
> > > > entering data into the system... such as entering products, etc. I
> > > > also want to use a webbased interface for retrieving the same data...
> > > > and building reports and such.
> > > >
> > > > I would love to go to an all web-based interface... and eventually
> build
> > > > it where I can enter sales information from a remote location.
> > > >
> > > > I know that in MS Access you can use subforms and queries to enter a
> > > > sale (like what they have on the sample Northwind Database) My
> > > > question is... is this extremely complicated to do with
> HTML/ASP/etc...
> > > >
> > > > I would like to know if there are any websites out there that would
> give
> > > > me the information Im looking for.
> > > >
> > > >
> > > >
> >
| |
| Andreas Mattern 2002-07-30, 7:25 am |
| Derek White <dw.white@verizon.net> wrote:
SNIP
> What I really want to do is use a web-based front end interface for
> entering data into the system... such as entering products, etc. I
> also want to use a webbased interface for retrieving the same data...
> and building reports and such.
PHPadmin has already been mentioned, also you might check out MySiteMaker
for automatically generating simple cgi scripts.
http://www.itlab.musc.edu/mySiteMaker/
Andreas
--
Andreas Mattern andreas.mattern at ikm.uni-karlsruhe.de
Institut fuer Keramik im Maschinenbau Uni Karlsruhe
"I've seen things you newbies wouldn't believe. Attack-lusers aflame off
the shoulder of rec.arts.sf.written. I watched Cancel posts glitter in the
ether near the waikato.ac.nz gateway. All those moments will be lost in
time - like beers in the rain. Time to unsubscribe."
(by: snark^ < jabberwocky@deepinthetulgeywoo
k.com> )
|
|
|
|