Split Database question

  • Thread starter Thread starter Cathy
  • Start date Start date
C

Cathy

I'm considering spliting a database into a front end/back
end type system... something I've never done before. I
have about 50 users that have their drives structured
differently. How can I create the attachment between
desktop and network drive without including a drive letter
designation? Or is there a routine I can use that will
look up the correct drive and then attach it?

Thanks,
Cathy
 
Consider using \\ComputerName\ShareName\DatabaseName naming convention
instead of DriveLetter:\ShareName\DataBaseName.

This should be the same for all of the users that are attaching to the same
backend database, regardless of what the local drive mappings are.

Ron W
 
After the split is done, go to Tools>>Database Utilities>>Linked Table
Manager

Select All tables, check "Always Prompt for New Location" and click OK.
When you browse to the back-end database, go through network neighborhood or
my network places. Dont browse by drive letter.
 
Back
Top