Error 3027

[Toxalot]

I'm working a little bit blind at the moment as the client gave me
very little info. They are in a different time zone and are
unavailable at the moment, but I would like to have some clue when I
speak to them next.

I recently added a function to export a csv file. Client sent me an
email simply saying that it doesn't work and they get error 3027.

The FE and linked BE were created with Access 2003. Client is using
WinXP though I don't know which sp. They have installed Access Runtime
from my Access 2003 CD. I don't know what version of Jet they have.
Does that get installed with the Runtime or with the OS? They are
accessing the BE locally, not over a network. They have both the FE
and BE stored in C:\Program Files\Database

I've found many threads about this error in reference to
DoCmd.TransferText but it's all very old info. I can't duplicate the
problem on either of the two systems I have here so I am only assuming
that DoCmd.TransferText is the culprit. But the file extension is csv
which is supposed to be one of the acceptable ones. The function also
deletes and re-creates a few queries. Could that be the problem?

Any ideas?

Jennifer

 

[Allen Browne]

Jennifer, there are several possible causes for this error.

I saw it once on a machine where the server had multiple shares. The folder
where the BE resided was shared will full permissions, but the parent folder
was shared read-only. The user had managed to connect to the parent share,
and so the database was read-only for this user but worked fine for other
users.

There was also another case where the Temp environment variable pointed to a
non-existent folder. As a result, Access was not able to create a temporary
file, and gave an error like that.

Yet another case involves Access security, where the mdw file has the same
name as the database and is in the same folder. Access then tries to create
2 LDB files (one for the MDB and one for the MDW), fails, and so generates
an error.

If your database is using one of the TransferXXX methods, and is trying to
create a file with an unregistered extension (e.g. TransferText with a PRN
extension instead of a TXT or CSV), some versions give a 'read-only' error
response.

There's another case under Vista where the \Program Files folder is
virtualized, resulting in 'not found' errors. Even XP can be really picky
about sharing stuff in this folder. I strongly suggest that you create
another folder specially for your application (not under Program Files),
with full sharing for other users.

 

[Toxalot]

Thanks for all the ideas. I have some responses and more questions.

The computer the client uses for this application is a stand-alone
computer. It is not connected to any network. It isn't even connected
to the Internet. So I don't see how it has any shares. I'm not even
sure how to check this stuff. I can usually figure things out on my
own, but it gets much harder when I can't see the screen and have to
rely on what client tells me.

The FE and BE are in the same folder.

What is an mdw file?

The application is using TransferText, but the filename has a .csv
extension.

My application doesn't 'install'. The client just stored the files
where they wanted them. I can tell them to move it out of Program
Files, but they aren't sharing so that shouldn't be a problem, should
it?

Jennifer

 

[Allen Browne]

The MDW file is to do with Access security. If you have net set up a
security file (so the user has to log in with a user name and password),
this does not apply.

TransferText should not cause grief with the CSV file, unless the user has
the file open when you are trying to create it.

It would certainly be worth them creating a folder such as:
C:\Data
moving both the back end and front end there, reconnecting the tables (e.g.
with the Linked Table Wiz.), and seeing if that solves the problem.

 

[Toxalot]

I don't have any user security. There is only one user.

On my system, if the file is already open it raises error number 3051
and I'm trapping that one to give them a more friendly message.

I will have them try to move the files. The application already
handles automatic re-linking.

Jennifer

 

[jobrazinski]

Amazing, I'm having the same problem and also finding dusty references
to it online. I have full access to the folder where I'm trying to
create the file. I know I've done this sucessfully in Access before,
but this time it won't work. I can export manually using the same
specification file, but not with the program.

This is the code:
DoCmd.TransferText acExportDelim, "ExportLive", "tblExport", location
& "\EmergencyContactProd", -1
(ExportLive is my specification file, tblExport is the table to
export, location is a string and I've tried removing it, no
difference.)

I get the 3027 error, too. The destination file is not open by anyone
else; no one even knows it exists there.

Thanks for any help you can give!

 

[jobrazinski]

OMG, I just solved it. (Isn't that always the way when you ask someone
else?) It didn't like my lack of file extension on the file name. (In
the past, to use a non-standard extension, I had to rename the file
after I created it.) When I added ".csv" to the end, it ran smoothly.

I hope your problem resolves as quickly!

 

[Toxalot]

Glad that you got yours working. I'm still scratching my head however.

I had client move the database files to C:\Database and try again.
They tried saving the csv file to the desktop and they tried saving it
to a thumb drive. They tried it with a .csv extension and with the no
extension. They get the same results every time.

I took a look at a few registry keys
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\3.5\Engines\Text\Extensions
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Text
\DisabledExtensions
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Text\Extensions

The ones for 4.0 are the same on my machine as theirs. They don't have
an entry for 3.5.

Could this have anything to do with it?

Also, my machine is WinXp Pro and theirs is Home.

The function that creates the mailmerge file does the TransferText
last. It also deletes and creates several queries. Could that be the
cause of error 3027?

Jennifer

 

[jobrazinski]

Hmmm, I don't think the queries could be a problem, but you know
Access, it's possible. Can you temporarily comment them out and see if
the error goes away? Doesn't really solve the problem, but it would at
least help define it.
I haven't had to get into the registry keys, thankfully. I found my
solution by searching the error in Google, which led me back to
Microsoft, if I remember right.

 

[Toxalot]

I added more info to the error message to see where it was actually
breaking, but now client says it's working. They didn't change
anything and neither did I. I'm happy it's working, but I'd really
like to know WHY it's working or rather, why it wasn't.