Modifying the database with sql statements

  • Thread starter Brandon Owensby
  • Start date
B

Brandon Owensby

Is there away to create querys, indexes, or primary keys using sql
statements in access? I'm using a Microsoft.Jet.OLEDB.4.0 connection from
a csharp program to access Access. I'm trying to copy data to another
location with this program but I need to create one of the above to make it
more efficient. I'm not wanting to manually do it because we will be
downloading a new version of the databae periodically and having to run this
program again and again and I don't want anyone to have to manually edit the
database everytime we download a new version.

Does anyone have any thoughts?

Thanks,
Brandon
 
R

Ron Hinds

Brandon Owensby said:
Is there away to create querys, indexes, or primary keys using sql
statements in access? I'm using a Microsoft.Jet.OLEDB.4.0 connection from
a csharp program to access Access. I'm trying to copy data to another
location with this program but I need to create one of the above to make it
more efficient. I'm not wanting to manually do it because we will be
downloading a new version of the databae periodically and having to run this
program again and again and I don't want anyone to have to manually edit the
database everytime we download a new version.

Does anyone have any thoughts?

Thanks,
Brandon
Click to expand...

Search Access Help for "CREATE INDEX", "CREATE TABLE"
 
Top