Hi
I have to make export of SQL Server Database to MS Access and I have
done it with the tables but now I need to transfer(export) the
relations, keys and indexes. Can any1 tell me how to read relations,keys
and indexes from SQL Server and convert them to MS Access.(it seams that
for creation of indexes in MS Access ADOX is the only way but ADOX
cannot read all information about keys,indexes from SQL Server.)
All I can see is that I have to use SQLDMO to enumarate all
realtion/keys/indexes from SQL Server database and use ADOX to create
this relations/keys/indexes in MS Access database, but I don't know
exact matching attributs of relations/keys/indexes from SQL to Access.
Thanks 3 2969
Hi
You posted the same question in microsoft.public.sqlserver.programming. If
you are not sure about the answers you were given then please do not cross
post.
John
"Bose" <bo*****@sympatico.ca> wrote in message
news:zt*********************@news20.bellglobal.com ... Hi I have to make export of SQL Server Database to MS Access and I have done it with the tables but now I need to transfer(export) the relations, keys and indexes. Can any1 tell me how to read relations,keys and indexes from SQL Server and convert them to MS Access.(it seams that for creation of indexes in MS Access ADOX is the only way but ADOX cannot read all information about keys,indexes from SQL Server.) All I can see is that I have to use SQLDMO to enumarate all realtion/keys/indexes from SQL Server database and use ADOX to create this relations/keys/indexes in MS Access database, but I don't know exact matching attributs of relations/keys/indexes from SQL to Access.
Thanks
I do that becouse I didn't get the answer. I need some page where I can
see Access contraparts of SQL Server keys/indexes.
John Bell wrote: Hi
You posted the same question in microsoft.public.sqlserver.programming. If you are not sure about the answers you were given then please do not cross post.
John "Bose" <bo*****@sympatico.ca> wrote in message news:zt*********************@news20.bellglobal.com ...
Hi I have to make export of SQL Server Database to MS Access and I have done it with the tables but now I need to transfer(export) the relations, keys and indexes. Can any1 tell me how to read relations,keys and indexes from SQL Server and convert them to MS Access.(it seams that for creation of indexes in MS Access ADOX is the only way but ADOX cannot read all information about keys,indexes from SQL Server.) All I can see is that I have to use SQLDMO to enumarate all realtion/keys/indexes from SQL Server database and use ADOX to create this relations/keys/indexes in MS Access database, but I don't know exact matching attributs of relations/keys/indexes from SQL to Access.
Thanks
Hi
I don't think you will get a more authorative answer than from Mary.
Have you considered MSDE?
John
"Bose" <bo*****@sympatico.ca> wrote in message
news:bN**********************@news20.bellglobal.co m... I do that becouse I didn't get the answer. I need some page where I can see Access contraparts of SQL Server keys/indexes.
John Bell wrote: Hi
You posted the same question in microsoft.public.sqlserver.programming.
If you are not sure about the answers you were given then please do not
cross post.
John "Bose" <bo*****@sympatico.ca> wrote in message news:zt*********************@news20.bellglobal.com ...
Hi I have to make export of SQL Server Database to MS Access and I have done it with the tables but now I need to transfer(export) the relations, keys and indexes. Can any1 tell me how to read relations,keys and indexes from SQL Server and convert them to MS Access.(it seams that for creation of indexes in MS Access ADOX is the only way but ADOX cannot read all information about keys,indexes from SQL Server.) All I can see is that I have to use SQLDMO to enumarate all realtion/keys/indexes from SQL Server database and use ADOX to create this relations/keys/indexes in MS Access database, but I don't know exact matching attributs of relations/keys/indexes from SQL to Access.
Thanks This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mike MacSween |
last post by:
My client has an MS Access database application on her local machine. I have
full access to that in terms of changing the design.
I've got a simple PHP/MySql application on shared hosting, so no...
|
by: JJ |
last post by:
Hi,
usually, I'm not using MS servers, but I have a big problem with a
Access table.
I should create a web application for a Historical Dipartment.
They have create a populated a Access...
|
by: BUSHII |
last post by:
I have big problem.
In database MyDB.mdb I have table for example: ORDERS with colums:
- Id int
- Name varchar(20)
Also I create same table in SQL Server 2k.
I can manualy export this data...
|
by: Tim Eliot |
last post by:
Just wondering if anyone has hit the following issue and how you might
have sorted it out.
I am using the command:
DoCmd.TransferText acExportMerge, , stDataSource, stFileName, True
after...
|
by: David Lauberts |
last post by:
Hi
Wonder if someone has some words of wisdom.
I have a access 2002 form that contains 2 graph objects that overlay each
other and would like to export them as a JPEG to use in a presentation....
|
by: Chris Cox |
last post by:
I'm trying to put together a simple access database that will allow a friend
to maintain a simple database of products/pictures/prices, which he can then
export to html and upload to a website.
...
|
by: phillip.s.powell |
last post by:
We're looking at a GUI interface for our MySQL DB and I am interested
in MySQL Administrator, however, one of our requirements is to be able
to import/export databases. Is this possible or do I...
|
by: maflatoun |
last post by:
Hi,
In SQL 2000 if I wanted to take a complete copy of another running sql
database all did was create a new database locally and right-click it
and select import and point to another database...
|
by: learning_codes |
last post by:
Hi ,
I'm wondering if there is a way for me to export some tables including
data and structure from old database to a new database and then save as
new database name.
I try to create a marco...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |