Posted by John on 07/31/05 06:47

Hi

I have a fairly complex access frontend/backend app which I need to upsize
to SQL Server. At this stage I would prefer to use access as frontend. I
have the following questions;

1. Should I keep using the mdb as frontend or switch to an adp (access
project) instead? Any reasons?

2. I have used IIF (immediate if) frequently in access queries. When
converting queries to SQL Server, is there an easy way to replace the IIF
function?

3. Is it possible for access frontend to connect/link to two separate SQL
Server dbs, main and archive at the same time?

Thanks

Regards

[Back to original message]