placing in array into a table using ADO
Wed, 6 Feb 2008 15:49:01 -0800
Hi,
I have a one dim array with unique identifiers that I want to load into a
table to then use to join against a million records, then use that that
resulting recordset (should be 5K records) to compare against those
identifiers in the spreadsheet and add the remaining fields back into the
spreadsheet. Fo ...
|
Incorporate Netwok Credentials into my strDBPath
Tue, 5 Feb 2008 20:39:01 -0800
The following strings allow me to connect to a remote SHARED folder
Const strDBPath As String = "\\MyServer\MyFolder\MyDB.mdb"
Const strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
strDBPath & ";"
Is there any way to incorporate the network credentials into my strDBPath
without actually ma ...
|
Access 2003 to linked SQL 2005 tables very, very slow
Mon, 04 Feb 2008 16:26:50 -0600
I've got a client who wants to keep running Access 2003, but wants the data
located in sql 2005.
I was able to migrate the data to SQL 2005, but when we attempted to run a query
that took maybe 2-3 seconds for Access 2003 using internal tables (even when run
on the network remotely thru a file share), took 30 ...
|
ODBC connectivity to Excel in 64 bit SQL
Mon, 4 Feb 2008 10:56:03 -0800
I moved a db from a 32 bit SQL install to a 64 bit SQL install. We have
reports that port data using DTS in to an Excel spreadsheet. Since moving
the db these are not working with the below error:
Executed as user: GSB\sqladmin2000. ...n 9.00.3042.00 for 64-bit Copyright
(C) Microsoft Corp 1984-2005. A ...
|
Performance problem with local Access DB
Sat, 2 Feb 2008 22:34:45 -0800
I have a C++ application that I am porting - switching from using SQL Server
as the
back end to using a local Access 2007 database. The API is ODBC. I was able
to do
with without too much trouble, except for a serious performance problem.
This
application bascially dumps a whole lot of external data into th ...
|
SQL Server upsizing
Sat, 2 Feb 2008 20:11:52 -0500
I've got an Access application at work that has about 15 users, but I've
been asked to migrate it to SQL Server (2000), with a few modifications, so
that as many as 100 people can access it. Unfortunately, I don't know who
will be using it, and don't want to go through the hassle of having them
email me, to ...
|
Invest smart
Sat, 2 Feb 2008 13:46:20 -0800
How much profit can you make with one dollar?
Check out this website www.forbuck.com
Without any obligation, registering or other ties make cash!
...
|
|
|
Telenet nieuwsgroepen mededeling: nieuwsserver adres aanpassen/Attention: modification de l'adresse du serveur de newsgroup
Wed, 30 Jan 2008 02:09:27 GMT
Beste klant,
Telenet heeft een migratie gedaan van haar nieuwsservers.
Wat betekent dit concreet voor jou als gebruiker?
Er verandert niets aan de service, maar om verder gebruik te maken van de
Telenet nieuwsgroepen service moet je bij de instellingen van je nieuwslezer
het adres van de nieuwsserver ver ...
|
Connecting MySQL and Access 2003
Mon, 28 Jan 2008 23:22:23 -0500
I'm a newbie to MySQL and hve limitied knowledge of the .dsn files
associated with ODBC drivers. I've never had to tweak one. Usually, I just
follow the steps of how-to's for connecting an application to Access or
Excel without encounteriing a problem.
I'm trying to connect a MySQL database with Access as ...
|
Instalacion Chip Consolas Wii Playstation 2 - Xbox360 - Playstation 3 - Ps2 Ps3
Mon, 28 Jan 2008 18:25:28 +0100
...
|
