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:48:44
|
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.ThanksI 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. |
|
|
mikewa
Microsoft SQL Server Product Team
84 Posts |
Posted - 2006-02-21 : 03:43:45
|
| If anyone is wondering what the difference between the tables that needed dbSeeChanges and those that didn't...The most liekly cause is that dbSeeChanges is needed in DAO when working with tables containing an Identity field.Regards,Mike WachalSQL ExpressThis posting is provided "AS IS" with no warranties, and confers no rights.Use of included script samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.htm |
 |
|
|
|
|
|
Open linked SQL Express table in VBA