Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 25th, 2005, 11:58 AM
Registered User
 
Join Date: Dec 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Run ACCESS Aplication Without Opening ACCESS

Hello Everybody:

This is my first post in this forum. I have a quick question about ACCESS 2002/2003.

I have developed this small database application for a single user and I want to run this application without opening the ACCESS. As when we double click the .mdb file it launches the application by opening the ACCESS with it.

I will appreciate that if someone could please suggest me how to go around this problem. I thank everyone in advance.



 
Old December 25th, 2005, 12:48 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

Hello,

You can't read or write to a .mdb file unless you have a version of Access (MSACCESS.exe) running on your system. You have two options:

1. run your .mdb in a fully-enabled version of MSACCESS.exe (your standard Access installation), or

2. run your .mdb in a partially-disabled version of MSACCESS.exe (the Access "run-time" version).

For more details on what the Access run-time version is and how to get it, see:

http://p2p.wrox.com/topic.asp?TOPIC_ID=16590

Access can't compile a .mdb to a Win-32 portable executable file.

HTH,

Bob

 
Old December 27th, 2005, 08:24 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

You can use VB or some other programming language for the front end as well, but it will still launch the ACCESS.EXE process when you access the data.

If you just want to store data and do all of your functions in a programmed front end, you have many options for storing your data besides Access.

It sounds like you have done something like this and want to use Access for the data storage component. If you are running Access from an EXE that you created in a programming language, then Access will run but won't actually appear on the screen. You might also consider MSDE or SQL Express for the back end for this type of solution.

HTH

mmcdonal
 
Old January 2nd, 2006, 12:13 PM
Authorized User
 
Join Date: Oct 2005
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Figgis
Default

mmcdonal,

I was sure that VB has it's own version of the Jet engine and would therefore be able to access data from an Access DB without the need to have Access on the machine.

Kamal,

I would say you best solution would depend on why you dont want to open Access. If it is just to stop the user from accessing the tables dirrectly and from making changes then you can lock the DB down by making it an MDE application. I would recomend that you keep an unchanged copy first tho because once you convert a file to MDE you cant make changes to it.

Figgis





Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening another instance of Access with VBA dlamarche Access VBA 5 November 20th, 2006 11:22 PM
opening an Access table from VB6 dartcoach Access 32 December 24th, 2005 03:01 AM
Opening Project from Access ozPATT Access VBA 0 December 8th, 2005 06:03 AM
Opening Excel from Access Sach Access 3 June 22nd, 2004 10:34 AM
Cannot make connection after opening Access doonman Classic ASP Databases 2 September 29th, 2003 08:42 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.