Hi,
Almost all of my forms, subforms and reports are based on query in Access. Tables are ODBC linked ones. I renamed them to to their orginal names. Everything is woking smoothly.
I would like to know that would it be better if I shift my Access queries to server db? Would all they work properly? After taking a back up copy of my db, I tried to depot all my queries 'as is' to server db like tables. And then tried to re-link them all in my db same like what I did with tables. I found they are all apearing in Table tab of db in window where all the tables are already available. Is this the way they works? I thought that they will be apprearing under Query object tab.
Would they work? Or Is this the right way? I am using Server 200 personal edition.
Please advice.
With kind regards,
Almost all of my forms, subforms and reports are based on query in Access. Tables are ODBC linked ones. I renamed them to to their orginal names. Everything is woking smoothly.
I would like to know that would it be better if I shift my Access queries to server db? Would all they work properly? After taking a back up copy of my db, I tried to depot all my queries 'as is' to server db like tables. And then tried to re-link them all in my db same like what I did with tables. I found they are all apearing in Table tab of db in window where all the tables are already available. Is this the way they works? I thought that they will be apprearing under Query object tab.
Would they work? Or Is this the right way? I am using Server 200 personal edition.
Please advice.
With kind regards,
Last edited: