Re: How to avoid connection popup?

>> "Justin Hoffman" wrote in message
>> If you are not worried about security then you can save the password with
>> the linked table when you create the links.
>>
>> Hey
>> Thanks for the information. Security is not an issue in my case. So now
>> I'am wondering how I can save the password with the linked tables. I
>> can't find any option to save the password when i create the link. I
>> create the link from the menu, File, Get external data, Link table.
>>
>> mvh
>> Hallgeir
>
> Hi Hallgeir
> There are lots of variations on this theme, but here is one. Paste all
> the code into a new module, alter the two variables strConnect and
> strTableList so they match your requirements. Then compile and save the
> module. You can then type CTRL-G to get the immediate window and type
> ?RelinkTables() which should return true.
>
> It may seem strange to list the tables, but often the front end can link
> to one or more back ends and not all the tables are required - so
> explicitly listing them does give you more control.
>
Thank you Justin!
I tried your code and it worked just fine. This could be the solution of my
problems but there is still a small issue I have to solve. The linked tabels
in my access app can not have the same name as the tables in the sql server
database. By using two Tablelist variables (one with access app table names
and one with sql server database name) I manage to delete the existing links
and reconnect the tables with the names from the sql server database, but I
can't figur out how I can give the reconnected tables the name I want to
give them (the same name that I store in my first Tablelist variabel).

mvh
Hallgeir


.

Relevant Pages

  • Re: SQL server question
    ... Microsoft is deprecating it even for new development, ... An Access project is an Access file that provides a direct, ... You can connect an Access project to a remote SQL Server ... a local SQL Server database, or a local installation of the SQL Server ...
    (comp.databases.ms-access)
  • Exactly How to Use Disconnected Recordsets in VB / SQL Server Application
    ... Front-end is VB 6.0, back-end is SQL Server 2000 (actually, MSDE since ... underlying SQL Server database w/the assumption that the user *might* ... the local disconnected recordset on the user's machine would seem to ... time to update each and every record as each user scrolls through the ...
    (microsoft.public.vb.database)
  • Re: DataSet.GetChanges() in RowChanged(DataRowAction.Add)
    ... if the way synchronization needs to be handled changes in the ... > data stored in an SQL Server database. ... > GetChanges() call, but I feel that this workaround is not my best choice. ...
    (microsoft.public.dotnet.framework.adonet)
  • VBA Microsoft Access and SQL Server
    ... I am currently working on a project with Power Point. ... into a Microsoft SQL Server database. ... information from the Microsoft SQL Server database and re-populate a Power ...
    (microsoft.public.office.developer.vba)
  • Re: curious problem in production
    ... thank for the lesson on unique keys, but I suggest you read the question ... I am getting an exception from sql server ... >> trying to insert into the same sql server database. ...
    (microsoft.public.sqlserver.server)
Loading