By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,642 Members | 2,136 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,642 IT Pros & Developers. It's quick & easy.

expression works under XP, not under VISTA

P: 5
The expression

Set mydb = Workspaces(0).OpenDatabase(namMastDB)

where namMastDB is properly defined works under XP (not to mention under 95, 98, NT, 2000 and ME). Subsequent code referring to mydb.varname works.

However, under VISTA, the expression leaves mydb defined as "nothing" and subsequent use of the variable fails.

Any hints would be most welcome. Thanks

Herb
Dec 20 '07 #1
Share this Question
Share on Google+
5 Replies


Dököll
Expert 100+
P: 2,364
The expression

Set mydb = Workspaces(0).OpenDatabase(namMastDB)

where namMastDB is properly defined works under XP (not to mention under 95, 98, NT, 2000 and ME). Subsequent code referring to mydb.varname works.

However, under VISTA, the expression leaves mydb defined as "nothing" and subsequent use of the variable fails.

Any hints would be most welcome. Thanks

Herb
Hello, herbeber!

What does the property of Vista say?

where namMastDB is properly defined works under XP
Dec 21 '07 #2

Expert 5K+
P: 8,434
My guess woul dbe that it's not exactly Vista which is the problem, but the version of DAO or ADO (whichever you're using). Occasionally between versions they have changed the way things are addressed.
Dec 21 '07 #3

P: 5
Hello, herbeber!

What does the property of Vista say?
I am not sure what you mean. How do I get that? Thanks for trying to help.

Herb
Dec 21 '07 #4

P: 5
My guess woul dbe that it's not exactly Vista which is the problem, but the version of DAO or ADO (whichever you're using). Occasionally between versions they have changed the way things are addressed.
Thanks. I went from ADO to DAO a couple of years ago - moving to 98. It was tough. Since then DAO has been the standard and OS changes have not affected that until now. Can you suggest any source for further info?

Herb
Dec 21 '07 #5

Expert 5K+
P: 8,434
I believe our DAO experts are most active in the Access forum.
Dec 22 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.