VB6 Modify MS Access 2003 Field Names

Hi

I have been out of the programming world for a little while. I think am
attempting to something quite simple. All I want to do is create a VB6 Exe
file that takes a MS Access 2003 mdb file, opens a table and modifies the
field names in it.

The reason I need to do this is because the field names are too long and I
need to shorten them so that I can connect to it from Oracle 10g.

I know how to do this in DAO but I would like to use ADO instead. Does
anyone know how to do this? The best thing would be if someone could give me
some code, that would be great. If not just a pointer in the right direction
would be fine.

Thanks in advance

Chris


.

Relevant Pages

  • how to create a mdb file from the flat file through an automated process?
    ... when you wanted to create your new .mdb file ... the code that will automatically import the CSV file (this ... You will need to look up "command ... That would be a better question for the Programming ...
    (microsoft.public.access.externaldata)
  • Re: ODBC Paths
    ... Does anyone know a way to get the path associated ODBC data source via ... programming. ... i also need the path for the mdb file with it. ... I would suggest retrieving that information from the registry. ...
    (comp.databases.ms-access)
  • Remote Connection
    ... pardon my ignorance, I am new with this programming. ... using a .mdb file is there a way to tell Visual Basic that the .mdb file is ... Dim dbsC as DataBase ...
    (microsoft.public.vb.database.dao)
  • Re: Query exists in MSysQueries, but not in db anymore
    ... Chris. ... If it is a multi-user program, you *really* need to split it. ... Split your MDB file into data and application ... Perth, Western Australia ...
    (microsoft.public.access.modulesdaovba)
  • Re: Multiple users opening linked .cvs files
    ... "Chris O'C via AccessMonster.com" wrote: ... file into an mdb file and link to that table with the form's code and you ... they get an error msg. ... I need multiple users to be able to use ...
    (microsoft.public.access.externaldata)