views not displaying results in .adp

[Jason]

Hi,

I'm working with Access 2002 and SQL Server 2000. I've created a bunch of
views in Query analyzer/Enterprise manager but i'm not able to view the
results in my Access .adp. I've tried the Northwind .adp and I can view the
results in Access. I've tried making new views in Access and still I can't
view the results. I can view the results of all my views in Enterprise
Manager.

Help is greatly appreciated.
Thanks,
Jason

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If you create Views in EM while the Access application is open the new
Views won't appear until you refresh the connection: File > Connection;
or, until you open the application again.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQjzEcYechKqOuFEgEQLfBQCfeI5+9vT2LZ8Yd+hzC//MW/StZlkAn1n7
+VM68yfuMR5+ZgvM13bxLm2n
=F3NR
-----END PGP SIGNATURE-----

 

[Jason]

realised that the database was corrupted somehow. Rebuilt the database and
everything is working good now.
jason