Is there any solution to make Access database project as a standalone executable program?

I need to make my program stand alone and able to communicate with access?
How do i make a program stand alone?
is there a special way to make sure it can stand alone and still connect with access,
crewcrossAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:
<<Can a program communicate with access if its stand alone and no longer associated with visual studio?

user interface is in visual studio written using vb. program will be stand alone i.e. not used in visual studio, user will only interface with the program.>>

  "Access" is really composed of three parts:

1. A User Interface for working with Access specific objects, such as forms and reports, and that works with a database engine, which by default is JET.

2. Coding language - VBA

3. A database engine; which by default is JET.

  Based on your description, your simply using JET to store data.  That being the case, there is no need to talk about "Access".  JET can be used independently of Access.  The only reason you would need to use Access itself is if you wanted to use Access specific objects, such as a report.  You can do that through OLE automation.  

<<the goal of the program is to generate data and send data to access / get data from access manipulate it, add more data and send it back to access.

its a statistical program with all calculations being done using vb.>>

  Then no need for Access.  Your simply using JET to store data.

  Be aware that JET has a 2GB limit per DB.  You can work around that to some extent (by putting one table in each DB), but if your DB will be larger then 2GB, I would suggest using SQL server as a datastore.

JimD.
0
 
bloxsomeCommented:
first Save a copy of your mdb file in another directory (Back up)
then Open Access with no db, Choose Convert to MDE and select the database you want to use. This should create an executable MDE file. It will only display forms and reports. I am not sure if it will reconnect up without doing something special. You might need to modify something i am not aware of. Hope some of this might help.
0
 
peter57rCommented:
There is no facility to convert and Access database into an .exe file.

However I don't really understand what you are trying do.
And definitely don't know what you mean by..
"it can stand alone and still connect with access,"

If you can explain what you trying to achieve, it might be possible to suggest an approach, such as using the Access runtime program.  
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

 Is your user interface writen in Access or something else and your simply using JET as a datastore?

JimD.
0
 
crewcrossAuthor Commented:
Can a program communicate with access if its stand alone and no longer associated with visual studio?

user interface is in visual studio written using vb. program will be stand alone i.e. not used in visual studio, user will only interface with the program.

the goal of the program is to generate data and send data to access / get data from access manipulate it, add more data and send it back to access.

its a statistical program with all calculations being done using vb.

0
 
crewcrossAuthor Commented:
i get that you can make access an mdb file and use the database, i want to know how to communicate back and forth with access, (user has to have access) with the stand alone program.

can u setup a connection with linq to access?
0
 
peter57rConnect With a Mentor Commented:
So does your question boil down to 'how do i connect to an access database from vb.net?'
If so then enter
'connect to access from vb.net'
in the search box at the top right of the EE screen and you will get hundreds of examples.

If you are only using an mdb for your data store and there is no Access UI involved, then you don't need a copy of Access anywhere for this connection.
If the database structure is being maintained by an Access user then obviously they will need a Access on their machine to do that.
0
 
crewcrossAuthor Commented:
im getting the big picture better now thank you, the user will have access on their computer and the stand alone program should be able to connect to Access* and access the data, manipulate and send it back.

will data connections with access written in vb still work wiith access when it becomes stand alone.
0
 
peter57rCommented:
Yes
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.