BASE front - MyODBC - MySQL back

Paulchen · Newbie Joined: 01 Aug 2007 Posts: 2

Tried to set up a database in Windows with BASE as front and MySQL as back end via MyODBC driver. The data stored in MySQL can be edited in BASE but not changed or deleted.
It is not possible in BASE to change access rights in Tools/User Administration. The tables in MySQL all have Primary keys and the InnoDB engine is used.

Surprisingly it is possible to create a new table through BASE in MySQL, but after reopening it, the same problem occurs.

What is wrong with it? Is it a bug or can I do something to make it working? Rolling Eyes

It works fine with MSAccess. When linking the tables, Access asks additionally for the tables and fields in the tables.

Is it better to go with PostgreSQL since they offer a special (beta-)driver for BASE?

Tx in advance

Paulchen · Newbie Joined: 01 Aug 2007 Posts: 2

Will try this: Wink

http://blogs.ittoolbox.com/database/soup/archives/filemaker-replacement-found-18042?ref=http%3A%2F%2Fwww%2Eplanetpostgresql%2Eorg%2F

DrewJensen · Posted: Wed Aug 15, 2007 5:56 am Post subject:

Paulchen,

Thanks for that link - I just got done reading over the mail list entries and the installation documentation. It looks interesting, I think I will have to give this a try also.
_________________
Blog - http://baseanswers.spaces.live.com/