LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 07-08-2002, 07:09 PM   #1
graystarr
Member
 
Registered: Dec 2001
Location: Layton, Utah
Distribution: Red Hat 8.0 and Mandrake 9.0
Posts: 85

Rep: Reputation: 15
Talking 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
 
Old 07-08-2002, 07:19 PM   #2
pickledbeans
Member
 
Registered: Jun 2002
Location: Bailey, CO
Distribution: Slackware
Posts: 483

Rep: Reputation: 31
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
 
Old 07-08-2002, 07:44 PM   #3
graystarr
Member
 
Registered: Dec 2001
Location: Layton, Utah
Distribution: Red Hat 8.0 and Mandrake 9.0
Posts: 85

Original Poster
Rep: Reputation: 15
Talking 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
 
Old 07-08-2002, 08:39 PM   #4
pickledbeans
Member
 
Registered: Jun 2002
Location: Bailey, CO
Distribution: Slackware
Posts: 483

Rep: Reputation: 31
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
 
Old 07-09-2002, 08:21 AM   #5
akohlsmith
Member
 
Registered: Apr 2002
Distribution: Slackware
Posts: 114

Rep: Reputation: 15
Thumbs up 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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Access Equivalent djib Debian 2 02-15-2005 11:06 AM
Where can I get bsetbg or an equivalent? SocialEngineer Linux - Software 1 12-05-2004 03:53 PM
Database software, equivalent to Access? nidputerguy Linux - Software 5 01-04-2004 06:54 PM
equivalent to c? codename000 Programming 3 04-03-2003 11:08 AM
MS-Access equivalent.... frkstein Linux - Software 4 06-08-2002 12:00 AM


All times are GMT -5. The time now is 06:29 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration