Please help I need to specify the current server and directory of the database on the server on local machine for remote users. At present I do a DB_Look in a view with the path and database name but this is a pain to maintain with 15 databases.
The server is "Development"
The path is "\ABCWorks\Development\Version1"
The database is "Supplier.nsf"