Access acdb's are constantly crashing!!
Wed, 4 Jun 2008 06:52:07 -0700
we recently migrated all our access 2003 based application to access 2007 and
we discovered that alot of our applications are crashing!! we also notice
that the system for some reason is making a backup file of the accdb's that
crashed. We have never experienced something like this before, I would like
to kn ...
|
Compacting password protected Access Backend databases from Fronte
Mon, 2 Jun 2008 06:09:01 -0700
I have been using the following code to compact and repair a backend that is
not password protected:
Dim stAppName As String
stAppName = "MSACCESS.EXE " & """" & Katalognamn() & "Test_be" & """" &
"/nostartup /compact"
Call Shell(stAppName, vbNormalNoFocus)
and it works exactly as I want to. But now I ha ...
|
Library function calls
Sat, 31 May 2008 17:12:46 -0400
Is it possible to call a function defined in a library referenced 2 levels
higher? IOW, if Database3 has a library reference to Database2, which has a
library reference to Database1, can I use codes in Database3 that call
functions defined in Database1?
Thanks
...
|
Web based newsreader
Sat, 31 May 2008 17:09:48 -0400
Nothing happens when I select New/Question in the web based browser. Anyone
knows why?
...
|
Resetting Table Links
Wed, 28 May 2008 07:33:01 -0700
I have a procedure that resets table links depending on the site that is
using the database. Most links are to Access tables in other databases, one
is to an Excel file, one to a .txt file. For the first two everything works
fine, but for the .txt file I'm getting an invalid path error. Since the
path IS ...
|
Extract variables from FIle name
Tue, 27 May 2008 03:35:01 -0700
Hi,
I have the following code that reads the context of my directory.
impdir = CurrentProject.Path & "\Import\"
strFile = (Dir(impdir & "*.csv"))
If strFile was equal to something like
strFile= "20080424 PNA.csv"
How could I extract the 20080424 as variable A and PNA as variable B. In
other words my ...
|
acomplia en France a vendre
acomplia canada aucune prescription
pharmacie en ligne en France
acomplia belgique en ligne
acomplia suisse commande en ligne
Wed, 21 May 2008 15:57:49 -0700
acomplia en France a vendre
acomplia canada aucune prescription
pharmacie en ligne en France
acomplia belgique en ligne
acomplia suisse commande en ligne
+++ PERTE DE POIDS +++ PERTE DE POIDS +++ PERTE DE POIDS +++
+
ACHETER ACOMPLIA BON MARCHE (ALL CARD ACCEPTED)
http://jhku.net/ACHETER-ACOMPLIA-BON-MAR ...
|
|
|
VBA DAO Recordset2: Copying Multi-Valued fields Bug?
Tue, 20 May 2008 10:59:26 -0700
This looks like a bug in Access 2007 / DAO 12
Have tried to run the following but this gives error '3824' INSERY INTO
query cannot contain multi-valued field.
INSERT INTO [;database=C:\Data\DBexchange.accd].MyTable (ID, Field1, Field2,
Field3)
SELECT ID, Field1, Field2, Field3
FROM MyTable
WHERE ID NOT I ...
|
achat zyban pharmacie
acheter zyban pharmacie
achat zyban a vendre
acheter zyban canada au rabais en ligne sans prescription
comprimes de achat zyban en France bon marche
Mon, 19 May 2008 03:07:46 -0700
achat zyban pharmacie
acheter zyban pharmacie
achat zyban a vendre
acheter zyban canada au rabais en ligne sans prescription
comprimes de achat zyban en France bon marche
+++ Anti-déprimants +++ Anti-déprimants +++ Anti-déprimants +++
+
ACHETER ZYBAN BON MARCHE (ALL CARDS ACCEPTED !!!)
http://jhku.net/AC ...
|
How to get XML from ADO
Sat, 17 May 2008 09:22:48 -0700
Is it possible to get the contents of an ADO recordset returned as XML
without first persisting it to file?
I would like to pass the contents of a temporary table in Access to a SQL
Server stored procedure string parameter via XML.
Patrick
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Patrick Jackman
Vancouver, B ...
|
