Upsized to SQL - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

Upsized to SQL

Author

Topic

slimjen
Yak Posting Veteran

61 Posts

Posted - 2006-11-01 : 13:24:09

I don't know if I am in the correct forum, but I upsized one of my Access databases (just the tables) to SQL. When I browsed around in my database, certain form functions gave me a message that I had to put DBSEECHANGES, when opening a recordset, in the code. I did. Now, some of the functionality giving me an "Invalid Argument" error. Can someone tell me what's wrong and how to fix it please.
Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-11-12 : 11:28:33

Are you still using DAO to connect to database?
Switch to ADO.

Peter Larsson
Helsingborg, Sweden

eddied
Starting Member

5 Posts

Posted - 2006-11-16 : 18:38:59

Hope this helps! "ADO ConnectionString"
Dim cnn As ADODB.Connection
Set cnn = New ADODB.Connection
cnn.Open "provider=sqloledb;data source=big-sis;Trusted_Connection=yes;" & _
"database=TestLogSQL"

eddied
Starting Member

5 Posts

Posted - 2006-11-16 : 18:41:14

second reply;
(big-sis)=your serverName
(testLogSQL)=your Initial catalog or database Name

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources