Hello,
Used these boards a few times before to find answers, wondered if somebody could help me out. (Using Access 2000, and DAO Reference Library).
I have some code which used TransferText to link a series of Text files into the database. I then called a function which ran some validation through the entries imported by calling OpenRecordset with an SQL query to access the linked files (nothing complex, just a SELECT * FROM TableName command).
This was working fine. Then I decided to start working with a second database open in the same workspace. I never modified the original code, and suddenly I'm getting this issue with the OpenRecordset command. An error message comes up saying it cannot find the specified table (even though I can see it has clearly linked it by this point in the tables view).
What's weird is that when I click on Debug, it takes me to that line and highlights it, and if I use Step Through or tell the code to continue running, it then has no problem with the line and carries on until it gets to the next attempt to run the command (which would be on the next file it linked).
Does Access have some kind of time delay when linking external files into a database before OpenRecordset can access them?
If not, do I need to add some additional specifier somewhere which allow the command to more accurately locate the table?
Regards,
peridian.
1 1714 MMcCarthy 14,534
Recognized Expert Moderator MVP
It may be that you are not closing your recordsets or reseting the database.
Post the relevant code here. You can leave out any record loops or updates. Just put in brief desciption of actions that are omited.
Mary
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Sue |
last post by:
Using WindowsXP and AccessXP in 2000 Mode
When I run the following code, I get error 3027
"Cannot Update. Database or object is read only."
StrFolder = "C:\Comic Box\WebStore Interface Database\UpLoadChangeFiles\"
StrFile = "NewStoreItem" & Format(Now(), "yymmddhhnn") & ".txt"
DoCmd.TransferText acExportDelim, "NewStoreItem Export Specification",
"QryPFrmAddNewItemToWebstore", StrFolder & StrFile, False
|
by: Michael |
last post by:
I have an application that will export two files to fixed width text
to combine as a single text file. The first export will be a query
containing header information for the file, the second query will be a
table containing transactions. I have a routine that uses a command
button to set up the export and a module that takes care of the merge.
I've scraped this together using posts on this group The command
button portion works but I get...
|
by: Squirrel |
last post by:
Hi everyone,
I've created a mail merge Word doc. (using Office XP) , the data source is
an Access query.
Functionality I'm attempting to set up is:
User sets a boolean field to true for each person for whom a mail
merge letter is desired.
The query reads address info from the table for each record where is
true.
|
by: Oliver Gabriel |
last post by:
Hi,
i want to export a table for later import, using vba.
That´s my code:
export:
filename = "C:\HVOtabelle.txt"
|
by: hedgracer |
last post by:
I have a strange problem with a docmd.transfertext statement. I have
set up an import specification to transfer in a .txt file by fixed
width. When I do the import using the specification the file imports
just fine into the table. When I use the transfertext statement for
import the contents of the file are loaded into the first column. Has
anyone run into this problem and do they have any
suggestions/solutions?
Here is the code in...
| |
by: JHNielson |
last post by:
I have a somewhat simple question, but have been baffled by it for a while, and now I'm on a tight deadline - have to get it done within 24 hours.
I am trying to export a set of files to my hard drive to then later be FTPd to a server. the file format should be "TITLE.yyyymmdd" where yymmdd is the date code for when the files are created.
The files can't be .txt. But when I run the files as ".txt" the code runs just fine. when I...
|
by: dogman_2000 |
last post by:
Hi All
I am using the docmd.transfertext to export my query as a .csv file.
I am using an export spec which is seperated by a pipe.
The problem I have is that I added an extra column onto the end of my
query and updated the spec.
The new column is an integer but when I export it, it always exports
as a text field i.e "100". With quotes around it.
|
by: Dave |
last post by:
Hello,
I have a possible problem exporting a text field that happens to
contain dates (but is not a date field) when using TransferText in MS
Access 2000.
I am exporting a query to a text file using TransferText in a module.
One of my fields is a text field called "invoice description". This
field may include any content including dates (e.g., 01/01/2006,
1/1/2006, 01/01/06, Invoice #1, Jan 2006, 293842, etc. are all
|
by: stuart |
last post by:
I seem to have a problem with the use of the TransferText function.
In 2 applications that I have, every few months, it seems to not
export a few records from a table. In another application, every 2-3
months the users would start getting run time errors after they
exported data from my program.
Is anyone aware of problems with this function with these kind of
results. The following is a code fragement:
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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: 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: 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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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...
| |