Using Access databases, with out access

Does any one know of a free Access database editor?

Quote:

---

Originally Posted by dclamp

Does any one know of a free Access database editor?

---

Take a look at THIS

i dont download from that site. McAfee gives it a Red "SiteAdvisor" rating.

notepad and VBscript .... ;)

Quote:

---

Originally Posted by dclamp

i dont download from that site. McAfee gives it a Red "SiteAdvisor" rating.

---

Sorry :blush:, I just did a quick google search and that is what I came up with.

i just tried this and it works.

http://www.alexnolan.net/software/mdb_viewer_plus.htm

Quote:

---

Originally Posted by rory

i just tried this and it works.

http://www.alexnolan.net/software/mdb_viewer_plus.htm

---

I could not figure out how to do anything with it. It gave me tons of errors

Quote:

---

Originally Posted by dclamp

I could not figure out how to do anything with it. It gave me tons of errors

---

There's no installation required, it just runs.. were you able to run the program and open a database?

It does need MDAC installed (Microsoft Data Access Components)
http://www.alexnolan.net/runtime/

I belive i have that. I think i just need to add tables. how do you do it with that program?

never used it before .. looks like it wont do that :-(

well thats retarted. it doesnt even create the tables

looks like something worth creating in VB and selling .. :D
creating the tables are easy enough, well actually all the code is easy.

You dont need Access in order to create/modify databases. Use SQL statements.


Moved

Hey! move it back. I want it in chit chat!

But its of a serious topic, unless you do want members to hack it apart and post garbage and stuff?

It's serious and about a non-VB related product.....it belongs in General PC

It could go either way but definately shouldnt be in CC IMHO.

It's gone more off topic now than it would have in either forum. :confused:

Anyway, I don't think you can edit Access databases without Access. Sure you can use SQL but you have to have a DBMS to intepret and execute the SQL commands.

It depends on the Access file format. Which I know nothing about.

Unless you are talking about Access 2007, 2003 and before are all a proprietary binary file format. 2007 uses a compressed xml file format.

... and no it hasnt PG :)

You can do just about anything without having Access installed. There are two methods to do this. One is purchasing a runtime license for the Access GUI and the other will be to have your program create/modify the database/objects with sql statements. No need for a DBMS here.

Yes but - how do you interface with the databases?

Does it work with only the data access drivers, like ODBC? I always thought it required Access to be installed as well.

No, just MDAC and to make programming a little easier you could create a blank database with some empty tables already defined. Then its just managing and stuff vs. having to execute all the sql create statements.

You wont have an Access GUI unless you have purchased the license from MS.

OK, fair enough. I guess I am used to server-based DBMSs.

Is the SQL subset the same as SQL Server?

No, for Access 2000 and before the language is ANSI T-SQL 89. Access 2002 and above also uses T-SQL 89 but optionally you can set the standard to T-SQL 92 but may cause incompatibilites on any pre-existing queries written in 89. Now if you write them after the standard is changed then there will be error messages if they are not correct to the 92 standard just like under 89.

create Access DB in VB6 .. dont know how to just create a table, though im sure its as simple.

VB Code:

Dim cat As ADOX.Catalog
    Dim tblNew As ADOX.Table
    Dim idx As ADOX.Index
    Set cat = New ADOX.Catalog
    '// CREATE DATABASE
    cat.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\myfile.mdb;" & _
                "Jet OLEDB:Database Password=mypass; Jet OLEDB:Encrypt Database=True;"
    Set tblNew = New ADOX.Table
    '// CREATE TABLE
    With tblNew
        .Name = "Table1"
        .ParentCatalog = cat
        .Columns.Append "Table1_Id", adInteger                      ' NUMBER FIELD
        .Columns("Table1_Id").Properties("Autoincrement") = True   
        .Columns("Table1_Id").Properties("Increment") = CLng(1)
        .Columns("Table1_Id").Properties("Seed") = CLng(1)
        .Columns.Append "Table1_Field1", adVarWChar, 255            ' TEXT FIELD
        .Columns.Append "Table1_Field2", adVarWChar, 255            ' TEXT FIELD
        .Columns.Append "Table1_Field3", adInteger                  ' NUMBER FIELD
    End With
    cat.Tables.Append tblNew
    Set idx = New ADOX.Index
    '// SET PRIMARY KEY
    With idx
        .Name = "PrimaryKey"
        .Columns.Append "Table1_Id"
        .PrimaryKey = True
        .Unique = True
    End With
    tblNew.Indexes.Append idx
    Set idx = Nothing
    Set cat = Nothing

http://www.vbforums.com/showthread.p...97#post2509697

Quote:

---

Originally Posted by RobDog888

No, for Access 2000 and before the language is ANSI T-SQL 89. Access 2002 and above also uses T-SQL 89 but optionally you can set the standard to T-SQL 92 but may cause incompatibilites on any pre-existing queries written in 89. Now if you write them after the standard is changed then there will be error messages if they are not correct to the 92 standard just like under 89.

---

Thanks. :thumb:

Quote:

---

Originally Posted by dclamp

Hey! move it back. I want it in chit chat!

---

You already have a very similar thread in CC and its way off topic and a good example of why this thread should not be in CC. ;)


@PG Np, ;)

BTW You can also alter your databse with ADO(x) or DOA as well

Quote:

---

Originally Posted by Dnereb

BTW You can also alter your databse with ADO(x) or DOA as well

---

Well, not with DOA, I hope ;)

You might consider making such a thing yourself. There isn't a really nice way to create PDA based SQLServerCE databases, so I wrote a class that creates the database, and the tables. Whenever I want to create a new database, I take that class, modify the SQL statements to create the new tables I want, with the new fields I want, create a one button app with an instance of the class, press the button, and presto, instant database. The same thing could be done for Access, and it would be easy enough to turn that into a standalone DB creator with custom interface allowing you to create fields, assign keys, etc. Which, in fact, is all that Access is. Not a database, just a database creation/management front-end.

Quote:

---

Originally Posted by RobDog888

You already have a very similar thread in CC and its way off topic and a good example of why this thread should not be in CC. ;)


@PG Np, ;)

---

This is a good way to start a discusion on Access. That is why i want it there. haha i just made that up :p I dont really care. i am just trying to pull you leg.