linked tables password request

[qwertyjjj]

I upsized my Access db to SQL server and all the tables were automatically linked.
Unfortunately, it now asks me for the username and password everytime I open the db and this is usually a distributed application so I don't want users to see this.
Is there a way to add the db string in code?

I know Access can save the linked tables and passwords through it's linking wizard but then it adds dbo_ to the beginning of each table name, which won;t work with all my current VBA code.

 

[boblarson]

I upsized my Access db to SQL server and all the tables were automatically linked.
Unfortunately, it now asks me for the username and password everytime I open the db and this is usually a distributed application so I don't want users to see this.
Is there a way to add the db string in code?

I know Access can save the linked tables and passwords through it's linking wizard but then it adds dbo_ to the beginning of each table name, which won;t work with all my current VBA code.

Just use the linking wizard and select the Save Password checkbox. And, then you can right click on the tables that say dbo_Etc and rename them. It works just fine to rename them without the dbo part. I have a database I do that on. In fact, in my case I have a database that was originally created by someone else with a lot of queries. Our group got this but we have to connect to a view that doesn't even have the original name of the table that they linked to. So, I linked to the view named "AAA" and renamed it to "MyTable" (not the real names) and it works just fine.

 

[brickelldb]

I just recently used the upsize wizard for the first time and it actually preserved all of my original table names.......they just show up linked with their original table names. However, in the SQL db they do have the dbo prefix. Hopefully this helps at all...(even though just a regurgitation of the previous post).

 

[brickelldb]

whooooaaa....2 year old post...i feel like an idiot

 

[wiklendt]

whooooaaa....2 year old post...i feel like an idiot

LOL, i've done that myself on occassion - funny isn't it!? i've then even had the thread revitalised with extra discussion on the original topic! ha!