CODEWITHSUNDEEP
ms-access
nman84
nman84

Reputation: 435

creating more forms after exporting MS Access database

I have MS Access 2007 database with forms and tables, until now i did not know that size limit of a access database is 2 GB.

So if export the access database to SQL server express using upsizing tool, will the forms be migrated or can i still use access database for form interface, while keeping sql express for storage. Otherwise do i need to create those forms again?

Upvotes: 0

Views: 49

Answers (1)

ChrisPadgham
ChrisPadgham

Reputation: 870

You can retain your access database just as it is but instead of having your tables in a MSAccess database you have them as linked tables from SQL Server.

Check out http://www.aspfree.com/c/a/Microsoft-Access/Linking-SQL-Express-2005-Tables-to-MS-Access-2007/

or http://office.microsoft.com/en-us/access-help/import-or-link-to-sql-server-data-HA010200494.aspx

Upvotes: 1

Related Questions