Ms Access Equivalent????
 

Im in a SQL class and was wondering what could I use in place of MS Access. It would need some sort of gui with it as well.

Thanks,

Graystarr

The short answer is there isn't one. Accept maybe dbmaker? Search google for dbmaker

A better answer is forcus you time and effrorts working
with client/server databases like MySQL & PostgreSQL.

Learn to work with command inferface SQL, Perl, PHP t those those are the marketable skills

MS ACCESS EQUIVALENT
 

Will postgresql import into access?????? The reason is that the school uses access but I just got rid of my winblows and am using RH 7.3 at home now.


Thanks

Well you could use ODBC to connect to it I suppose.
RH comes with Postgresql . The learning curve is a little
longer with PostgreSQL than MySQl. Your could use someting like PhpMyAdmin to submit SQL manage the DB
and export data into a format that could be inported into
MS-Access

BTW, You can download MySQL for Window also.

Support MySQL is beyond the scrope of this forum.
I would suggest reading a couple of tutorial, doc
and posting to dB specific mailing-list

Postgres *will* work with access
 

I do it daily.

Use either the ODBC driver or grab the win32 postgres driver. (google it out)

Install it on to the computer with Access, either as a user store or machine store, depending on whether you just want your user to have access to postgres databases or any user.

Now set it up. Make sure Postgres is running with -i (allow inet connections) and that you give some kind of access in pg_hba.conf. There are man pages and examples in the file to follow.

On the Win32 side, make sure that you UNCHECK read-only (there are two checkboxes for this in different tabs. Why I have no clue) - now give the IP and user info and database info.

When all of that is done you create a new database in Access (just a blank one) and then File/Get External Data. You can either link it or copy it. I suggest linking, because if you copy you will now have two copies of the data on Postgres: one in Postgres and one in Access and they will NOT synchronize.

Nothing to it. Have fun.