Re: [mv] MS ACCESS, ODBC, MySQL and update table?

["Ken Diliberto" <Ken@kdmd.net>]

******    message to minivend-users from "Ken Diliberto" <Ken@kdmd.net>     ******

I installed MySQLODBC (I think that's what it's called) on my Windoze
machine and configured it to use the test_minivend database.  There are
a few things you need to do to get MySQL to allow access to the
database.  This has to do with permissions, which you should look at the
docs for since I don't understand it well enough to repeat accurately.

I don't know what you mean by 'offline mode' so I can't comment on it.

I'll check on the NoImport option to see if that is my problem.  I have
not done anything like that so it may be.

If I can be of more assistance, mail me back.

>>> Hans-Joachim Leidinger <jojo@buchonline.net> 04/05/00 02:57PM >>>
******    message to minivend-users from Hans-Joachim Leidinger
<jojo@buchonline.net>
    ******

> ******    message to minivend-users from "Ken Diliberto"
<Ken@kdmd.net>
    ******
> 
> I am able to do it but have a different (maybe) problem.

You are able to use ms access to insert, update, delete any data via
odbc in a table of MySQL? 
In offline mode too?
Please, let me know! :-)))

(To Paul: I will subscribe to the sql maillist, if a stupid stubborn
redneck with a stronge stomach can't find a solutions by itself. ;-) 
)

 
> Minivend does not recognize the changes I make to the database until
I
> go into Minimate and edit the records I have changed/added and
export
> them.  I don't think I have to change them in Minimate, just make
sure
> they are exported.  I'll have to do it again to make sure I know
what
> I'm talking about.  :-)

Oh? I can't understand this. Any changes in a table of any SQL will be
effect immediately. Maybe something is wrong in your catalog.cfg?
Maybe
you have not set "NoImport" right?

> Are you able to get that far?

Hmmm...do you mean, whether i'm able to get all changes in my database
as soon as possible in my minivend?
No! It is minivend! Minivend is able to get the newest data, if the
catalog.cfg is right. ;-))


> Take Care

Ahemmm?! If this thread about "ms access" is off topic, email me
directly!

Regards,

	Joachim

-- 
-------------Hans-Joachim Leidinger---------------------


-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead,
send
email with 'UNSUBSCRIBE minivend-users' in the body to
Majordomo@minivend.com.
Archive of past messages:
http://www.minivend.com/minivend/minivend-list
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list