Re: error says table not found error, but it does exist.
- From: Darrell Childress <NOdrcSPAM@xxxxxxxxxxxxxxxxx>
- Date: Mon, 13 Jun 2005 09:12:31 -0400
Also, make sure you're not using security and the user is not restricted from accessing that table.
Darrell
James wrote:
i just run a simple select statement using an ado command, recordset and connection objects. i created the table manualy in access. no trasactions.
"Michel Walsh" <vanderghast@VirusAreFunnierThanSpam> wrote in message news:OUafzSabFHA.2968@xxxxxxxxxxxxxxxxxxxxxxx
Hi,
What is your vb6 statement? Have you just created the table through code... so maybe it is a timing problem. Are you using a transaction?
Hoping it may help, Vanderghast, Access MVP
"James" <See.My.Sig@xxxxxxxxxxxxxx> wrote in message news:nsKpe.18252$ld3.16672@xxxxxxxxxxx
how come i randomly get an error message saying table not found (exact error
message is pasted at bottom of this post). I get this error when trying to
perform a select statment with ADO in visual basic 6 on windows xp to a
remote access 97 .mdb via oledb.
Error #: -2147217865 Description: The Microsoft Jet database engine cannot
find the input table or query 'MyTableName'. Make sure it exists and that
its name is spelled correctly.
-- 5khzgjf9e001@xxxxxxxxxxxxxx
.
- Follow-Ups:
- References:
- error says table not found error, but it does exist.
- From: James
- Re: error says table not found error, but it does exist.
- From: Michel Walsh
- Re: error says table not found error, but it does exist.
- From: James
- error says table not found error, but it does exist.
- Prev by Date: Re: Listing gaps in numbering sequences
- Next by Date: Re: Listing gaps in numbering sequences
- Previous by thread: Re: error says table not found error, but it does exist.
- Next by thread: Re: error says table not found error, but it does exist.
- Index(es):
Relevant Pages
|
