Question regarding Upsizing to SQL

[4281967]

I have an application that uses linked tables. The front-end has several queries, macros, modules, etc. If I upsize to SQL, and relink the tables in the front-end application, is it safe to assume that it will still function as before?

 

[M8KWR]

yes as long as the field names are the same, i moved from linked dbase files to sql (via dsn)

Hope this helps

 

[4281967]

thanks - not familiar with dsn - know any good places to read up on this?

 

[M8KWR]

dsn files are created in the adminsitration tools in the control panel, then going to data sources, the to the tab of file dsn.

Just follow the on screen prompts, its quite easy.

I use these to link to each sql databases that we have internal.

Then in access where you link to a table/file, i would select the ODBC database options, and then it would display all the dsn files, and then show you the tables or view you are able to link to in the sql database.

When you are linking the tables just make sure you select the option of save password, saves the username and prompt appearing each time you load the access file (unless you require this of course for security reason)

If you need any more info then please say.