Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / March 2006

Tip: Looking for answers? Try searching our database.

Upsize access 97 to sql server express

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
R.E.V. - 27 Mar 2006 16:30 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.