I Cant see my shortcut

  • Thread starter Thread starter Joannie
  • Start date Start date
J

Joannie

When Im in my word document tring to do a mail merge. I select "select a
different list" under "Use an existing list" and "Select Data Source" pops up
so that i can do a "look in" to find what i want and when i go to my Secured
db's shortcut wich is in my F drive it does not show the shortcut. Is there a
way around this or is that just the way Access is any ways please write back
soon.
 
"Joannie".

Joannie said:
When Im in my word document tring to do a mail merge. I select
"select a different list" under "Use an existing list" and "Select
Data Source" pops up so that i can do a "look in" to find what i
want and when i go to my Secured db's shortcut wich is in my F
drive it does not show the shortcut. Is there a way around this or
is that just the way Access is any ways please write back soon.
Click to expand...

This is not an Access question. I think that the problem is that
your shortcut is a shortcut to msaccess.exe, not to an mdb file.
In order to access you secured database, click "new source", then
select "more/advanced". Then you can specify the conneciton to
your secured database as follows:
On the Provider tab click "Microsoft Jet 4.0 OLE DB Provider".
On the All tab enter the path and filename of the workgroup file
in the "Jet OLEDB: System database" property. Then, on the
Connection tab, specify the mdb file and the logon information.
Test the conneciton and proceed creating the odc file.
 
Back
Top