Is there a free Frontend for MSAccess databases?

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

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.

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

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

You can create a database in code:

VB 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

And you can create, delete and manipulate tables:

(Open the DB first of course)

VB Code:

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]);"

Quote:

---

Originally Posted by 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

---

Moved from ClassicVB.

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

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

Quote:

---

Originally Posted by mendhak

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!

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.

Moved to Office Development. ;)