473,670 Members | 2,646 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Interpret Error And Provide Cure

I have a table named MyTableBlank that contains no records. My intent is to
make a copy of this table, name the copy MyTable, append some records to
MyTable and import MyTable into an external database. I use the
TransferDatabas e function to import MyTable into an external database. I
need MyTable to be in both the current database and the external database.
Prior to making the copy, I have code that checks to see if a table named
MyTable exists and if it does I delete it. To make the copy, I have tried
the CopyObject method and the TransferDatabas e function. Whichever I try, I
get the same error message:
"Record(s) can't be read; no read permission on 'MyTable'..."
When I try to append some records to MyTable.

Can anyone interpret the error message and tell me how to cure this poblem.

Thanks!

Steve
Nov 13 '05 #1
2 1409

So why do you offer to charge for Access help if you can not solve this?

John... Visio MVP
"PC Datasheet" <no****@nospam. spam> wrote in message
news:80******** *********@newsr ead1.news.atl.e arthlink.net...
I have a table named MyTableBlank that contains no records. My intent is to
make a copy of this table, name the copy MyTable, append some records to
MyTable and import MyTable into an external database. I use the
TransferDataba se function to import MyTable into an external database. I
need MyTable to be in both the current database and the external database.
Prior to making the copy, I have code that checks to see if a table named
MyTable exists and if it does I delete it. To make the copy, I have tried
the CopyObject method and the TransferDatabas e function. Whichever I try, I
get the same error message:
"Record(s) can't be read; no read permission on 'MyTable'..."
When I try to append some records to MyTable.

Can anyone interpret the error message and tell me how to cure this
poblem.

Thanks!

Steve

Nov 13 '05 #2

"PC Datasheet" <no****@nospam. spam> schreef in bericht news:80******** *********@newsr ead1.news.atl.e arthlink.net...
I use the TransferDatabas e function to import MyTable into an external database
??? Are you *im*porting in an external database ????
Please press F1 more often.
"Record(s) can't be read; no read permission on 'MyTable'..."


If you have been fooling around with User Level Security, I am afraid you will have to do more homework.
But perhaps the database is only corrupted ?
-- Do a Google search on "Record(s) can't be read; no read permission " to cure your database.
-- I am afraid there will be no cure for the owner.

Arno R
Nov 13 '05 #3

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

Similar topics

2
2945
by: Somerset Bob | last post by:
I've got pagination errors in a phpBB board. Some forums are showing "page 1 of 0". Previous enquiries both here and at the phpBB forum have given me half-answers, the latest of which contained this advice: For each forum in phpbb_forums: -) Get the number of posts that belong to a forum from phpbb_posts select count(*) as count from phpbb_posts where forum_id=$forum_id update phpbb_forums set forum_posts=$count where...
3
3821
by: transam | last post by:
Hi, I use Mandrake linux 10 with German setup, Hungarian Keyboard. My Python is python 2.3.3. The following program fails: --------------------------------------------------------- import locale loc = locale.setlocale(locale.LC_ALL) # get current locale locale.setlocale(locale.LC_ALL, 'de_DE') # use German locale; name
0
1375
by: Lauren Wilson | last post by:
The error does not have an error number. It's not even a normal Access error message box. Hope someone has some insight to this problem. I have a form that contains a large (5" x 4") text box bound to a memo field. This field allows users to type in the text of an email to be sent through Outlook (via automation). I ONE user who send me his back end data base where he has inserted several two - three page emails. When scrolling...
2
3390
by: Alvin Bruney | last post by:
Anybody know how to fix this. Currently only a reboot will cure it. I'm sick and fed up of rebooting. It has to be one of these services running in the background doing this. It can happen with any assembly, .Net included. It's intermittent. I've tried. Re-opening VS studio, re-starting IIS, re-starting application pool. Killing all the w3wp.exe processes. Nothing seems to work except a reboot. Deleting temporary internet files. This is...
1
6193
by: Seetha J | last post by:
I work on a website where users can apply for different types of loans. Depending on the type of loan we store various sets of data in Session state which is maintained in SQL Server. If the user stops in the middle of loan application process I want to capture whatever data was in the session and store it in our backoffice systems for non-repudiation purposes. In the past we have been doing it on session end but after we moved to SQL...
33
3143
by: Anthony England | last post by:
I am considering general error handling routines and have written a sample function to look up an ID in a table. The function returns True if it can find the ID and create a recordset based on that ID, otherwise it returns false. **I am not looking for comments on the usefulness of this function - it is only to demonstrate error handling** There are three versions of this code. David Fenton says under the earlier thread "DAO...
0
1397
by: nutso fasst | last post by:
Hello. IIS 4 website with a custom 404 error page WAS working OK, but at some point it wacked out. In the logs there were no 404 error responses. Instead, what were recorded were 200(OK) responses with my custom 404 page. Researching, I found that when a non-existent resource was requested, instead of directly responding with the 404 error page, the server responded with 302 (Found / Moved Temporarily) and a redirection to my custom...
6
1975
by: KDawg44 | last post by:
Hi, I recently took over a site written in PHP. We utilize a third party to perform a job match, search, and application. When this page loads in IE, we get a pop up that says: The Page contains both secure and nonsecure items. Do you want to display the nonsecure items? How can I get rid of this as people going to fill this application out
1
1253
by: Twayne | last post by:
Hi, Complete newbie here, no C or related language background; starting from the basics. I DO have Visual Basic 6 (non .NET) and batch file experience, but that's all. I have the following statement in a piece of code I chose to analyze. It's from a captcha form script but it is a pretty standard thing in many such scripts. I understand the first line fine.
0
8386
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8903
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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8815
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 captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8592
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,...
0
8661
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6216
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4213
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...
0
4393
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2044
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.