Is there a free Frontend for MSAccess databases?

[sridharavijay]

Hi,
Is there a free front end GUI for MS Access databases. I've seen "Access Frontend" which is a shareware.
Thanks
Vijay S

[pnish]

VB6 comes with a free front end to Access called Visual Data Manager (visdata.exe). I don't know whether you're allowed to re-distribute it though.

[sridharavijay]

I'm looking for something which allows me to create Databases, tables etc. in Access format. and I need this on .Net so not sure if visual datamanager is available in it.
Thanks
Vijay S

[pnish]

VisData allows you to do all that. I don't know whether it comes with .Net though.

[BrianHawley]

You can create a database in code:

Sub CreateDatabase()
 
  'Select Microsoft DAO 3.6 Object Library in Project References
 
  Dim ws As Workspace
  Dim DB As Database
 
  Set ws = DBEngine.Workspaces(0) 'set the DB engine workspace
  Set DB = ws.CreateDatabase(App.Path & "\MyDatabase.mdb", dbLangGeneral)
  DB.Close
  ws.Close
  Set ws = Nothing
  Set DB = Nothing
 
End Sub

[BrianHawley]

And you can create, delete and manipulate tables:

(Open the DB first of course)

DB.Execute "CREATE TABLE [Results] ([Exam code] TEXT(50),[Examinee number] TEXT(50),[Key code] TEXT(50),[Answers] TEXT(255),[Results] TEXT(255), [Right] INTEGER, [Wrong] INTEGER, [Missed] INTEGER);"
  DB.Execute "ALTER TABLE [Results] ADD COLUMN [Missed] INTEGER;"
  DB.Execute "ALTER TABLE [Results] ADD COLUMN [Spoiled] INTEGER;"
  DB.Execute "ALTER TABLE [Results] ADD COLUMN [Percentage] DOUBLE;"
  DB.Execute "ALTER TABLE [Results] ADD COLUMN [Pass percentage] DOUBLE;"
  DB.Execute "ALTER TABLE [Results] ADD COLUMN [Passed] YESNO;"
  DB.Execute "CREATE INDEX [Exam code] ON [Results] ([Exam code]);"
  DB.Execute "CREATE INDEX [Examinee number] ON [Results] ([Examinee number]);"
  DB.Execute "CREATE UNIQUE INDEX [Exam Examinee] ON [Results] ([Exam code],[Examinee number]);"

[Hack]

I'm looking for something which allows me to create Databases, tables etc. in Access format. and I need this on .Net so not sure if visual datamanager is available in it.
Thanks
Vijay S

Moved from ClassicVB.

[BrianHawley]

Not sure why this thread was moved to .Net, but my code suggestions were VB6 since that was the original forum of posting.

[mendhak]

Why not just open the MDB in MS-Access? (If that's what you have)

[sridharavijay]

Why not just open the MDB in MS-Access? (If that's what you have)

Hey! I don't have Licensed version for M S Access!

[jmcilhinney]

Frankly, this isn't a VB6 or VB.NET question. If it was, the question would be how can I create a front-end for MS Access. In VB.NET, you can use ADOX to create the Access DB and then ADO.NET to execute commands to create the tables, etc.

[RobDog888]

Moved to Office Development.