Hello
I've seen a number of posts concerning the above type of conversion but
have not been able to locate anything that gives a clear set of
instructions to accomplish this.
Here is my problem, I have an application to be converted from access
97 to SQL Server Express (backend) and VIsual Basic.NET (frontend). I
have the upsize wizard installed and visible in access as an add-in.
SSE has been downloaded and installed as well.
- Selecting "Tools / Add-ins / Upsize to SQL-Server displays
the "Upsizing Wizard window.
- The "Use existing database" option is chosen.
- Clicking on "Next" displays the "Select Data Source" window.
- The Machine Data Source tab is selected.
- The entry "MS Access Database" is highhighted.
- Clicking "OK" displays the "Select Database" window.
- The source database is located and highlighted, "OK" is
clicked.
At this point, I receive an Upsizing Wizard error message that states
"You cannot use ODBC to import from, export to, or link an external
Microsoft Jet or ISAM database table to your database."
Any help in resolving this problem would be appreciated.
R.E.V.
Tom van Stiphout - 28 Mar 2006 05:04 GMT
I interpret that to mean: you can't upsize LINKED tables, only local
tables.
-Tom.
>Hello
>
[quoted text clipped - 24 lines]
>
>R.E.V.
R.E.V. - 31 Mar 2006 15:52 GMT
Tom
No, I cant upsize anything because of the error I get.
REV
Lyle Fairfield - 28 Mar 2006 15:20 GMT
I've never used the UpSizing Wizard. I generally avoid all wizards as
most of them seem to be witches or warlocks or whatever an evil wizard
is called.
So I'm asking, why not just import the tables from the backend and then
apply the wizard?
R.E.V. - 31 Mar 2006 15:54 GMT
Lyle
I'm looking for the simplest way to perform the conversion. Is it
possible to do it in just one step? Why am I receiving an ODBC error??
REV