Since there is no 64-bit Jet (MS Access) OLEDB driver, what is the
recommended solution for this delimma.
Our application uses SQL Server as the daatabase engine, but we have
about 5 meg of static data stored in an Access database. We chose that
because it is easy to read, and can be password protected.
Since Microsoft doesn't have a 64-bit OLD to Access, the application has
to be set to run in 100% 32-bit mode to get it to run. This defeats the
purpose of having a 64-bit OS.
What are my options here?
Thanks.
Darin
*** Sent via Developersdex http://www.developersdex.com *** 23  4070 
Since you are already using SQL Server, why not move your static data to it
and use Access to link to the SQL static data?
Mike.
"Darin" <darin_nospam@n ospameverwrote in message
news:OT******** ******@TK2MSFTN GP02.phx.gbl...
Since there is no 64-bit Jet (MS Access) OLEDB driver, what is the
recommended solution for this delimma.
Our application uses SQL Server as the daatabase engine, but we have
about 5 meg of static data stored in an Access database. We chose that
because it is easy to read, and can be password protected.
Since Microsoft doesn't have a 64-bit OLD to Access, the application has
to be set to run in 100% 32-bit mode to get it to run. This defeats the
purpose of having a 64-bit OS.
What are my options here?
Thanks.
Darin
*** Sent via Developersdex http://www.developersdex.com ***
Ok, except that if it is in the SQL database, then when we install an
update on their system something needs to write new static data to the
SQL db, that was the purpose of Access - we can supply the MDB and it
never changes.
Our MDB has the menu (old access switchboard-type logic), and all of the
SQL definations for view, stored procedures, functions, etc.
Darin
*** Sent via Developersdex http://www.developersdex.com ***
Split your access into a front end user interface and a back end database.
Then move the back end to SQL Server.
Mike.
"Darin" <darin_nospam@n ospameverwrote in message
news:uc******** *****@TK2MSFTNG P05.phx.gbl...
Ok, except that if it is in the SQL database, then when we install an
update on their system something needs to write new static data to the
SQL db, that was the purpose of Access - we can supply the MDB and it
never changes.
Our MDB has the menu (old access switchboard-type logic), and all of the
SQL definations for view, stored procedures, functions, etc.
Darin
*** Sent via Developersdex http://www.developersdex.com ***
THe reasons for selecting the access mdb at the beginning was:
1. secure - can be password protected.
2. requires nothing additional on the computer to read it - everything
is builtin
3. Can supply a new mdb w/ ease for updates.
I am looking for something that is 64bit and has the same features.
THanks.
Darin
*** Sent via Developersdex http://www.developersdex.com ***
"Darin" <darin_nospam@n ospameverwrote in message
news:u4******** ********@TK2MSF TNGP02.phx.gbl. ..
>
THe reasons for selecting the access mdb at the beginning was:
1. secure - can be password protected.
Access's password is realatively easy to break.
2. requires nothing additional on the computer to read it - everything
is builtin
3. Can supply a new mdb w/ ease for updates.
Take a look at SQL Compact. I think this will do what you are looking for.
>
I am looking for something that is 64bit and has the same features.
THanks.
Darin
*** Sent via Developersdex http://www.developersdex.com ***
Mike.
Darin,
If it is that static, than why not just an XML dataset file?
Cor
"Darin" <darin_nospam@n ospameverschree f in bericht
news:OT******** ******@TK2MSFTN GP02.phx.gbl...
Since there is no 64-bit Jet (MS Access) OLEDB driver, what is the
recommended solution for this delimma.
Our application uses SQL Server as the daatabase engine, but we have
about 5 meg of static data stored in an Access database. We chose that
because it is easy to read, and can be password protected.
Since Microsoft doesn't have a 64-bit OLD to Access, the application has
to be set to run in 100% 32-bit mode to get it to run. This defeats the
purpose of having a 64-bit OS.
What are my options here?
Thanks.
Darin
*** Sent via Developersdex http://www.developersdex.com ***
Cor,
I think OP's real issue is that he already has a working management front
end in Access and doesn't really want to change this.
Mike.
"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:uB******** *****@TK2MSFTNG P06.phx.gbl...
Darin,
If it is that static, than why not just an XML dataset file?
Cor
"Darin" <darin_nospam@n ospameverschree f in bericht
news:OT******** ******@TK2MSFTN GP02.phx.gbl...
>Since there is no 64-bit Jet (MS Access) OLEDB driver, what is the
recommended solution for this delimma.
Our application uses SQL Server as the daatabase engine, but we have
about 5 meg of static data stored in an Access database. We chose that
because it is easy to read, and can be password protected.
Since Microsoft doesn't have a 64-bit OLD to Access, the application has
to be set to run in 100% 32-bit mode to get it to run. This defeats the
purpose of having a 64-bit OS.
What are my options here?
Thanks.
Darin
*** Sent via Developersdex http://www.developersdex.com ***
Michael,
I agree, however the change from an access database to an inside file is as
well an alternative as the SQL server alternative you gave. If he uses than
an SQL server as he already does, then he has an easier way with XML files
to create those.
(I hope it is readable I have changed the text 25 times)
Cor
"Michael D. Ober" <obermd.@.alum. mit.edu.nospams chreef in bericht
news:Xu******** *********@newsr ead4.news.pas.e arthlink.net...
Cor,
I think OP's real issue is that he already has a working management front
end in Access and doesn't really want to change this.
Mike.
"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:uB******** *****@TK2MSFTNG P06.phx.gbl...
>Darin,
If it is that static, than why not just an XML dataset file?
Cor
"Darin" <darin_nospam@n ospameverschree f in bericht
news:OT******* *******@TK2MSFT NGP02.phx.gbl.. .
>>Since there is no 64-bit Jet (MS Access) OLEDB driver, what is the
recommended solution for this delimma.
Our application uses SQL Server as the daatabase engine, but we have
about 5 meg of static data stored in an Access database. We chose that
because it is easy to read, and can be password protected.
Since Microsoft doesn't have a 64-bit OLD to Access, the application has
to be set to run in 100% 32-bit mode to get it to run. This defeats the
purpose of having a 64-bit OS.
What are my options here?
Thanks.
Darin
*** Sent via Developersdex http://www.developersdex.com ***
My front-end is VB.NET, not access. The access MDB only contains all the
SQL text for views, stored procedures, etc.
I can look at an XML file, I haven't worked with any yet. I know from
reading the XML don't load real fast, but this file wouldn't be read all
the time, only when an update is done.
Darin
*** Sent via Developersdex http://www.developersdex.com *** This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Juxta |
last post by:
Please could someone help.
I am using the Oracle OLEDB driver for a multithreadded VC++ app,
useing CComand and the DynamicAccessor (fixed version) and i am
crashing on the open when more than one thread is being used to create
CComand`s.
The crash happens deep in the internals of the ORAOLEDB driver. I
even sequentualised all CComand access using critcal sections but it
still happends.
I guess this is an obscure area that nobody else...
|
by: Satish Itty |
last post by:
I know this is more a Saleslogix issue than and .NET one. I thought I'll try
my luck here.
I'm trying to access Saleslogix database using SLXOLEDB driver in my .NET
application. This seems to work fine when I have the whole Saleslogix client
app installed on my computer. But when I have only the Saleslogix OLEDB
Driver I get an invalid case exception when I try to open a connection.
Here is the code snippet.
mConnString =...
|
by: m.posseth |
last post by:
To all ,,,
with VS.Net 2005 you can not access a Access database when this runs on a
64 bit system ( when compiled in CPU type anny or X64 )
i feel that MS should include a 64 bit Oledb driver , maybe if a lot of us
complain about this missing driver we encourage them to create one
http://lab.msdn.microsoft.com/productfeedback/
|
by: sheebahezi |
last post by:
Hi ,
I'm using AS400 server in a project. When i try to set the connection for an ODBC Driver it gives an error mesage( The setup routines for the iseries Access ODBC Driver could not be found.Please reinstall the driver)
how doi proceed with.Pls help
|
by: Jeff |
last post by:
I need to export MySQL data to Access.
As always, there seems to be more than one way to do this.
I notice that PHP has: DB.php
If I was doing this in perl, there would be an ODBC driver
(DBD::ODBC). Is there such a thing in PHP? Can this play well with DBO?
I see some commercial driver products, but my needs are modest as I'm
| | |
by: BobLewiston |
last post by:
I'm working through the lessons at Programmer’s Heaven's "C# School" tutorial (http://www.programmersheaven.com/2/Les_CSharp_0), and I'm currently on lesson 13, "Data Access in .Net using ADO.Net", so of course I've been trying to connect to Programmer’s Heaven's SQL and MS Access / OleDb databases. Unfortunately, they're now offline. Can anyone please tell me; are there other such databases available for those learning ADO to practice...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
| | |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
