473,561 Members | 3,144 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access 2003: Problem running update queries on linked-in Excel Spreadsheets

To my surprise and chagrin, newer versions of Access have disabled the
functionality that lets users change the data in linked tables that point to
a range in an Excel workbook. This is "because of legal issues..." according
to Office Support.

I have other issues, specifically a couple of applications that do things
such as calculate price updates in Access and read them back by means of
update queries into the spreadsheets our marketing people prefer. These
things are simple stand-alone applications and have been working without
hassle for years. Now, as we upgrade our corporate software, they're
suddenly defunct.

I hope someone in this group has tripped over this issue before me and come
up with a workaround they would be generous enough to share.

Also, I'd be interested to know what else I might expect to blow up as we
migrate from Office 2000 to Office 2003.

For a while I thought that was a good idea.

Thanks in advance,

Jim Salmon
Feb 4 '06 #1
2 2301
The phenomenon you describe came about as a result of a software patent
suit.

I believe Microsoft's recommendation for a workaround, until they come up
with a suitable alternative approach, is to import the Excel data into
Access.

Larry Linson
Microsoft Access MVP
"Jim S" <ji****@enter.n et> wrote in message
news:43******** *************** @news.enter.net ...
To my surprise and chagrin, newer versions of Access have disabled the
functionality that lets users change the data in linked tables that point
to
a range in an Excel workbook. This is "because of legal issues..."
according
to Office Support.

I have other issues, specifically a couple of applications that do things
such as calculate price updates in Access and read them back by means of
update queries into the spreadsheets our marketing people prefer. These
things are simple stand-alone applications and have been working without
hassle for years. Now, as we upgrade our corporate software, they're
suddenly defunct.

I hope someone in this group has tripped over this issue before me and
come
up with a workaround they would be generous enough to share.

Also, I'd be interested to know what else I might expect to blow up as we
migrate from Office 2000 to Office 2003.

For a while I thought that was a good idea.

Thanks in advance,

Jim Salmon

Feb 5 '06 #2

Thanks for your input, Larry.

I've tried the altenative of putting the price update data in MS Access
reports that I've formatted to look as much like the spreadsheets as
possible, but that alternative got shot down by marketing. They want the
spreadsheets they've always had.

They are ancient but much loved, these spreadsheets. They are are also
strictly and heavily formatted with the relevant price cells on each sheet
in different places and with the effective dates and superceded dates
embedded in paragraphs of text.

They are also resistant to manipulation by Worksheet Macro or by
transferring a recordset from Access. There's nowhere to transfer it to...
The operation, in either case would have to address the Spreadsheets page by
page and cell by cell, and in the worst case offender there are about twenty
five pages. In other words, such programatic manipulation would require many
hundreds of separate operations, each slightly different.

My solution, failing a workaround less tedious than that, We're just gonna
keep at least one PC at corporate running Office 2000.

Probably the best idea anyway.

Jim S.
"Larry Linson" <bo*****@localh ost.not> wrote in message
news:AOdFf.6782 $In4.4358@trndd c06...
The phenomenon you describe came about as a result of a software patent
suit.

I believe Microsoft's recommendation for a workaround, until they come up
with a suitable alternative approach, is to import the Excel data into
Access.

Larry Linson
Microsoft Access MVP
"Jim S" <ji****@enter.n et> wrote in message
news:43******** *************** @news.enter.net ...
To my surprise and chagrin, newer versions of Access have disabled the
functionality that lets users change the data in linked tables that point
to
a range in an Excel workbook. This is "because of legal issues..."
according
to Office Support.

I have other issues, specifically a couple of applications that do things
such as calculate price updates in Access and read them back by means of
update queries into the spreadsheets our marketing people prefer. These
things are simple stand-alone applications and have been working without
hassle for years. Now, as we upgrade our corporate software, they're
suddenly defunct.

I hope someone in this group has tripped over this issue before me and
come
up with a workaround they would be generous enough to share.

Also, I'd be interested to know what else I might expect to blow up as we
migrate from Office 2000 to Office 2003.

For a while I thought that was a good idea.

Thanks in advance,

Jim Salmon


Feb 5 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
9853
by: ErickR | last post by:
We are experiencing a problem with Sql Server 2000 linking to an Access 97 file. We have two machines that link to this .mdb file, and we recently upgraded one to newer hardware, SP3a, MDAC 2.8, etc. The link on this upgraded machine no longer works, giving this message: Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider...
4
1923
by: martin | last post by:
Can anyone please help. I have a main membership form/table that has a subform with function table linked. This is obviously a fixed solution but I would like to make it more dynamic with a combo box to create a new sub linked table or select an existing one. The tables will all be identical and could probably be created from a template. I...
1
1199
by: Andy | last post by:
We have an ASP.NET application exported from MS Access 2003. I uses a series of queries to generate a page showing todays bookings. It works locally but does not work when we put it on a webserver (Running Server 2003). We have set the ASP.NET permissions on the appropriate folders. We have set the application to usesRemote = True. It...
3
1614
by: Max Powers | last post by:
Hello all, we finally upgraded our system so now our data is on a SQL 2000 database and our front end is on an Access 2000 database. Everything's looking good so far, but there's this little issue that's been bugging us ever since we upgraded. Whenever anybody in our network opens the Access system and moves from one form to another, the...
2
1247
by: John Thomas Smith | last post by:
I am running an Access 97 (Office 97 Pro) application on an older computer, and am about to be upgraded so my computer, and installed software, matches the rest of the office That means going to MS Office 2003 Professional, so my A97 application may be updated and shared with another computer This application uses a macro I wrote to...
7
16345
by: PW | last post by:
Hi, I have a form with unbound fields on it. The user selects a record from a recordset and I populate the unbound fields. When I try to change the unbound quantity text box, Access 2003 tells me "The data has been changed. Another user edited this record and saved the changes before you attempted to save your changes. Re-edit the...
1
1194
by: Roberto Balby | last post by:
Hi Everyone, I have an appplication developed with Access 2003 accessing a SQL Server 2000 installed on Server Windows 2003. When I run long queries, e.g. invoicing or sales report, the application runs only when the client is a Windows 2000. When I try to run the same application on clients runnning windows XP I get ODBC 3151 error, which...
2
2096
by: preguin | last post by:
I am attempting to do mail merges using Microsoft Access 2003 and Microsoft Word 2003. I have written numerous queries for various reasons and when I attempt to merge these queries with Microsoft word, it doesn't reflect all the queries I have written. It looks like some of the queries aren't there. I know DDE and ODBC fit into the picture...
2
1396
by: Lewe22 | last post by:
I am creating a small Access db which performs a series of updates to a SQL db. The Access db consists of a ‘Main Form’, from which the user can run each update via a series of command buttons. Each update has been written as a SQL pass-through query. Example Update: UPDATE unit_instance_occurrences uio SET fes_active_places =
1
1555
by: ewanm | last post by:
Hello, I'm trying to transfer data from an Oracle database into an Access 2003 database using VB code. I need to set this up so that it can be ran on a regular basis and I really would like to avoid using linked tables if possible. I can open 2 ADO recordsets (one from the Oracle database and the current Access database) and write from one...
0
7858
Oralloy
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. ...
0
8085
jinu1996
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...
0
7928
tracyyun
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...
0
6206
agi2029
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...
1
5469
isladogs
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...
0
5185
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...
0
3615
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2066
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
892
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.