Access database file

[Kalyan]

Hi,
I have created a small database using access. Can anyone
tell me how to make it into an executable file so that i
can have the main form set as a first interface of the
system for the user. i have split the database and made
it into an .mde file but i am unable to understand how to
make a user interface so that the form could be opened
without opening the access software.

 

[Ken Snell [MVP]]

Only way to do this is to purchase the Developer edition of ACCESS and use
it to create a runtime version of ACCESS, which you then install on the
user's PC so that the user can run your software without having to have
ACCESS software on the PC.

 

[John Vinson]

Hi,
I have created a small database using access. Can anyone
tell me how to make it into an executable file so that i
can have the main form set as a first interface of the
system for the user. i have split the database and made
it into an .mde file but i am unable to understand how to
make a user interface so that the form could be opened
without opening the access software.

That's reasonable, because you CANNOT open an Access database without
the Access software. An Access database cannot be made into an
executable; it's simply not designed that way.

What you can do is purchase the "Visual Studio Office Toolkit" (the
current name, if I recall aright, for what Microsoft used to call the
Access Developer's Edition). This lets you distribute a runtime
version of the Access software, royalty free, which can be used with
your database.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[MacDermott]

I'm not sure if this is what you're asking, but it's not necessary to create
an executable to have a form open immediately when you start the database.
From Tools - Startup, you can select a startup form.
Once that's selected you can, for example, double-click on your mdb (or mde)
file in the windows explorer, and it will open and display your form
immediately.
Please note that your form will still open in Access; that will be true
even if you use a run-time edition of Access, produced with the Developer
Edition, as suggested by some other posts.

HTH