Ratter
01-16-2008, 06:59 AM
I am using the upsizing wizard to convert a Access 2003 db to SQL Server.
I have finally worked out how to create an application which doesn't require a SQL server logon (an exercise in extreme frustration:confused:) but if I want to add a linked table or refresh a link I cannot do so without using one of the saved DSN's which then requires a login for that table.
So my question is, when you use the upsizing wizard it must embed the DSN in the Access database somewhere. Where is it located and can you add extra linked tables with this internal DSN using code (because you can't using the linked table manager)?
Is there an easier way to do this? (and don't say "trusted user" because we are on a Novell network)
I have finally worked out how to create an application which doesn't require a SQL server logon (an exercise in extreme frustration:confused:) but if I want to add a linked table or refresh a link I cannot do so without using one of the saved DSN's which then requires a login for that table.
So my question is, when you use the upsizing wizard it must embed the DSN in the Access database somewhere. Where is it located and can you add extra linked tables with this internal DSN using code (because you can't using the linked table manager)?
Is there an easier way to do this? (and don't say "trusted user" because we are on a Novell network)