for migration of an ASP-website I need to convert a quite small database
that is currently running on the SQL-Server 6.5 to a local Access7.0
Any idea.... ?
thanks in advance
The free Access97 "Upsize Wizard" (available from
http://support.microsoft.com/support/downloads I think, when the website
works - try during off-peak hours) works okay for small databases. For large
databases, it sucks, though, because it does the transfer in one
transaction, and thus requires HUGE log files, which cannot be shrunk down
in size after you're finished!!!
Examine the Modules section of the upsize wizard for global declarations
that allow you to modify a few important things you can't modify in the GUI
(like timeout values).
> for migration of an ASP-website I need to convert a quite small database
> that is currently running on the SQL-Server 6.5 to a local Access7.0
> Any idea.... ?
> thanks in advance
After upsizing an Access 7 database with upsizing wizard to SQL server 6.5
I cannot update nor delete records. Get error messages klike "data has ben
changed by another user" (update) or "Data changed. Abort operation"
I tried upsizing both with triggers and with DRI. Yes, my tables do have a
primary index. I played with the ODBC driver and checked different
configuration. Didn't help.
Anybody out there with some more ideas? Help is very much appreciated.
4. With Excel