Database Connection Strings

[IdahoSAM]

I have a few simple Access tables to store data in. The PF2002 wizards work fine for the input. However, I want to retrieve data from those table and concantenate the fields to create my own formatting. The wizards only allow table type views. I can not find any reference books that show how to set up a simple connection string, access the fields I need, and allow me to manipulate them. (for simple example-[LastName] & ", " & [FirstName] & " " & [MiddleInitial]. The reference books I have show me how to set up a SQL Server string, or a connection to a local harddrive using Access. How do I do it from within FRontPage2002? Thanks!!

 

[Tom Gahagan]

Check out...

http://www.connectionstrings.com/

for all your connection needs!

Best to you.....
Tom Gahagan

I have a few simple Access tables to store data in. The PF2002 wizards

work fine for the input. However, I want to retrieve data from those table
and concantenate the fields to create my own formatting. The wizards only
allow table type views. I can not find any reference books that show how to
set up a simple connection string, access the fields I need, and allow me to
manipulate them. (for simple example-[LastName] & ", " & [FirstName] & " "
& [MiddleInitial]. The reference books I have show me how to set up a SQL
Server string, or a connection to a local harddrive using Access. How do I
do it from within FRontPage2002? Thanks!!