|
Microsoft Access is pretty good with Microsoft SQL server - just use the 'Import/Link tables' manager in there and give it the details. I've set up a system like that recently (I have to point out it wasn't my choice to use MS SQL) and it works fine... Only problem is that Access likes to send your Windows logon username and password to the server if it gets the chance!
__________________
I can't understand why people are frightened of new ideas. I'm frightened of the old ones. -- John Cage (1912 - 1992)
|