Using Access databases, with out access

[dclamp]

Does any one know of a free Access database editor?

[Mark Gambo]

Does any one know of a free Access database editor?

Take a look at THIS

[dclamp]

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

[rory]

notepad and VBscript ....

[Mark Gambo]

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

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

[rory]

i just tried this and it works.

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

[dclamp]

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

[rory]

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/

[dclamp]

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

[rory]

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

[dclamp]

well thats retarted. it doesnt even create the tables

[rory]

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

[RobDog888]

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


Moved

[dclamp]

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

[RobDog888]

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

[Valleysboy1978]

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

[RobDog888]

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

[penagate]

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

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.

[RobDog888]

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.

[penagate]

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.

[RobDog888]

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.

[penagate]

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

Is the SQL subset the same as SQL Server?

[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.

[rory]

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

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

[penagate]

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.

[RobDog888]

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,

[Dnereb]

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

[Shaggy Hiker]

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.

[dclamp]

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 I dont really care. i am just trying to pull you leg.