Monzer George Yazigi said:
Dear All
I'm looking to build an application that is database independent.
Meaning it can either work with Access DB or MS-SQL depending on User
selection.
any suggestion of how to do so?
There are a few things you're going to want to watch out for. The ones
that occur to me offhand, in no particular order, are:
1. Don't try to use table-type recordsets. Don't expect to be able to
use the Seek method in a recordset.
2. Avoid the use of user-defined functions in your queries, especially
not as criteria or sort fields. SQL Server won't know about them, so
Access won't be able to hand off such queries to run completely on the
server.
3. Don't expect an autonumber ID for a new record to be available until
after the record has been saved. That will be true both o forms and
when you add records via a recordset.
4. Design every table with a primary key.
5. Avoid forms, combo boxes, and list boxes that query all the records
in large tables. Instead, set up user interface mechanisms to narrow
down the set of records to be extracted from the database at any one
time, and use query criteria to extract just the records you want to
work with.
