Do a search at the Knowledge Base at support.microsoft.com using the
keywords "upsizing" to review the various white papers on upsizing
Access to SQL Server as well as to ensure you have any updates
Also see my Random Thoughts on SQL Server Upsizing from Microsoft
Access Tips page at my website.
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
What I have is Access 2000 front-end and DB and I want to
get Access 2000 front-end that will work with SQL 2000 DB
which should be created from Access 2000 DB. I hope this
makes it understandible now.
Aha ... The problem is that you use the term "Project" in the original post.
An Access Data Project (ADP) is different from an Access Database: an ADP
already uses an MS-SQL Server database as the back-end in the Client-Server
In you case, you have an Access Database as the Front-End and another one as