Hello, i'm in big troubel. please help me !!

I'm working on access XP, and my database is on SQL server.
I have migrated my access database to SQL using a DSN configurated with configuration tools on windows.

But If I delete my DSN, i could see anymore my tables.

I try to make a connection with connectionstring with windows security login, and it works. But i can't anymore see my tables.

Moreover, when i try to run my querys or my macros (using DAO.recordset), it doesn't work...

So, i would like to know :
- Is an ADO connection is compatible with DAO code to access the tables ?
- How can i see my tables in access without a DSN ?

HELP ME !!!!!!!!!!!!! PLEASE

I'm in hurry.. so help me..

I can answer the second question: You can't. You need a system DSN in order for you to connect to your SQL server - this is true whether you are using Access or any other application.

These connections go to your ODBC data in the registry for information on how to connect. If that data is not there, then your apps won't know where to go for the connection.

When you connect your tables from Access (link or import), you need to select ODBC Data Sources as your file type. If that DSN is not in the list, then you can't get any further in making your connections.

If you made the connections and then deleted the DSN, you have to recreate it, then delete the old table references and recreate them in Access (unless it is only connected through your code.)

I hope this helps.

mmcdonal

answer to Q1: No, you cannot use DAO code with an ADO connection.

answer to Q2: You can create a DSN-less connection.

cnn.Open _
"Provider= MSDASQL;Driver=SQL Server;" & _
"Server=<TheNameOfYourServer>;" & _
"Database=<TheNameOfYourSQLDatabase>;UID=sa;PW D="

You will need to replace the text between the <> with the appropriate values (do not include the < or the >). You may also need to change the UID and/or password (PWD).





Rand

Ok, ,i have understood.
But my problem is :
I have got a batch which will run at time and launch an access mdb. But this access mbd won't have a DSN configuration. So i believe, i must have a connection with my database using ADO connectionstring.
Nevertheless, all the parts of my application are using DAO code, So is a ADO connection can work with a DAO code ?

You can always re-write your DAO code as ADO. In this case it may be worth the effort. If you're dealing with SELECT recordsets the changes are relatively simple to do. One of the best references I've found for this is Microsoft Access Developer's Guide to SQL Server, Mary Chipman and Andy Baron, SAMS (2000)

Rand