by Dave » Thu, 15 Aug 2002 06:28:52
by Paulo Pint » Thu, 15 Aug 2002 10:52:01
Migrate your Access databases to Access 2000 (or 2002 even better)
Then upgrade your database to the SQL server (if it's an access 2000 you'll
need a patch to access the SQL server 2000. The file name is accsql.exe). In
the process of upgrading choose a client-server application.
You'll have an extra work refining your queries (since they were transformed
into views and stored procedures, and some of them in *nothing*) but in the
end you'll get a very good working copy of your early work.
Well. After that, and after installing MDAC 2.6 or greater, you can allways
link the SQL tables in the Access 97 databases until you can tweek the
application up.
Good luck
Paulo Pinto
Quote:> I have a multitude of Access 97 databases that I would
> like to use as front-end apps, but I would like to know
> the best way to migrate tables to sql 2000, and connect
> them with the Access 97 counterpart.
1. Record locking: Access 97 front end and SQL 7 back end
I am trying to use Record Locks property to lock record(s) in SQL 7
attached table from Access 97 front end, it seems to me that it is not
supported from Access 97 form.
Any idea to work around!
Sent via Deja.com http://www.deja.com/
Before you buy.
2. Backup server starts with error
3. ACCESS 97 fron-end/SQL-Server 6.5 back-end app: table-locks when only displaying data
5. Access 97 Front End Sql Server 2000 Backend
6. Using PostgreSQL transactions through MS Access?
7. SQL7 Backend Access 97 Front end
8. Please help !! Passing variable from one form to another
9. VB6 front / Access 97 back end multiuser question
10. Using Synonyms for Front-End/Back-End
11. using Progress as back end and Visual Basic app as front end
12. Access 2000 Front End Linked to SQL 7 Back End
13. migrating an Access front end to an SQL back end