sql server and jet in same project

M

madhouse

H
using access 2003 adp mode.
want main sql server database for central common data
want a separate MDB file (jet database) for each project. there maybe many hundreds of projects
want separate mde for forms and code
would like built in data binding to work so presumably there is a way to set the "current database" for each form as it activates

any clues or advice or recommendations would be most welcome
 
J

Jeff Boyce

What's the underlying business need to have "separate MDB file for ... many
hundreds of projects"? Will all these projects have the same data? Or are
you describing something like: project1 is a freeway overpass, project2 is
writing a book, project3 is developing a CD collection software application,
....?
 
Top