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,
....?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Does Microsoft recommend databases or projects to connect to SQL s 1
Jet links and SQL links = failure ? 1
Transfer data from any mdb file to sql server? 0
Transfer data from any mdb file to sql server? 1
Unable to make design changes in .adp connected to SQL server 2008 1
Opening a Project in SQL Server Using VBA 8
SQL server database and Project 2007 4
VBA Excel data to SQL Sever table 1

Top