I've never worked with that product. Could you post some of the table structure? Can your client application work with MS SQL Server instead of MS Access?

I'd suggest that for an MS Access database you try the upsizing wizard.