Re: Login to FE as 2 different users?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

"robert" wrote in message:
news:576cc278c66a5@xxxxxx

> I'm not sure I understand what your exact problem is, but I had a similar
> situation, except that I have probably closer to 500 SQL statements in VBA
> Code.
>
> If your concern is that you need to rewrite your SQL statements, then let me
> suggest an alternative that was suggested to me.
>
> 1) Leave your SQL statements as is
> 2) Instead, rename your tables by putting the letters 'tbl' in front of the
> table name: so if table name is Products; new table name is tblProducts
> 3) Create RWOP queries on these tables that have the name that the table
> previously had. So the name of the RWOP query in my example is Products.
>
> That way you don't have to rewrite your SQL statements in code.

Interesting idea Robert!
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html


.

Relevant Pages

  • Re: Generating SQL
    ... > application developers have to rewrite any sql statements whenever db ... > designer adds a column is ridiculous. ... Of course that SQL is crappy, but you're talking exactly of legacy code ...
    (comp.object)
  • Re: Login to FE as 2 different users?
    ... When I was forced to go to RWOP queries, ... a huge panic because I thought I would have to rewrite all of the VBA code ... Fortunately, for us amateurs, there are forums like this where one can ... except that I have probably closer to 500 SQL statements in VBA ...
    (microsoft.public.access.security)