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.
| Author |
Topic |
|
ARok
Starting Member
3 Posts |
 Posted - 2006-02-19 : 15:44:27
|
| The following problem is in Access 2003 as front end and SQL Server Express holding the data.I have about 50 tables in Access linked to the SSE.When I try to open and work with the linked tables using the following code, some of the table works fine and other give error 3622.********************************************Dim Tab1 As Recordset, DB1 As Database, SQL1 As StringSet DB1 = CurrentDbSQL1 = "SELECT * FROM Any_Table"Set Tab1 = DB1.OpenRecordset(SQL1, DB_OPEN_DYNASET)do the required work with Any_TableTab1.Close: Set DB1 = Nothing********************************************I can not figure out why some table open fine and some give error.If I use ADO all tables will open without problem but it works much slower then the code above.I appreciate any help.Thanks |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-02-20 : 03:49:17
|
| Please don't cross post [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62018[/url] |
 |
|
|
ARok
Starting Member
3 Posts |
Posted - 2006-02-20 : 04:00:19
|
| I just got the solution from another forum, a dbSeeChanges option must be added to the open statment.Hope it may help someone, this issue is solved.Sorry about the cross post - the problems is connected to both forums |
|
|
|
|
|
|
Open linked SQL Express table in VBA