I have an Access 97 Front End (solid workhorse that will eventually be converted). The data currently resides in an Access 97 mdb on the network. Another department is implementing a SQL Server 2005 backend. I was hoping to DTS the Access data into the SS DB, then have the front end link. Can I do this with 64 bit SQL Server 2005 or do I have to go with 32 bit?
Thank you
Thank you