Where'd they go?

[Gorio]

I was trying to build some code when Access would not let me diminsion a variable name as a database. Inititally I was just cut and pasting some old code that I was going to reuse and Access would hang at the dimiension statement. But when I tried to write it myself, it failed to show it as an choice. I also noted that it would not give me the choice of deleteing a record.

Can someone give me any ideas on where I've gone wrong?

Thanks

 

[HiArt]

That's not all, I can't dim a recordset either! I've taken to using varients to get by, e.g. DIM dbs AS VARIENT.

What a jolly good question. Here's hoping for a good answer!

HiArt

 

[Gorio]

I'll give it a look see in the morning. I am using A2K, but I find it interesting that on two databse systems made on the same machine, one allows the dim and the other doesn't. Not complaining as long as I can get it to work, just curious why it works on one database and not the other.

And thanks for the help Pat. You are a great resource here.