converting sql 6.5 to access

Hey,
I have a SQL 6.5 db that I need to make accessible to a user for occasional
queries. The SQL server itself is being retired. Can I convert it from SQL
6.5 to Access? How would I do this?
tia,
jj
Hi,
Access can not hold the data if the SQL 6.5 database is more than 1 GB or so
( Not so sure). I recommend you to keep SQL 6.5 or
upgrade it to SQL 2000.
Steps to convert:-
To easily convert all of your SQL tables on a regular basis to Access
tables, you could:
1. Link the SQL tables you will need
2. Build Make Table queries for each table you wish to port to Access
3. Create a code that deletes the records in the local tables and runs the
make table queries to bring in the latest records from
SQL Server.
You can also use SQL 6.5 to replicate tables to move data to Access.
Thanks
Hari
SQL Server MVP
"jj" <jeff_detoro@.urmc.rochester.edu> wrote in message
news:%23BEPPS2PFHA.1268@.TK2MSFTNGP14.phx.gbl...
> Hey,
> I have a SQL 6.5 db that I need to make accessible to a user for
> occasional queries. The SQL server itself is being retired. Can I convert
> it from SQL 6.5 to Access? How would I do this?
> tia,
> jj
>