|
How to Import data from public web page into Access database?
Hi there,
I want to import the data from the public web page into Access database.
What kind of technology can I use?
I am trying to do it in this way.
1) transform the html file into xml
2) read the data from XML file and send to Access database
Is it a feasible solution? What tools shall I use to achieve the goal?
Thanks for your input.
...
|
1 |
03.03.2006 16:26:33 |
|
|
EARN $3,000.00 A DAY. OPEN AN INCOME-DAILY ACCOUNT WITH US
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft DHTML Editing Control">
<TITLE></TITLE>
</HEAD>
<BODY>
<P>YOU COULD BE EARNING OVER $3K A DAY , $100K A
MONTH.INCOME. CHECK IT OUT. Investment is only $5. 99cents a month.</P>
<P><A href="http://www.vosar.net">www.vosar.net</A></P>
<P>Tel: 775-333-11...
|
1 |
01.03.2006 07:13:21 |
|
|
security in their design or implementation. Intruders can exploit
security in their design or implementation. Intruders can exploit
...
|
1 |
23.02.2006 00:27:04 |
|
|
DSN-less connection
Hi,
I have an Access FE attached to a SQL server BE. It is curently working
under an DSN connection. I would like to change to a dsn-less connection.
i've looked around in different places but have not been able to find a clear
explanation on how to do this. Tried a utlity called dsnstripper but althogh
it seemed to ran ok it actually didn't change anything.
I'll appreciate any s...
|
12 |
20.02.2006 22:28:24 |
|
|
future
Hi to every bady
please council me aout feuture .what should i do. becouse i faild in s.y.j.c
..12th.what i do i dont no please what i do in future.send me mail.
THANK YOU.
...
|
1 |
19.02.2006 06:48:38 |
|
|
ODBC - insufficient privileges (??)
Hi All!
My ODBC works fine unless I logon as a simple user (to workstation w2k,
xp, and so on) without Admin privileges. Then I get the following error:
"The setup routines for the Oracle In ..... ODBC driver could not be
loaded due to system error code 5".
What does it exactly mean? Is there (in win registry, ODBC settings) any
option to add those privileges?
TT
...
|
4 |
17.02.2006 12:19:42 |
|
|
Call Stored Procedure w/return value from DAO Querydef
How does one call a stored procedure from a DAO Querydef? Using Access 97
with SQL 2000 backend. I need to get a unique ID from a table and increment
it, then return the new value, all inside a transaction. TIA!
...
|
3 |
15.02.2006 18:58:23 |
|
|
Deleting Via Linked SQL Server View with INSTEAD OF DELETE Trigger
Hi
In SQL Server (2000) I have a view that joins a base table to another view.
To be able to delete records from the base table I've written an INSTEAD OF
DELETE trigger on the view. Everything works fine when I test it via a
delete query in Query Analyzer.
When I link to the view in Access (2002) I get an error message stating that
I can't delete from the view or function because ...
|
5 |
13.02.2006 21:10:29 |
|
|
Login for user (null)..?
Hi all,
I have an MS-Access application that connects to a database via a DNS-Less
script with servername, database,userid and password.
But when I try run the app. I get:
"Login failed for user (null). Reason: not associated with a trusted SQL
server connection (OK)".
.... and after that I'm promted to log in with the checkbox "Trusted
connection" checked.
If I uncheck "Trusted conne...
|
1 |
09.02.2006 21:35:34 |
|
|
Access pass-through query using dsn-less connection not working
On my Win2k PC I'm trying to execute a pass through query in Access 97
(Access 2000 gives me the same results) per a dsn-less connection against an
Oracle 9.2.0.4 database residing on a unix server.
I keep getting an eror window: "ODBC -- call failed"
In that window I click OK and get another window: "[Microsoft][ODBC Driver
Manager] Data source name not found and no default driver specif...
|
10 |
09.02.2006 19:38:30 |
|
|
Persist uid and pwd info only for a single session?
I am using ADOX to link SQL server tables to my MDB front end. I have been
trying to find a way to get Jet to cache the user/password info for the
connection *only* for the current Access session. In other words, what I'd
like to have happen is
(1) App starts up, prompts user for uid/pwd
(2) App modifies the connection string property for the links to pass the
UID and PWD along to the ...
|
1 |
08.02.2006 19:01:41 |
|
|
Can't override Read-Only connection
I have an Access 2000 App that uses pass-through queries to Oracle 8. By
default, when the user logs on the tables are attached with the read-only
userid. But I have 1 query that needs to update a table. I created a
passthrough query with the read/write user/pwd and it works fine if I run it
BEFORE logging on with the read-only (opening the db with the shift key and
by passing the sta...
|
3 |
08.02.2006 09:15:37 |
|
|
I need help
every time I send and receive this error message comes up. It says incorrect
password or account nameCheck the username/password or security settings.
And it doesn't let me get my mail. can somebody help? my address is
eli.barr@providenceday.org
...
|
1 |
07.02.2006 02:06:14 |
|
|
Locking scheme for ODBC linked tables? Access + SQL Server
Sorry for posting in three newsgroups, but all seem appropriate and the
topic seems to have sparse coverage in general.
Using Access 2003 linked tables to SQL Server 2000 via ODBC. What's the
simplest way to implement explicit control over record locking? Even
with a timestamp in the table, letting Access' built in form record
locking warnings seem a bit tardy.
Probably my ideal sce...
|
8 |
06.02.2006 16:20:43 |
|
|
System Resouce Exceeded Error
Hi,
I have a database (.mdb) Access2k3 that has linked tables from an Oracle db
and a SQL server 2k db. I need to take data from the Oracle db, import it in
to a temp table (SQL Srvr) where I can add info that will allow me to
summarize it. and then I want to store the summarized data in another table
in SQL server 2k. I am running all the code to do that from the mdb file.
The code ...
|
9 |
06.02.2006 12:46:28 |
|
|
ODBC on 64bit system
i'm running xp 64 bit and am having problems with odbc. i found that ican
find the odbc drivers when i run a certain short but but i still am gettin
gthis error
System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver
Manager] Data source name not found and no default driver specified
...
|
1 |
05.02.2006 21:01:54 |
|
|
64 Bit Windows XP and odbc
i installed the odbc drivers but i believe there are issues with it because
i'm trying to do a dsn or dsn/less connection to an access database with
asp.net but i'm getting the error
System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver
Manager] Data source name not found and no default driver specified
as soon as i call
myConn.Open();
any ideas please
...
|
1 |
05.02.2006 20:55:12 |
|
|
Animals in China
mms://a805.v9135e.c9135.g.vm.akamaistream.net/7/805/9135/0029/peta.download.akamai.com/9135/downloads/jcruel_china_dog_med.wmv
sales@lpi-hk.com
...
|
1 |
04.02.2006 10:03:51 |
|
|
Animals in China
mms://a805.v9135e.c9135.g.vm.akamaistream.net/7/805/9135/0029/peta.download.akamai.com/9135/downloads/jcruel_china_dog_med.wmv
sales@lpi-hk.com
...
|
1 |
04.02.2006 10:03:45 |
|
|
(.)(.) Hot...
Call +8613352960090
Free!
Multi-lingual!
...
|
1 |
04.02.2006 04:06:25 |
|
|
(.)(.) Hot...
Call +8613352960090
Free!
Multi-lingual!
...
|
1 |
04.02.2006 04:06:24 |
|
|
Filter not releasing
Hi,
I have an Access frontend drawing it's tables from MSSQL.
My users report that if they do a filter, they cannot release the filter,
and have to close down th form an re-open it.
Any reasons why this should be?
I can't replicate this on my machine, but there are differences, namely, I'm
logged in as administrator, and I'm using 2003, whereas they are using 2000.
Thanks in advan...
|
1 |
02.02.2006 15:21:38 |
|
|
Access Append query not firing SQL Server Instead Of Insert Trigge
One of our users appends rows to a SQL Server linked table in Access. We have
a an "Instead of Insert" trigger on the table to validate and block access to
some columns. This trigger works fine every except when the data is inserted
via Access. It doesn't appear to fire. Any ideas on what's happening?
Scott...
|
2 |
01.02.2006 18:29:13 |
|
|
Sql direct and parameters
I want to use sql-server stored procedure from Access, and i need to know how
to use varaiable parameters with the sql Direct function.
Anyone has an idea ?
Thanks in advance
Christophe...
|
2 |
30.01.2006 10:22:44 |
|
|
Access 2003 & SQL Server 2005
We have an Access 2000 MDB with a SQL 7 back end. We are upgrading SQL
Server to SQL 2005, and are considering upgrading to Access 2003. Someone
mentioned that they had heard about some incompatibilities between Access
2003 and SQL Server 2005. Anyone hear of anything? And, if so, would staying
with Access 2000 be better?
Thanks!
Neil
...
|
5 |
30.01.2006 04:46:38 |