Re: copying data from a SQL server to a MDB table
Why not link to the SQL Server table, rather than having a copy of it in
your MDB?
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Siggi Bjarnason" <SiggiBjarnason@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:2EC996BE-5F80-4F37-9DBE-9A65E735AFB3@xxxxxxxxxxxxxxxx
> Is there an elegant way I can insert data into a table in my mdb file from
> a
> SQL table using a single ADO call? Or do I just need to open two
> recordsets
> one to the SQL table and one to the local project and step through each
> record?
>
> I'm trying to come up with an elegant way to keep one of the tables in my
> mdb file synced to a table on my SQL server. Any ideas would be greatly
> appreciated.
.
Relevant Pages
- Re: From .mdb to .adp database
... I decided to go on with adp project, and i have created a store ... But queries are different stories. ... In SQL Server, there are Views, Stored Procedures, UDFs. ... Also, when you decide to use MDB front-end, you can choose use MDB ...
(microsoft.public.access.adp.sqlserver) - Re: From .mdb to .adp database
... there is no exact equivalent query object in SQL Server to MDB's query. ... Most likely, the wizard converts MDB queries to Viwes or SP, if the queries are convertiable. ... Also, when you decide to use MDB front-end, you can choose use MDB queries in the front end or use SQL Server side query objects. ... SQL Server is very powerful server software, whether you use MDB, ADP or anything else to access data from it, you MUST learn how to use it and almost for sure you need to learn another programming environment. ...
(microsoft.public.access.adp.sqlserver) - query problem with linked SQL tables when importing to new mdb file
... I'm using Access 2k with linked tables from MS SQL Server 2k db. ... front end mdb file and imported all the local tables, queries, forms, etc. ... I'm not importing the linked tables. ...
(microsoft.public.access.queries) - Re: From .mdb to .adp database
... there is no exact equivalent query object in SQL Server to MDB's query. ... Most likely, the wizard converts MDB queries to Viwes or SP, if the queries are convertiable. ... Also, when you decide to use MDB front-end, you can choose use MDB queries in the front end or use SQL Server side query objects. ... SQL Server is very powerful server software, whether you use MDB, ADP or anything else to access data from it, you MUST learn how to use it and almost for sure you need to learn another programming environment. ...
(microsoft.public.access.adp.sqlserver) - Re: Upsizing design considerations
... reports, with a ADP, or mdb (actually, it should be mde, or a ADE when you ... you would LINK the tables to sql server, and NOT USE a adp (the reasons is ... the first two remote users ...
(microsoft.public.access.gettingstarted) |
|
