Jumat, 09 September 2011

[MS_AccessPros] Re: File DSN Sample

 

Abraham

Thanks for letting us know you got the sample.

Actually, you only need the DSN file initially to link the tables. Once it is done, Access uses a connection string stored in the table MSysObjects, but your idea is how I would do it.

Be sure to read my article at:
http://thatlldoit.com/howtosarticles.aspx#sqlbackend

While it was written for SQL Server, a lot of it might still apply to your database.

Bill

--- In MS_Access_Professionals@yahoogroups.com, "Abo" <abraham@...> wrote:
>
> I think I found the info I need at http://www.connectionstrings.com/
>
> Abraham
>
> --- In MS_Access_Professionals@yahoogroups.com, "Abo" <abraham@> wrote:
> >
> > Hi,
> > This is not strictly an Access question, but is related.
> >
> > I have a client-server Access aplication and I want to move the database back-end to MySQL and continue using the Access front-end.
> > The application will be used by a number of people, and may need to be set up on client machines by someone who is not really an IT person, but is a power user. I would like to make this setup procedure as easy as possible for this person.
> >
> > I though of linking the Access tables to the MySQL back-end using a file DSN, hoping that all that will be needed is that one file and the client front-end will pick up the odbc connection from that file.
> >
> > I would really appreciate a sample file DSN, complete with host, placeholder username and placeholder password. The ones I have found on the Net are either for different databases or are not complete.
> >
> > Any alternative methods are also welcome.
> >
> > Thanks.
> >
> > Abraham
> >
>

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.


How Bad is Your Score? Use this Free, Easy Way to See Your Score. freecreditscore.com.
.

__,_._,___

Tidak ada komentar:

Posting Komentar