473,320 Members | 2,052 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Convert from SQL Server to MS Access (yes that is not a typo)

I have a SQL Server database that is connected to a client server
program via ADO. I want this same program to be able to use JET as
the database back end (to provide a light alternative that doesn't
require a full install of MSDE or SQL Server.) I know that I can't
necessarily get a fully automated conversion, but I was wondering what
advice group members would have to make this conversion as painless as
possible (not to mention keeping the two in sync.) Perhaps there are
some tools out there that will break the back of the work? I haven't
used JET since 3.5, but I understand that 4.0 has support for stored
procedures. It is possible to convert SQL Server stored procedures to
JET stored procedures?
Thanks for your help.

Mar 2 '07 #1
1 1771
In Access, Views and Procedures are called Queries.

You can create queries to some stored procedures (e.g. parameter queries,
action queries), but JET does not support everything you can do in stored
procedures. Others will need to be reworked to use different functionality,
or split into separate queries.

If you use the ADOX library, you can list the Procedures separately from the
Views in Access code.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<nd*******@ziplip.comwrote in message
news:11*********************@30g2000cwc.googlegrou ps.com...
>I have a SQL Server database that is connected to a client server
program via ADO. I want this same program to be able to use JET as
the database back end (to provide a light alternative that doesn't
require a full install of MSDE or SQL Server.) I know that I can't
necessarily get a fully automated conversion, but I was wondering what
advice group members would have to make this conversion as painless as
possible (not to mention keeping the two in sync.) Perhaps there are
some tools out there that will break the back of the work? I haven't
used JET since 3.5, but I understand that 4.0 has support for stored
procedures. It is possible to convert SQL Server stored procedures to
JET stored procedures?

Thanks for your help.
Mar 2 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
by: Guy | last post by:
I got a big Access file (1 400 tables) to convert to SQL and I would like to be provided with some automated tools, except upsizing wizard and DTS, to convert it on my own. I got a lot of forms...
29
by: Mark B | last post by:
We have an Access app (quite big) at www.orbisoft.com/download. We have had requests by potential users to have it converted to an SQL version for them since there corporate policy excludes them...
25
by: cory | last post by:
Hi, I have an Access database and am having an ASP.NEt application written for it. It is almost complete. I have a hosting company that I signed up with a month ago but before I did anything I...
3
by: Karen | last post by:
I am attempting to upsize a 60MB database in Access 2000 to sequel server using the upsizing wizard. I go thru all the steps that it mentions in the book, but none of the tables are actually...
10
by: Woody Splawn | last post by:
I have been developing a ClientServer application on one machine at my office but the time has come to transfer it to the customer. The customer is running a Windows 2000 local area network. I...
4
by: Dave | last post by:
I've been running a mobile app for ten months with no problem on three different servers. When I installed the new netframework 2.0 It stopped working on two servers that the new framework was...
29
by: Jan | last post by:
Hi: I have an Access database that's been running (in one form or another) for a couple of different clients for a few years. Now a new client has requested that it be implemented with a SQL...
2
by: egoldthwait | last post by:
I need to convert a 17mb access 2000 db to Oracle and house it in a Citrix farm. The issue: we have never converted an Access Db to Oracle but can probably use Oracle's Workbench to assist with...
43
by: Steven T. Hatton | last post by:
http://public.research.att.com/~bs/bs_faq2.html#int-to-string Is there no C library function that will take an int and convert it to its ascii representation? The example Bjarne shows in his faq...
0
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
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...
0
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...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
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....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.