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

• Next in forum: Migrade Oracle data to SQL Server 2000
• Prev in forum: Re: My design - where did I go wrong?
• Thread view: Upsizing questions

[Reply to this message]