Hi all,
I have converted all our company relations into a MS Access database and I want to import it into Lotus Notes.
I have the following configuration:
1PC with running with
XP professional
Designer 6.5
Domino
MS Access Database with company relations
I have used all the instruction of lesson 10 of the intermediate course.
in summary:
-
I have the decs-task running on the server
-
I created the data source on the server with an ODBC connection to the MS Access database
-
I created the DCR to the different MS Acces tables (using the browseMetadata button)
-
I created the forms using the browse option to connect to the DCR in the default tab
-
Per form per field I marked the External data source and used the browse option to fill out external references
But still when I want to import external records I get the following error:
“Server error: File does not exist”
I really have no clue what file doesn’t exist. Any ideas???
What may be related or might be a coincidence.
If I try to lookup information from the same database in the following scenario:
Database1 does a lookup in Database2
In a form field in Database1 I have a combobox
@DbColumn(“”“”;“ServerName”:“DatabaseName1”;“viewName”;1)
this runs well,
but when I omit the ServerName
@DbColumn(“”“”;“”:“DatabaseName1”;“viewName”;1)
I get the error “Server error: File does not exist”
It seems like I need to have a complete path in order for the database to be recognized.
Does my problem has any thing to do with the way you implement a database on the server?