Upsize Wizard/ Multi User System

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a db created in access 2000.
I want to split it and have the back end run on sql server v8.0 with the FE
being distributed as an access 2000 mde file.
Ive tried using the upsize wizard but it stops on the second screen where I
log in to the sql db (on another server) with the rather unhelpful 'Overflow'
Message.
Anyone else experienced this problem and know how to get round this.
Or is there another or a better way of acheiving this?

Thanks in advance
K
 
Hi,
Actually Access 2000 wizard has some bug, which produce such error. You can
make a copy of data file, delete all data and run wizard to create data
structure. and then use Transferdatabase method to export data there from
original DB
Or you can just export data to SQL server, and then spend some time to
create all indexes and relationships
 
Back
Top