By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,583 Members | 617 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,583 IT Pros & Developers. It's quick & easy.

Upsize access 97 to sql server express

P: n/a
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.

Mar 27 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On 27 Mar 2006 07:30:40 -0800, "R.E.V."
<ri********************@navy.mil> wrote:

I interpret that to mean: you can't upsize LINKED tables, only local
tables.

-Tom.

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.


Mar 28 '06 #2

P: n/a
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?

Mar 28 '06 #3

P: n/a
Tom

No, I cant upsize anything because of the error I get.

REV

Mar 31 '06 #4

P: n/a
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

Mar 31 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.