[dba-SQLServer]OLEDB Connection

Julie Reardon-Taylor prosoft6 at hotmail.com
Mon Feb 17 11:18:11 CST 2003


Okay.  I'm convinced.  Will never use ODBC for my connection to SQL again.  
Trying to upsize to an Access Project.  Please excuse my ignorance as a 
newbie.  Everything went well, but I have a couple of questions.

When I choose to connect to the sql database, the tables appear just fine in 
my project.  Am I seeing the actual tables, or are they linked?  In other 
words, if I delete a table (which I am not going to do, but just in case) am 
I deleting the actual sql table or just my link to the table (as would be 
the case in an odbc connection)?

Because I am already using an odbc connection, when I upsize, the wizard 
wants to upsize my tables a well(which already are sql tables).

I created a new project and just imported all forms, reports, etc.  I don't 
get the option to import queries.  Obviously, they need to be upsized to 
views, but I'm not sure how to do that.

See, I am definitely a newbie!



Julie Reardon-Taylor
PRO-SOFT OF NY, INC.
www.pro-soft.net




_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8. 
http://join.msn.com/?page=features/junkmail




More information about the dba-SQLServer mailing list