Sad Der
accessd666 at yahoo.com
Mon Jan 26 04:27:56 CST 2004
Hi group,
I've created a routine that creates a new DB.This
Temp_Db is created in the same directory as the FE.
I then use a couple of MAKE TABLE-queries to create
tables in the temp_db.
This worked great. Now, i'm getting errors that my
MAKE_TABLE-queries cannot find the Temp_db!?
I get this error:
Err.Number = 3024
Err.Description =Could not find file: C:\Documents and
Settings\....
As you can see it points to C:\Documents and Settings.
However the temp_db is created on my d:\projects\...
Here's the code I use:
*******************************************************
Else
Set db = Workspaces(0).CreateDatabase(strPath &
"TEMP_FE_" & strFile, dbLangGeneral)
Set db = CurrentDb()
Set qdf = New DAO.QueryDef
'------------------------------------------------
'Create tables in newly created database
'------------------------------------------------
'Loop through query list
For Each qdf In db.QueryDefs
'check if qryName starts with qryMake_
If InStr(1, qdf.Name, "qryMake_") Then
Call CreateTables(qdf.Name)
x = x + 1
End If
Next
Call MsgBox("The following objects have been
created:" & vbCrLf & _
" - Temporary database" & vbCrLf &
_
" - " & x & " Tables",
vbInformation + vbDefaultButton1, "Objects created")
End If
*******************************************************
Any idea's why it points to C:\documents and Settings?
When I created the make table queries I selected the
temp_db.
Sander
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/