Hi,
Is there a free front end GUI for MS Access databases. I've seen "Access Frontend" which is a shareware.
Thanks
Vijay S
Printable View
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]);"
Moved from ClassicVB.Quote:
Originally Posted by sridharavijay
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)
Hey! I don't have Licensed version for M S Access!Quote:
Originally Posted by mendhak
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. ;)