Yes, it is possible. It may well be beyond the scope of a newsgroup posting
though..
For starters, there is an Access Upsizing wizard that will do some of the
work for you, but not all of it.
Or, you can import the tables from SQL Server DTS services.
Its up to you whether to leave your queries in Access or convert them to SQL
Server stored procs....
Once you move the tables, you have the option of sticking with Access .MDB
for the fornt-end or an Access Data Project (.adp).
HTH,
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
