MSAccess 2007-adding records in Tables linked to a file on IBM iSe
Thu, 4 Sep 2008 10:19:02 -0700
I am attempting to add records within Access to a Table that is linked
directly to an IBM iSeries/AS/400 physical file. I receive an error message
ODBC-insert on a linked table "Ac--- Failed. IBM iSeries Access ODBC driver
[DB2 UDB]SQL7008- Ac--- not valid for operation (#7008)
I am not working on The SQL S ...
|
kan geen mail ontvangen of verzenden.
Thu, 4 Sep 2008 17:30:54 +0200
Van: "JB" <JB@discussions.microsoft.com>
Onderwerp: Access 2007 Cannot export to Excel using 2003 DB
Datum: donderdag 4 september 2008 17:00
We have a 2003 access database. Most of our users are still on 2003, but I
have one user using 2007 now. This particular user cannot run any reports
or
exports tha ...
|
Can't link to FoxPro db
Thu, 04 Sep 2008 15:24:58 GMT
Hi,
I tried to link my Access db to FoxPro (.dbf) using File, Get external, Link
menu. But the message comes up 'Expected Table is not expected format'. I am
sure the developer locked the dbf file for security purpose, but I really
needs that file for my custom report, because I can't extract that table
using ...
|
Access 2007 Cannot export to Excel using 2003 DB
Thu, 4 Sep 2008 08:00:01 -0700
We have a 2003 access database. Most of our users are still on 2003, but I
have one user using 2007 now. This particular user cannot run any reports or
exports that export to Excel. In some areas, the export to Excel is greyed
out, and when the vb code explicitly calls to export something into Excel, we
g ...
|
Gucci 110 G-Link Diamonds Ladies Watch YA110506 Recommendation
Discount Watches
Thu, 4 Sep 2008 01:47:47 -0700 (PDT)
Gucci 110 G-Link Diamonds Ladies Watch YA110506 Recommendation
Discount Watches
Gucci 110 G-Link Diamonds Ladies Watch YA110506 Site:
http://gucci-watches.pxhelp.com/Gucci-wristwatch-3233.html
Thank you for choosing http://www.pxhelp.com/
Quality Gucci Watches: http://gucci-watches.pxhelp.com/
Gucci ...
|
Importing large files from Access to Excel?
Wed, 3 Sep 2008 12:34:08 -0700
I have a table in Access which has 89,999 records which are auto numbered
sequentially. When I try to import this table into Excel the order gets out
of sequence. The first 1000 or so records come in correctly, but then in
sporadic places the numbers get way out of order. For example it jumps from
4000 to 1 ...
|
"Microsoft Access cannot open this file"
Wed, 3 Sep 2008 09:38:00 -0700
Added a new computer to the network (OS is Vista). I have the tables residing
on a server. When I tried to open a link table from the new computer, I am
getting this message: "The file is located outside your intranet or on an
untrusted site. Microsoft Access will not open the file due to potential
security ...
|
|
|
Decimal Truncation Issue upon Import - Access 2007
Wed, 3 Sep 2008 04:25:00 -0700
Has anyone else had an issue with decimal truncation when performing a table
import (from text). I have a text file that I import into an already
existing table. The data source has integers (0, 9, etc) and decimals (7.9,
19.99, etc). I am noticing that if the first couple of records are integers,
then Ac ...
|
Importing Data Using ODBC Connection
Wed, 3 Sep 2008 03:06:04 -0700
Hi There,
I want to import data into a MS Access database from a SQL Server database
using an ODBC Connection. I then need to create a macro to manipulate the MS
access data. I only want to manipulate the access data, I don't want to
change/manipulate the original data (the data in the SQL) server. If I ...
|
Running Make Table Access Queries from Excel
Tue, 2 Sep 2008 14:53:02 -0700
Hi,
I have an Excel Speadsheet that imports data from a number of Select Access
Tables into different Worksheet. This work well for users that are not
familiar with MS Access since they can just open the Spreadsheet and that
Data fro each worksheet is refreshed for them.
However I need to create a Make Ta ...
|
