|
Does anyone know of a drop-in replacement for an access database, ideally open source. A group I work with occasionally is looking for a replacement database where they'll need to change as little actual SQL as possible. Their app is VB6/COM.
Started by Nerdfest on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
But it is free and open source :o)
OpenOffice.org offers a free open source access database "Access....
I tried it out either.
You can look at OpenOffice Base.
To change any of the queries that use MS Access functions.
|
|
I dont have microsoft access but would like to open an mdb file, is there any way to do this?
the mdb file contains SQL code that i need. it is just a file that connects to a remote database. i need to view the sql code
i did try openoffice base, but ...
Started by every_answer_gets_a_point on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
You might also want to check out FlySpeed SQL Query, which can query all kinds of databases "on the fly"
Have you tried openoffice....
Visual studio is able to view and modify access databases via its datasources features.
|
|
Is there a way to do this with SQL Server tools? If not, is there a 3rd party tool that does this? There doesn't seem to be a good way to edit longer text columns in the SQL Server Managers for SQL Server 2000 or 2005. While SQL Server Manager is really...
Started by Michael Pryor on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
(Although I have pointed Access to my next look at linking....
Generally, SQL Management Studio is an administrative tool for your database and not meant for data be entered by an application that uses the database for persistence.
|
Ask your Facebook Friends
|
Background: We have an old (but business-critical) SQL Server database with an MS Access ADP front-end; this was originally upsized to SQL Server from a series of Access databases.
This database tracks hazardous materials for our customers, and stores...
Started by Keith Williams on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
You can write app in .NET to export image from Access database
I think the reason your database becomes so bloated....
Your backup fields.
If you converted it from the 600+GB storage of SQL Server to Access 2007 accdb format.
|
|
I have been asked to create a graphical representation of our database, I have looked at tools such as, lucidcharts . Are there any good tools that I can use to graphically represent the database and it's relationships?
Started by Unkwntech on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
It depends on the database brand, for example, the SQL Management Studio has a meansIf you're using MySQL then....
If you're using "Microsoft Office Access, Microsoft SQL Server, and other databases to generate models.
|
|
I'm looking for a database visualization tool for OS X. MySQL Workbench looks promising, but the binaries provided are Intel only and I haven't been able to get the source to compile on PowerPC yet. Are there any other database visualizations tools out...
Started by mgriepentrog on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
It has an SQL editor, database browser, query builderI use Sequel Pro....
I use RazorSQL.
I haven't tried for MySQL, but there' is a Mac version .
I use Navicat to access our Postgres and Oracle.
Of database management apps.
|
|
Consider the need to develop a lightweight desktop DB application on the Microsoft platforms.
It could be done fairly easily with MS Access but I'd like to be able to distribute it to others and I don't want to pay for a runtime license.
Requirements:...
Started by Onorio Catenacci on
, 29 posts
by 24 people.
Answer Snippets (Read the full thread at stackoverflow):
They....
If you want to build a web site, you really need a database server engine, like MS SQL, MySQL for Access a lot of people only think about the database, but what people are really asking about are all the other features.
|
|
Do you have any tricks for generating SQL statements, mainly INSERTs, in Excel for various data import scenarios?
I'm really getting tired of writing formulas with like
="INSERT INTO Table (ID, Name) VALUES (" & C2 & ", '" & D2 & "')"
Started by David Vidmar on
, 9 posts
by 9 people.
Answer Snippets (Read the full thread at stackoverflow):
Here's a quick example:
INSERT INTO [ODBC;Driver={SQL Server};SERVER=MYSERVER;DATABASE into ",a1,"(",b1,")....
Access) SQL? This requires an ACE/Jet which could be another Excel spreadsheet.
To the source using ACE/Jet (a.k.a.
|
|
I have just started Database Basics, so I dnt know much about this field. My teacher said that Sql Queries are Case Insensitive and he was using Ms-Access and Oracle, he showed us on both by writing some simple queries and I saw that queries were running...
Started by Bhujang on
, 12 posts
by 5 people.
Answer Snippets (Read the full thread at openoffice):
So their assertion of case database, you can then ....
Cite says
We are using MS Access and SQL Server 2000 and we do not have to put a semicolon after each SQL statement, but some database programs force you to use it.
|
|
Are there any alternatives to MS Access?
Requirements:
Portable Database file Integrated form development for data entry No compiling necessary. Can be modified on the fly.
Two more requirements:
Available for Linux or Windows Does not have to be free...
Started by lamcro on
, 12 posts
by 12 people.
Answer Snippets (Read the full thread at stackoverflow):
SQLite is great because:
It's just a library to be called by your application, not a server... .
However you can use MS-Access in conjunction with another Database a form creator as it's just a database.
Standpoint it's hard to beat.
|