Splitting Database/Username & Password

[hooi]

I have splitted my database, I now have:
Appliation: Project.mdb sitting at my office PC, the same copy is installed at other colleagues' PCs too.
Server: Project_be.mdb

Two questions:
1. I have two linked tables linking to another database via ODBC. Should I have the linked tables in the Project_be.mdb database (at the server machine) or should they be in Project.mdb (at the client PC)? Currently they are in Project.mdb, as a result, each client application will need to setup a proper ODBC to connect to the database. If I move the linked tables to the Project_be.mdb, does it mean I only need to setup ODBC once in the server?

2. My Project.mdb was secured before splitting. Now when I schedule to run a Macro in the application, it asks for username/password. Can I use the windows Scheduled Task to automatically supply the username/password so that the Macro can proceed smoothly?

Sorry for the long texts. Appreciate any help rendered.

 

[Autoeng]

Move the link to the BE. You can put a password into the shortcut to start a secured db without having to manually enter and would assume that you could do the same in Scheduler. I don't remember the shortcut syntax but am looking for it.

 

[Autoeng]

Finally found it. Better to point you to the entire article as there is a lot of interesting things wyou can do witin the command line.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209207

 

[hooi]

Thank you Autoeng for your help and effort.

 

[Autoeng]

I don't know what I was thinking. You can't link to a link, duh. Sorry to misdirect you hooi.

 

[hooi]

It's ok. Thank you anyway.

I just discovered that earlier today when I tried moving the link to 'be'.

Thanks Pat.