RE: RE: Info Needed to Promote MySQL!!

2001-09-26 Thread Adam Douglas
e least limit your control. > -Original Message- > From: mysql-digest-help [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 24, 2001 6:08 PM > To: venu; turner; mysql > Cc: adouglas > Subject: RE: RE: Info Needed to Promote MySQL!! > > > > As a quick note

RE: RE: Info Needed to Promote MySQL!! - Solved

2001-09-25 Thread Adam Douglas
> What I did to handle global changes was have one access file on the > fileserver that everyone had a shortcut to. That way the updates > were global since they were all to the same file. How is the speed of running Queries, Forms and Reports from Access using linked tables to MySQL? I've found

Re: Info Needed to Promote MySQL!!

2001-09-25 Thread Frank Fisher
Adam Douglas wrote: > 1. Replication between 2 sites via the internet over a VPN or just using a > secure connection. Chapter 11 in the manual (p. 354 of the PDF). You're set. SSH will get you the secure connection. > 2. Transaction processing capabilities with the ability to roll-back a >

Re: RE: Info Needed to Promote MySQL!! - Solved

2001-09-24 Thread David Turner
What I did to handle global changes was have one access file on the fileserver that everyone had a shortcut to. That way the updates were global since they were all to the same file. Dave On Mon, Sep 24, 2001 at 04:19:55PM -0600, Adam Douglas wrote: > > Another small research in Access made me t

RE: RE: Info Needed to Promote MySQL!! - Solved

2001-09-24 Thread Adam Douglas
> Another small research in Access made me to see the changed > table structure > completely. Please use this procedure to view or to refresh > links when the > structure or location of a linked table has changed. > > 1. Open the database in access that contains links to tables. > 2. On the Too

RE: RE: Info Needed to Promote MySQL!! - Solved

2001-09-24 Thread Adam Douglas
> Another small research in Access made me to see the changed > table structure > completely. Please use this procedure to view or to refresh > links when the > structure or location of a linked table has changed. > > 1. Open the database in access that contains links to tables. > 2. On the Too

Re: RE: Info Needed to Promote MySQL!! - Solved

2001-09-24 Thread David Turner
uglas [mailto:[EMAIL PROTECTED]] > > Sent: Monday, September 24, 2001 2:43 PM > > To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; Mysql@Lists. Mysql. Com > > (E-mail) > > Subject: RE: RE: Info Needed to Promote MySQL!! > > > > > > > >

RE: RE: Info Needed to Promote MySQL!!

2001-09-24 Thread Adam Douglas
> As a quick note, I tried the same with MS SQL Server through > its latest ODBC > driver by adding the new column, and I couldn't see any changes in the > linked tables from Access 2002. > > So it shows clearly that, its some thing related to MS > Access, not with the > driver. It might be a b

RE: RE: Info Needed to Promote MySQL!! - Solved

2001-09-24 Thread Venu
California, USA <___/ www.mysql.com > -Original Message- > From: Adam Douglas [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 24, 2001 2:43 PM > To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; Mysql@Lists. Mysql. Com > (E-mail) > Subject: RE: RE: Info Nee

RE: RE: Info Needed to Promote MySQL!!

2001-09-24 Thread Venu
s. Mysql. Com (E-mail); David Turner > Subject: Re: RE: Info Needed to Promote MySQL!! > > > I was never able to see the changes in table structure with > Access and Oracle unless I manually added the column to linked > table in Access after I had added it in Oracle. > > Dave &

Re: RE: Info Needed to Promote MySQL!!

2001-09-24 Thread David Turner
I was never able to see the changes in table structure with Access and Oracle unless I manually added the column to linked table in Access after I had added it in Oracle. Dave On Mon, Sep 24, 2001 at 02:34:30PM -0700, Venu wrote: > Hi Douglas and David !! > > > I have the following setup... > >

RE: RE: Info Needed to Promote MySQL!!

2001-09-24 Thread Adam Douglas
> > Now I've found when I do changes to a table schema the > changes are not > > entirely at least reflected in a the same table linked in Access. > > I had once > > case where I changed a data type on one of the columns and > that data type > > was not changed on the linked table in Access. I h

RE: RE: Info Needed to Promote MySQL!!

2001-09-24 Thread Venu
Hi Douglas and David !! > I have the following setup... > > - MySQL 3.22.32 on OpenBSD v2.9 > - MyODBC on Windows '98 SE > - MS Access 2000 > Cool !!! > Now I've found when I do changes to a table schema the changes are not > entirely at least reflected in a the same table linked in Access.

Re: RE: Info Needed to Promote MySQL!!

2001-09-24 Thread David Turner
I've had the same issues. I have really avoided the dev side of things for some time so I'm not sure whether there's a way around it. Mainly just devoting myself to administration. Funny though I'm starting to write jsp stuff to monitor the databases more effectively. I agree with you on the MYO

RE: RE: Info Needed to Promote MySQL!!

2001-09-24 Thread Adam Douglas
> What type of schema do mean here ? Because as you know, MySQL doesn't > explicitly supports any schema's except the catalogs( in MySQL term > 'database'). If you can elaborate what exactly the problem > you are facing, > then we can provide a rapid solution. > > Also, as for as I know, when I

Re: Info Needed to Promote MySQL!!

2001-09-24 Thread Sergei Golubchik
Hi! On Sep 24, Adam Douglas wrote: > > my main concern is to find a Windows MySQL GUI Client that will do everything > in a similar fashion as Access. If I'm not mistaken you can just continue to use Access as a GUI and for rapid prototyping, connecting it to MySQL via ODBC. Regards, Sergei -

RE: Info Needed to Promote MySQL!!

2001-09-24 Thread Adam Douglas
>> Now I have quite a bit of information on all these questions.. my >> main concern is to find a Windows MySQL GUI Client that will do everything >> in a similar fashion as Access. I believe we would need the >> basics but also >> including visual query builder and reports. I've recently fou

RE: Info Needed to Promote MySQL!!

2001-09-24 Thread Venu
Hi > Now I have quite a bit of information on all these questions.. my > main concern is to find a Windows MySQL GUI Client that will do everything > in a similar fashion as Access. I believe we would need the > basics but also > including visual query builder and reports. I've recentl

Info Needed to Promote MySQL!!

2001-09-24 Thread Adam Douglas
Hi. I'm looking for any support/help that one is willing to give to assist me in convincing the company I work for to switch over to MySQL as there sole database system. We currently use MS Access which we all know is a some what to be desired database. I have to answer the following quest