Haven't done a lot of Access work and have some interesting requirements for a new project.
The project must have an Access 2000 front end. For now, it must work with an Access backend - probably a separate database via ADO. Here's the catch - it must be portable through a DAL (down the road) to SQL Server &/or Oracle &/or DB2.
I need to structure the project with a DAL and unbound forms (I guess) so that we can set a flag as to what backend is being used. Ideally I would like an example of how to do this and how to filter recordsets of subforms, using this architecture. Any suggestions where I might get a good sample?
The project must have an Access 2000 front end. For now, it must work with an Access backend - probably a separate database via ADO. Here's the catch - it must be portable through a DAL (down the road) to SQL Server &/or Oracle &/or DB2.
I need to structure the project with a DAL and unbound forms (I guess) so that we can set a flag as to what backend is being used. Ideally I would like an example of how to do this and how to filter recordsets of subforms, using this architecture. Any suggestions where I might get a good sample?