Hi there,
I am in desperate need of some assistance in trying to regain functionality of a large amount of Functions from my Database.
Today i converted my databses Which consist of a Front & Back end to accdb / 2007 from mdb / 2000 in an attempt to try and reduce the frequency of database corruption.
I have worked through a lot of code changes. However i am REALLY struggling with one method of query update (not written by me originally) that was working fine before updating the database files.
When trying to run the SQL / QueryDef Access Simply states Unable To find the output table "tblMaterialIssueRequestLineItems".
This is a table on the back end that is linked to the front end, i can open the table and see all of the data so i am really confused as to why i am being given this error. I have tried to the bellow code to reference CurrentDb instead of DBEngine.Workspaces(0).Databases(0) but am given the same error message. I am witts end with this and there alot of users waiting on a fix for similar functions.
The declarations / QueryDef section:
Any help would be greatly appreciated.
Thanks
Alex
I am in desperate need of some assistance in trying to regain functionality of a large amount of Functions from my Database.
Today i converted my databses Which consist of a Front & Back end to accdb / 2007 from mdb / 2000 in an attempt to try and reduce the frequency of database corruption.
I have worked through a lot of code changes. However i am REALLY struggling with one method of query update (not written by me originally) that was working fine before updating the database files.
When trying to run the SQL / QueryDef Access Simply states Unable To find the output table "tblMaterialIssueRequestLineItems".
This is a table on the back end that is linked to the front end, i can open the table and see all of the data so i am really confused as to why i am being given this error. I have tried to the bellow code to reference CurrentDb instead of DBEngine.Workspaces(0).Databases(0) but am given the same error message. I am witts end with this and there alot of users waiting on a fix for similar functions.
The declarations / QueryDef section:
Code:
Dim MyQuery As QueryDef, alcnrs As DAO.Recordset, isreqrs As DAO.Recordset, matlsrs As DAO.Recordset, _
polirs As DAO.Recordset, grpdstkrs As DAO.Recordset
Set MyDb = DBEngine.Workspaces(0).Databases(0)
If Me![POSTED] = 0 Then
'* Post Request Line Item records
Set MyQuery = MyDb.CreateQueryDef()
MyQuery.NAME = "FILL MATERIAL ISSUE REQUEST LINE ITEMS"
MyQuery.sql = "INSERT INTO [tblMaterialIssueRequestLineItems] SELECT[qryFillMaterialIssueRequestLineItems].* FROM [qryFillMaterialIssueRequestLineItems]"
MyDb.QueryDefs.Append MyQuery
MyQuery.Execute
MyQuery.CLOSE
MyDb.QueryDefs.Delete "FILL MATERIAL ISSUE REQUEST LINE ITEMS"
Any help would be greatly appreciated.
Thanks
Alex