Newbie Can't connect to Access db - where is info cached?

[worc]

I have an Access database that has had major modifications, including deleting tables and queries. When I went to create a UD record source, my connection seemed to be looking for the old tables. I deleted my site, deleted my connection, went into ODBC and deleted the ODBC connections to the database and then recreated them. When I create a new connection , "test" is ok. I verified the new ODBC connection from Excel and it works. When I make my UD connection, I see the 2 tables in my db - but when I "test" I get an error msg that the "microsoft Jet database engine cannot find the Input table or query "Customer", which is the name of one of the old deleted tables. I have rebooted, checked for ldb files. What else can I do?
Thanks!

 

[schase]

I'm guessing you are viewing from pages that had recordsets previously with the old data - maybe your modifying those recordsets?

If so, well look out, cause thats an illegal offense in some smaller third world countries.

Okay just kidding - but you'd think UD4 acts that way at times.

If this is indeed the case - Not to panic - open the page - dbl click the recordset (note you will often have to do this twice), it will often find the new data right then.

Now, if you have references in the page for the old data - it will give you errors just like your describing. Gotta change those to reflect the new.

Often with UD4 it's easier to highlight the asp in the server behaviors window - being careful not to delete needed functioning items - delete them, delete references in your tables - and start over.

"Insert witty remark here"

Stuart

 

[worc]

Thanks for the input, Stuart!

I am using a brand new page - haven't put much of anything on it. So I don't have an page with an old recordset to update.

 

[schase]

Ok, check a couple of things.

Where you say "I "test" I get an error msg that the "microsoft Jet database engine cannot find the Input table or query "Customer", which is the name of one of the old deleted table"

Which tells me that you do have reference for it somewhere.

Either you've modified the tables in one database - but your actually pulling from a copy of the before-modified database.

Or - The page is not actually brand new. - there may be residual code left inside it.

Or your modifying a page thinking it's a different one (maybe it's in a different folder). I've done that one a few times before.

do this

Make a new table inside that database
with 3 fields

Field1 - ID - autonumber & primary key
Field2 - fldName - text
Field3 - fldPassword - text also.

Name the table tblTest - open the table up and put in the first row - under fldName put MLAWSON then in fldPassword put "isdopey" (no quotes). let the autonumber autonumber the ID field.

Now in a brand new - and I mean new page - create your recordset, and make a quick 2 cell table. Drag fldName and fldPassword into one cell each.

Save it as testdopey.asp

Upload the database & the testdopey.asp

then browse to it.

"Insert witty remark here"

Stuart

 

[worc]

OK Stuart - I created the new table as you suggested, and was able to successfully create a recordset from it. However, when I go to add a new recordset and try to use the other tables I still get that jet error, where the connection is looking for an old delete table/query. I will keep digging to see where that old reference might be!

 

[schase]

Are you talking on the same testdopey.asp ?

same page I mean. "Insert witty remark here"

Stuart

 

[Ladyborg]

Did you try deleting the recordset and making a new one? I think your problem is that the old recordset is still looking at the old db.

Hope that works. I'm pretty sure that's how I solved that problem. Ladyborg
"Don't be afraid to try new things,
Remember: professionals built the Titanic, amateurs built the Ark"

 

[worc]

Yes Stuart I was on the testdopey and had the recordset for the new table you had me add - but I can't add other recordsets from the other tables. I've deleted all other recordsets and connections that referred to older version of db. I am re-creating the database (it was a very small new one) and I expect that will be my work-around.

If I find anything I'll be sure to post it!

Thanks!

 

[schase]

This is pretty darn strange.

Where it ""microsoft Jet database engine cannot find the Input table or query "Customer", which is the name of one of the old deleted tables" That is a recordset looking for a database's table field. Which it cannot find.

Looks like at this point you are certainly recreating the recordsets (and the database) Earlier, did you try to copy the recordset code over? or create a new one when you referenced the table.

Somewhere it is trying to find that field - maybe you have it down inside a html table's field or something - somewhere it's looking for a field that is no longer there. If you have totally wiped out html references for it, and recreated a recordset there is nothing left to try. If you have done the above and there are still errors than there must be a reference for it in something like a hidden field, html table cell, somewhere. "Insert witty remark here"

Stuart

 

[worc]

It IS weird! I am not having any problems creating a recordset using my brand new re-entered database, so I am up and running for now.

Thanks again for your inputs!

 

[schase]

Sorry I couldnt help further. "Insert witty remark here"

Stuart