M
MarcVS
I've done the upsizing of my Access database with the SSMA wizard of Access.
This has worked well, but I've got the following problem:
On a lot of places I have this code:
Set DB = DBEngine.Workspaces(0).Databases(0)
Set MyTable = DB.OpenRecordset("Name_Of_Table", DB_OPEN_TABLE)
When I run the code, it gives me an error:
'Illegal operation' (something like that, I have a Dutch Access...)
I've changed the DB_OPEN_TABLE to DB_OPEN_SNAPSHOT. This works on some
places, but when I have:
Set DB = DBEngine.Workspaces(0).Databases(0) ' Create database
reference.
Set MyTable = DB.OpenRecordset("Name_Of_Table", DB_OPEN_SNAPSHOT) '
Create table reference.
With MyTable
.Edit
!FactuurPrint = False
.Update
End With
I get an error:
'The Operations is not available for this type of Object'
I suppose this is because a SNAPSHOT is read-Only.
Does anyone know a solution for this?
Marc
This has worked well, but I've got the following problem:
On a lot of places I have this code:
Set DB = DBEngine.Workspaces(0).Databases(0)
Set MyTable = DB.OpenRecordset("Name_Of_Table", DB_OPEN_TABLE)
When I run the code, it gives me an error:
'Illegal operation' (something like that, I have a Dutch Access...)
I've changed the DB_OPEN_TABLE to DB_OPEN_SNAPSHOT. This works on some
places, but when I have:
Set DB = DBEngine.Workspaces(0).Databases(0) ' Create database
reference.
Set MyTable = DB.OpenRecordset("Name_Of_Table", DB_OPEN_SNAPSHOT) '
Create table reference.
With MyTable
.Edit
!FactuurPrint = False
.Update
End With
I get an error:
'The Operations is not available for this type of Object'
I suppose this is because a SNAPSHOT is read-Only.
Does anyone know a solution for this?
Marc