Hello,
I have an ADO connection object connected to an external ms access password
protected database. I am trying to execute a delete statement from that
object on a table in my currentdb. Seems strange I know, but I have to do
it this way. My currentdb is NOT password protected. When I execute:
Delete * from table1 IN "C:\abc.mdb "
I get an "Invalid Password" error.
My ado connection object to the password protected database is already open
so I don't think it's that password, and my currentdb has no database
password so I'm a bit confused. Deos anyone know the correct syntax?
Thanks.
Matthew Wells MW****@FirstByt e.net 2  2252 
I'm not the smartest guy for this one, and I've never connected to an
external database to execute a query on the local one (letting you know
up front), but here's something to at least start with:
It almost seems as though your statement is creating a new connection
to try and execute your DELETE statement. Perhaps check to make sure
you don't have more than one ADO connection object referenced?
You may also want to re-check your connection string. http://www.connectionstrings.com has a whole buch of
syntactically-correct connection strings in different permuatations
(i.e. OLE DB connection string with password, without password, with
trusted connection, etc).
I will also be using "Insert Into 'table in local.mdb' Select * from table1
in 'password protected.mdb'" . My connections strings are fine. I have an
ado connection open for my local mdb, it's the syntax to select from the
password protected mdb that's got me stuck.
"Steve" <th*********@gm ail.com> wrote in message
news:11******** **************@ g49g2000cwa.goo glegroups.com.. . I'm not the smartest guy for this one, and I've never connected to an
external database to execute a query on the local one (letting you know
up front), but here's something to at least start with:
It almost seems as though your statement is creating a new connection
to try and execute your DELETE statement. Perhaps check to make sure
you don't have more than one ADO connection object referenced?
You may also want to re-check your connection string.
http://www.connectionstrings.com has a whole buch of
syntactically-correct connection strings in different permuatations
(i.e. OLE DB connection string with password, without password, with
trusted connection, etc). This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Karunakararao |
last post by:
Hi All
I'm using sybase database, I have a binary datatype column in a table, when
I'm trying to store the char(128) value into that, I'm getting syntax
violation error.
If I take "w" as the password its ascii value is 119, when you add +9 to
that, it will be 128. How to insert this value into a binary datatype
column. .
|
by: roamnet |
last post by:
hi
i created database file with .mdf extention ,sql server as a source
and use grid view to display data
there're no problem in data retrieve and display,but i want to edit it
or insert new records
there is an error "Incorrect syntax near '-'.
Must declare the scalar variable "@UserName".
I worked out in design view,code is automatically generated.Iam not
able fix the error.
Iam working with Visual Web Developer-2005 Express Edition
|
by: sharmilah |
last post by:
I have the following code in my script and it's giving a syntax error at line *** when using the password function. My password in the mysql database is encrypted using the password function itself and I want to verify the input password against my database password. PLEASE HELP
if (isset($_POST)) $password = @$_POST;
if (($login != "") && ($password != "")) {
$conn = mysql_connect("localhost", "root", "root");
...
|
by: ewpatton |
last post by:
Good day,
I've been trying to work with SQL and an Access database in order to
handle custom user profiles. I haven't had any trouble reading from my
database, but inserting new entries into it has been troublesome to
say the least.
My ASP.NET script is supposed to execute an INSERT INTO statement in
order to add a user to the database. Here is a sample:
|
by: basswhizz |
last post by:
Hi everyone im a high school student and I'm having trouble with one of my projects could you please help!!
I'm getting this error message.
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting ']' in C:\wamp\www\dwalk96\sign-up.php on line 26
Here is all the code of the file.
<?php
// Connects to your Database
mysql_connect("aldridge3", "root", "") or die(mysql_error());
mysql_select_db("dwalk96") or...
| | |
by: basswhizz |
last post by:
Hi guys im having trouble with somethings else now can you help out thanks!!
Im getting this error message
Parse error: syntax error, unexpected $end
Here's my code cheers!!]
<?php
// Connects to your Database
mysql_connect("aldridge3", "root", "") or die(mysql_error());
mysql_select_db("dwalk96") or die(mysql_error());
|
by: goodguyjam |
last post by:
Hi again. I now get the above error with the exact same code as in my previous question. All I did was to rearrange the lines...no code changes...help!
To assist you experts, line 11 contains this code - header(‘WWW-Authenticate: Basic realm=”secret section”’);
Then when I remove the colon, I get a new error - syntax error, unexpected T_STRING in /home/allummfa/public_html/auth.php on line 11.
This code is supposed to tell the web server to...
|
by: goodguyjam |
last post by:
Hi all,
I'm having trouble with mysql.
I've just finished my php coding for HTTP authentication and with some help am now getting a login window pop up whenever I click on a link on my website that directs to Auth.php.
The code for this is below:
<?php
/* Program: Auth.php
* Desc: Program that prompts for a user name and
* password from the user using HTTP authentication.
|
by: nerd4access |
last post by:
Hello all! I am not new to access, but new to coding (and posting). I have a database that I have created and need some help with a login form. When a user opens the database, a form pops up asking for a username and password. They can choose their name from a combobox and enter apassword into a textbox.
If the default password is entered, another forms pops up asking the user to change their password (this is where my problem comes...
|
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: 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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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.
| |
