I am in process of converting Access 97 databases to Access 2003. Some
of the Access 97 databases export data to a text file with a non
standard file extension, such as "ext" or "NAL". When I try to
run the export in the converted Access 2003 database, I get the error
"Cannot update: Database or object is read-only."
It seems that the real problem is that I can only export a text file if
I use either "txt", "csv", "tab", or "asc" as the file
extension. Is there a way around that requirement?
I can write an application to run after the export to rename the file
with the correct extension, but it is frustrating to not be able to
name the export file what I want it named in the Access export.
Hugh Barnett
3  6000 
On 7 Nov 2006 09:59:33 -0800, "hbarnett" <hb******@natsp in.comwrote:
A way around that? How about the Name statement? Didn't have to do
that before? So you adjust.
-Tom.
>I am in process of converting Access 97 databases to Access 2003. Some
of the Access 97 databases export data to a text file with a non
standard file extension, such as "ext" or "NAL". When I try to
run the export in the converted Access 2003 database, I get the error
"Cannot update: Database or object is read-only."
It seems that the real problem is that I can only export a text file if
I use either "txt", "csv", "tab", or "asc" as the file
extension. Is there a way around that requirement?
I can write an application to run after the export to rename the file
with the correct extension, but it is frustrating to not be able to
name the export file what I want it named in the Access export.
Hugh Barnett
Tom van Stiphout wrote:
On 7 Nov 2006 09:59:33 -0800, "hbarnett" <hb******@natsp in.comwrote:
A way around that? How about the Name statement? Didn't have to do
that before? So you adjust.
-Tom.
I'm not familiar with the name statement.
In Access 97, I could export a text file named "aaaaaaaa.b bb" using
the TransferText command. In Access 2003 it will not allow this since
the extension is not "txt', "csv", "tab", or "asc". I was
hoping that there was a way to allow me to export the file
"aaaaaaaa.b bb" in Access 2003.
Hugh Barnett
hbarnett wrote:
Tom van Stiphout wrote:
On 7 Nov 2006 09:59:33 -0800, "hbarnett" <hb******@natsp in.comwrote:
A way around that? How about the Name statement? Didn't have to do
that before? So you adjust.
-Tom.
I'm not familiar with the name statement.
In Access 97, I could export a text file named "aaaaaaaa.b bb" using
the TransferText command. In Access 2003 it will not allow this since
the extension is not "txt', "csv", "tab", or "asc". I was
hoping that there was a way to allow me to export the file
"aaaaaaaa.b bb" in Access 2003.
Hugh Barnett
export the file using TransferText. If you have the name of the file
in a variable, you can use Name to rename the file to something else,
like "aaaaaaa.bb b", where you have full control over the filename and
extension. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: eel3720 |
last post by:
Greetings:
I have a converted Access 2000 database that got replaced not converted
to a Access 2003 Database file. Now the reports in Access 2003
Database will not open.
I tried removing Access 2003 and then loading Access 2000. In Access
2000 it allows me to open the reports but it will not allow me to
create a new report.
|
by: scorpion53061 |
last post by:
Well I had a way to write an array to an excel spreadsheet but on a huge
time critical run it failed iwth the dreaded HRESULT: 0x800A03EC error. It
worked fine when i sampled the data to go in but when it all tried to go in
it bombed.
So I need to write this to a tab delimited file and I sure hope somebody is
awake tonight.
How do I write my dataset to make a tab delimted text file?
|
by: Deb |
last post by:
The conversion of my department's 12 machines has gone really well and
I have had no big problems with any of it. Now for another question --
Are there any new "goodies" in Access 2003 that are really helpful.
And I guess that I could say in 2002 as well as I started with 2000
|
by: Neil |
last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is
upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server
at the same time. We're moving to SQL Server 2005, and, since he already has
licenses for Office Pro 2002, he wants to upgrade to that.
I've been saying that we need to upgrade to Access 2003, not 2002, even if
Office is kept at 2002. We are also looking to do a fair amount of...
|
by: stuart.medlin |
last post by:
I have recently converted an Access 97 database to Access 2003.
However, I am running into a problem with using
Application.Filesearch
to locate a file in my directory. The code follows:
-------------------------------
Dim dbDir As String 'Directory where database stored
Dim dbPath As String 'Directory + Name of database
Dim dbFileName As String 'Name of the database
Dim Card1File As String ...
| | |
by: stuart.medlin |
last post by:
I have an Access 2003 application that I recently converted from
Access 97. I have a routine in which I use to export the data that
the users have keyed into a text file. This text file resides on a
network drive where the back end database resides so that multiple
users can write to the same file. I have set up the path to the back
end (under the Link Manager) using the UNC (univ. naming convention).
When this export routine runs, I...
|
by: NEWSGROUPS |
last post by:
I have data in a table in an Access 2000 database that needs to be exported
to a formatted text file. For instance, the first field is an account number
that is formatted in the table as text and is 8 characters long. This field
needs to be exported as pic(15) padded in the front with 0's (zeros). The
next field an ID name that is 15 characters that needs to be exported as
pic(20) padded with trailing spaces. There are about 5 fields in...
|
by: Wayne |
last post by:
I'm trying to automate the export of a query to a text file using
code. If I export the query manually I get the exact result that I
want i.e. If I select the query then choose File/Export from the menu
bar, choose "Text" as the save format, and then select "fixed width"
as the export format, I end up with a fixed width text file with no
column headers.
I've tried to automate the process using:
DoCmd.OutputTo acOutputQuery,...
|
by: lokeshreddy16 |
last post by:
'this is my code plz guys help how to save data from vb 2005 and other this that i am able to view the data from acess but i am not able save to acess i dont whether my code for save is correct of not ( iam using vb2005 as front end and MS acess as by back end)
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the...
|
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
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 most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
