|
by: me here |
last post by:
I have a VBA subroutine that links an MS Excel spreadsheet and copies
the data into a local table. This process is controlled by a form that
allows users to select the spreadsheet from the file system. I actually
import from two different named ranges from each workbook so for every
import the following subroutine is used twice. The database...
|
by: deko |
last post by:
How to run action query against linked table?
I have an Access 2003 mdb with an Excel 2003 Workbook as a linked table.
When I attempt to run an action query against the linked table I get this
error:
Deleting data in a linked table is not supported by this ISAM.
From what I understand, indexed sequential access method (ISAM) drivers are...
|
by: Brad |
last post by:
Thanks for taking the time to read my question.
I have a split DB and I want to be able to delete the old table, copy an
existing table that is in the back end, rename it, and then make sure
all my links are still in tact. Right now I seem to be just doing this
to my table links in my front end.
Is this possible?
Here is my code:
|
by: jkw |
last post by:
Hi - I created a linked table via ODBC to a SQL Server database. The
table in SQL Server contained over 12,000,000 records. Later, I
started a "Delete" query. When I realized that I was deleting from the
SQL Server, I panicked and tried to stop the query. Esc didn't work,
so I killed Access with Ctrl-Alt-Del (task manager). Is there any...
|
by: Roger |
last post by:
I've got two tables in sql2005 which have an 'ntext' field
when I linked the first table in access97 last week using an odbc data
source the access-field type was 'memo'
when I link the 2nd table today, it is linked as a text(255) field,
ditto for the first table if I link it today
if I link the 2nd table using access2003 (and the same...
|
|
by: troy_lee |
last post by:
What is the best way of copying all the records from a linked table
into a replica table that is local on my computer? This is for
development work at home where I can not access the main table. Is a
macro the best way to handle this?
Thanks in advance.
Troy Lee
|
by: Duke Slater |
last post by:
I have a user who has created an Access 2007 database with one linked table to SQL Server 2005.
He wants to purge the linked table and repopulate it, but gets the 3086 error when running a delete statement. I might think the syntax is wrong, but when opening the table in Access the delete option is disabled (but only on the linked table). He...
|
by: Joel Marion |
last post by:
I have a linked table that is being imported from Excel, with the data being exported from a source I cannot control. The incoming table contains a heading in row 1 that only has text in the first cell followed by blank cells, with the column names in row 2. I am currently manually deleting this first row before importing/linking the table, but I...
|
by: Chary314 |
last post by:
Dear all,
I just spent quite a lot of time investigating one problem, which seems to be a bug (which I wasn't able to google). So I am just posting a bug report here:
BUG REPORT:
PROBLEM DESCRIPTION:
Not possible to re-link Linked table after unsuccessful connection to a table, which has Memo field with Append Only flag, set to Y.
On...
|
by: parkin13 |
last post by:
Hello - I have an issue with Access after upgrading to 2010. It seems to impact all databases and they are working for others.
Whenever I attempt to enter the "Linked Table Manager" either via the External Data tab or by right clicking on a table and selecting "Linked Table Manager" I get the following error...
"The Database cannot be...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
|