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

 

[Pat Hartman]

If you are using A2K, the ADO library is higher in the library search list than DAO, therefore, you need to qualify all DAO objects. ie
Dim db AS DAO.Database
Dim rs AS DAO.Recordset
etc.

The other possibility is that the DAO 3.6 reference is missing entirely. Open any code module, click on tools/reference, find the DAO 3.6 library and check it.

 

[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.

 

[Pat Hartman]