General VB application question

Posted on 2005-04-11
Last Modified: 2010-05-02
Hi Experts,

I have a general question regarding VB application and it may be silly but wanted to make sure with you experts.
If I have a very simple application which has been written in Visual basic and  works with access database.if I install (my VB application and my .mdb file) on a user's computer (which doesn't have Microsoft Access installed) does my VB application works with no problems.?

Really appreciate your comments.

Question by:Tpaul_10
    LVL 52

    Accepted Solution

    As long as the ODBC drivers are installed then yes.  Your app will be able to use the database, the user just won't be able to open the DB directly and tinker with it.

    Hope this helps.
    LVL 1

    Expert Comment


    use vb Package and deployment wizard to package & deploy your application.

    ** Donot forget to add yourdatabase.mdb file manually to the file list & set its Install location**

    :-)  THis will work ..
    LVL 8

    Expert Comment

    carl_tawn is correct. The application will still be able to access the .mdb file. He is correct also in stating that people will not be able to open it directly and use it. He is also correct that the appropriate drivers must be installed.

    HERE is one extra little nugget of information.... You can change the file extension to whatever you like!! VB doesn't care what the file extension is.... As long as you declare your new file extension when building your connection string to the database all will be fine. You can change the extension to .aaa or .xxx and ado will be able to work with it.... If you don't want people messin' with your database file, very few people will ever realize what you did. Actually, they wont even know it IS a database file.

    LVL 8

    Expert Comment

    hehe yeah, thats the first think i do when i get an app like that. I rename the big files to .mdb and try to open them with access, you would be suprised how often that is done.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
    When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
    Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now