access forms and sql server

[thersitz]

I recently imported an Access db into SQL Server 2005. Is it possible for me
to use the original Access Forms to connect to the SQL Server version of the
db? This isn't a db I upsized from within Access.

thanks

 

[John W. Vinson]

I recently imported an Access db into SQL Server 2005. Is it possible for me
to use the original Access Forms to connect to the SQL Server version of the
db? This isn't a db I upsized from within Access.

thanks

Yes... with some tweaking, probably. You will need a Primary Key defined on
each SQL table; and it can help a lot to add a Timestamp field to the SQL
table as well (you don't need to do anything with it, just so it's there).

You can use ODBC to create a connection to the SQL tables.

See http://www.granite.ab.ca/access/sqlserverwhy.htm and references therein
for some of the issues that you'll be facing.

John W. Vinson [MVP]

 

[Guy]

Thersitz,

Did you upsize just the data in the database or to an .ADP?

Guy