Suggestions for Uploading to SQL Server

[molsonexpert]

Hi All.

I have an Access 2002 db split with a front-end and back-end. Some data
(less than a dozen fields) from the Access tables need to updated to 3
tables on an SQL 2000 server. In a test environment, I've created an ODBC
driver to the SQL server, and I've created an update query in Access, which
seems to work fine. Will this type of setup work OK? I have about 10 users
on the Access db. Or is there a better/more efficient solution?

thanks.

steve.

 

[Larry Linson]

Should work just fine. You can link to the shared Jet tables and also to
the SQL Server tables. Even if all the performance and corruption factors
aren't perfect, ten users should be "duck soup".

If you'd prefer, you could convert and use an SQL Server db as your "back
end", but I caution that even SQL Server (which seems to be the
most-user-friendly of the server database genre) will require some
administration that the Access/Jet shared tables database will not.

For multiuser issues, microsoft.public.access.multiuser is a good newsgroup;
and microsoft.public.access.odbcclientsvr has information on using
ODBC-compliant databases with Access.

Larry Linson
Microsoft Access MVP


Larry Linson
Microsoft Access MVP