Hi,
Please Please Please anyone out there, if you have a solution, i will highly appreciate as i have searched the internet for 5 days now with no hope.
1st, the versions i am using are Ms Access 2003 & Visual Studio 2005. Problem
I am using a database password on my MDB (using "set database password"). This is just for my basic security to stop basic users from importing my queries (basic user, i know any advanced guy can hack in, but now that becomes a copyright issue). With this, i would like to use VB (.exe) to open the database without asking the user for the password. I have set up the Db so that the user does not have any control to reset the Db password, e.g. disabling shift overide, etc.
So far i have found two sets of code that still do not do what i want;
1.
Dim oAccess As Microsoft.Offic e.Interop.Acces s.Application
oAccess = New Microsoft.Offic e.Interop.Acces s.Application
oAccess.OpenCur rentDatabase(fi lepath:=Db_path , bstrPassword:=" password")
This code works OK but opens the Db with the full version of access, not in the runtime version.....
2.
Shell(PathName: ="""" & ms_access_path & """" & " " & """" & dbpath & """" & " /runtime")
This code opens the Ms Access DB in runtime but i cannot automatically enter the Db password......
What i need basically is to open my password protected MDB/MDE in /runtime without prompting for the password (password defined in the code of my .exe file)
Any assistance in solving this problem is much appreciated.
8 4882
Hi,
Please Please Please anyone out there, if you have a solution, i will highly appreciate as i have searched the internet for 5 days now with no hope.
1st, the versions i am using are Ms Access 2003 & Visual Studio 2005. Problem
I am using a database password on my MDB (using "set database password"). This is just for my basic security to stop basic users from importing my queries (basic user, i know any advanced guy can hack in, but now that becomes a copyright issue). With this, i would like to use VB (.exe) to open the database without asking the user for the password. I have set up the Db so that the user does not have any control to reset the Db password, e.g. disabling shift overide, etc.
So far i have found two sets of code that still do not do what i want;
1.
Dim oAccess As Microsoft.Offic e.Interop.Acces s.Application
oAccess = New Microsoft.Offic e.Interop.Acces s.Application
oAccess.OpenCur rentDatabase(fi lepath:=Db_path , bstrPassword:=" password")
This code works OK but opens the Db with the full version of access, not in the runtime version.....
2.
Shell(PathName: ="""" & ms_access_path & """" & " " & """" & dbpath & """" & " /runtime")
This code opens the Ms Access DB in runtime but i cannot automatically enter the Db password......
What i need basically is to open my password protected MDB/MDE in /runtime without prompting for the password (password defined in the code of my .exe file)
Any assistance in solving this problem is much appreciated.
Try this code:
Dim cn As New ADODB.Connectio n
With cn
cn.Open "Provider=Micro soft.Jet.OLEDB. 4.0; Data Source=app.path & \yourdbasehere; jet oledb:database password=yourpa sswordhere"
End With
Try this code:
Dim cn As New ADODB.Connectio n
With cn
cn.Open "Provider=Micro soft.Jet.OLEDB. 4.0; Data Source=app.path & \yourdbasehere; jet oledb:database password=yourpa sswordhere"
End With
Hello,
Its my Problem also and I Got it Now.
Tnx
Regards
ervin
Hi,
Please Please Please anyone out there, if you have a solution, i will highly.
Can you explain why you want open the DB File Exclusively?
Just wanna share my coding maybe it can help you out:
I do create i DB and Open it as Exclusively for me to put a SecurityPasswor d and my password is "0".
Now my coding in VB6 are as follow:
Function Connect()
Dim ESQL As String
Set CONN = New ADODB.Connectio n
Set CONN = Nothing
MSDatabase = App.Path & ("\DBase\TimeSh eet.mdb")
CONN.Open "Provider=Micro soft.Jet.OLEDB. 4.0; Data Source= " & MSDatabase & ";jet oledb:database password=0"
End Function
Thank you Slapshock
Regards
Ervin
Hi Guys,
Thanks for your assistance but this is not what i want.
I need to open the MDB application, not connect to it. The ADO code you provided just connects to the MDB.
Please go through my original post. My problem is opening the MDB database.
Any one out thea who can help?????
Anyone? HEEEEELP. Awaiting any response.
Solved! Open the mdb exclusively using the /excl parameter in the shell command. Make sure shift-open is disabled in the mbd. Now dynamically link the backend only on startup of the frontend mdb. Now no one can get the the backend cause its got a plain old database pw on it, and its dynamically linked, and you can't shift-reenable it cause its exclusely opened. Please correct me if I'm wrong.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Ben Reese |
last post by:
Hi this is a general windows question as much as .net.
I need to connect to a directory on a UNC path that is on same WAN but a
different domain to the application. The directory is protected by a username
and password.
Trying to access a System.IO.FolderInfo Object with the UNC Path or using a
System.Diagnostics.Process object to shell Explorer passing in the UNC as
the argument results in a Win32Exception "The system cannot find...
|
by: Kelly Bowles |
last post by:
I have made a purchase requistion which I have been asked to put password
protected copy of requestors signature.
I am thinking that each signature will have to be scanned as a picture and
linked by some sort of password .
I wanted to tell them just have everybody sign the documents when it comes
out of the printer.
I was shown that it was done on another form. It was not Access and I was
not allowed to take the form apart.
|
by: Anita Mossey |
last post by:
Is there a way to automatically retrieve passwords with VBA,
preferably with ADO as opposed to DAO?
|
by: MissiMaths |
last post by:
I have used outputTo to export a copy of a table out of access into
excel. I was wondering if there is anyway to set a password on this
within the code so that it is read only in .xls format?
I was also hoping that there might be a away of importing a password
protected excel file into a table in access where the password is
known. I have searched help and can't see anything and also I couldn't
find the answer here as yet. I hope someone...
|
by: GTi |
last post by:
I have small program that always must be running when a user is logged on.
Since users can close this program I must create a program that always check
if this program is running.
So I created a program in C# (my first!!) and it works with one major
problem.
This program detects when the desktop program is not running and starts it
again. All works as expected
BUT
The desktop program is running as a SYSTEM user.
That is not what I...
| |
by: Stanav |
last post by:
Hello all,
I'm writing a program that interacts with databases. I want that when the
users run this program, they can view the data as much as they want. But if
they make any changes to the data and then attempt to update it, the program
will ask for a password. My question is, how can I go about doing this? I
can create a string variable and set it to something for the password, and
then check the user's input against this password value,...
|
by: Kevin Prichard |
last post by:
Hi all,
I've recently been following the object-oriented techiques discussed
here and have been testing them for use in a web application. There is
problem that I'd like to discuss with you experts.
I would like to produce Javascript classes that can be "subclassed"
with certain behaviors defined at subclass time. There are plenty of
ways to do this through prototyping and other techniques, but these
behaviors need to be static and...
|
by: Miro |
last post by:
Why Password protect an MDB when someone can google and get a hack?
Wondering if anyone else has thought of this and just said "oh well"...
I plan to password protect an MDB where I have some system/program variables
and data.
But looking in google, there are plenty of programs a user can download to
hack and crack that password.
|
by: -xx- |
last post by:
Hi,
I am new to c# and just trying out c# with ms access. First problem i
encountered is how do i open up ms access that has password.
Here is my current codes which working fine if there is no password on ms
access:
//Specify sql server-specific connection string
private const string strdns = @"Provider=Microsoft.Jet.OLEDB.4.0;Data
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |