sql server and jet in same project

[Guest]

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

 

[Rebecca Riordan]

You'll need to attach the tables from the SQL and Jet MDB's.

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

Hi
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?

 

[MacDermott]

I could be wrong on this, but I think you'll be better served with an mdb.
AFAIK, the SQL Server engine reads only SQL Server, where Jet (using ODBC)
can read both.
As Rebecca says, you'll want to link all of your data files to your "front
end" database.

HTH
- Turtle

Hi
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?