Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2011-02-23
10
Medium Priority
?
25 Views
Last Modified: 2016-05-15
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,
0
Comment
Question by:crewcross
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
  • +1
10 Comments
 
LVL 1

Expert Comment

by:bloxsome
ID: 34963793
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
 
LVL 77

Expert Comment

by:peter57r
ID: 34963846
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
 
LVL 58
ID: 34965798

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

JimD.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:crewcross
ID: 34966868
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
 

Author Comment

by:crewcross
ID: 34967020
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
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 1000 total points
ID: 34968178
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
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 1000 total points
ID: 34969702
<<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
 

Author Comment

by:crewcross
ID: 34975501
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
 
LVL 77

Expert Comment

by:peter57r
ID: 34977659
Yes
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question