Maybe I misunderstood. Are you working from the Access side, or from the SQL Server side? In Access 97, you would open any module and then click Tools ~ References...

I think MS has actually diluted the value of their certifications by introducing so many new certs. Much like the way they have introduced multiple editions of Vista (4), Office...

Certifications are like college degrees - they demonstrate your desire for learning and self-improvement, and they can give you a competitive edge when applying for a position, but they are...

I think you've hit the nail on the head. The system board has integrated video with an Intel 815E chipset, no Vista drivers are available, so it is using a...

Mark, thanks for the tip.

However, I might just have a bad PC here, dunno. I attempted connecting using RDP from another machine that is running Windows Server 2003 R2 Standard...

If your question is - how to loop thru the tables in Access...

Set a reference to the DAO object library, then use something like this:

Dim db As DAO.Database, tdf As...

Ed, my current question is - have you used Remote Desktop into Vista? The connection seems unstable.

I'm using Vista Business from my MS Action Pack subscription.

After further testing I realized that my Vista BSOD happens when I'm using Remote Desktop, connecting from Win XP Pro SP2 to my Vista test PC. This has happened quite often...

Here is Marty's other thread, many more details about getting Vista, SS2005, IIS and SSRS all working together

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=381755#bm382837

AFAIK to uninstall an instance, you would need to run the SQL install CD and one of the first couple screens will allow you to remove an instance.

Nimish,

I didn't do anything special to install SS 2000 Dev on Vista Business, just like you I simply ignored the warnings and it finished installation without crashing. I can only...

Ed,

You said "SQL 2000 SP4 and SQL 2005 are both less tolerant of data type mismatches than earlier versions, and this can make queries run much slower." Can you...

Well, you learn something new every day. Thanks for the tip.

UDT's make things difficult for the application developer, because you can't call them by name from .NET so the app dev has to go look up the true data type and...

If you kept the 2003 MDB format, you might have to change the macro security level to enable the code to run. That "project is locked" message might be one...