[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 173
  • Last Modified:

engine::access instead of vb!!!!!!!!!!

is there any possible way to create an app in MSaccess and then distribute to clients WITHOUT them having the MSaccess engine to run it???
is it at all possible?!?!?!?!?!?

2 Solutions
Not possible, you have to make a vb Front and connect it to your access database. This way it only requires
( MDAC Microsoft Data Access Components ) instead of MS Access.

Salim FayadCommented:
I understand that u want to build a data base on the MSaccess, and then, the user can only access this database from the vb application?? is this what do u want? If so, it's easy.
all u have to do is to build your database on the MSaccess, and then on your vb project, u can use the data control to connect your fields to your vb form
archekryptAuthor Commented:
i understand that, but i've got a client @ the mo, and thery're just driving me crazy!!!!!
their work is bloody rediculouse, and i'm feeling V.under pressured by vb @ the mo, i am however a vb programmer, and all my apps are made in vb (now changing to vb.net), but, still, I have sumthing in access(for sum f'ed up reason i don't even understand) and i would like to give them that, but they are a "large" company but they don't have msaccess and i would love to just give them this ****, blame any bugs on microsoft and then be happy, 'cause they're a crappy company, and if i give them access, then they're probably find ANOTHER way to crap everyone out with!
so if i can access this program WITHOUT access, and without having to build a frontend in vb, then COOL!
otherwise, I BETTER GET CODING!!!!!!!!!!!!!

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Yes it is possible for your clients to run Microsoft Access applications even if they dont have Microsoft Access on their machines. When you have created your application create a Deployment Package with PWD and distribute your  database, EXE and dependent DLL's along with MDAC 2.7 Refresh and Jet40SP3_Comp.exe.

MDAC 2.7 Refresh is the lates MDAC package that can be downloaded from Microsoft: http://www.microsoft.com/data/

MDAC Refresh has stopped supporting Access so you will also need to install Jet40SP3_Comp.exe that can be downloaded from the same link.  
[aelatik] is correct if you have more than just a database in Access.  Everything else (forms, reports, etc.) requires use of Access code to operate which means using the Access runtime.  I have a VB program that uses Access reports but it still requires the Access runtime to operate.  Only way to get the runtime is to install Access.

Sorry.  'Guess you better get coding <grin>.
archekryptAuthor Commented:
oh well, @least i've already started...

thanx guys!
Hi archekrypt,
This old question (QID 20563491) needs to be finalized -- accept an answer, split points, or get a refund.  Please see http://www.cityofangels.com/Experts/Closing.htm for information and options.
Recommendation: Split points between  The_eagle & aelatik
Split between The_eagle and aslatik.

EE Moderator

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now