|
I could not find any jdbc driver for ms access.So how can I connect MS Access with JPA ?
Started by Ibrahim AKGUN on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Look at the article is an unsupported, bug-ridden 1.0 driver that is incredibly slow and is rumored to leak memory in some ODBC driver.
Just use a sun ODBC driver.
It doesn't look like you need a MS driver at all.
|
|
Would you recommend working with multiple programmers on an MS Access application?
One of our MS Access application has grown to the point where the number of changes (bug fixes) and new features can no longer be handled by one programmer in the requested...
Started by Marien on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
We did not explore this path I am not a... .
Microsoft's own version control add-in for MS Access 2000/2002/2003 for about 5 years now, and I can't there are other options to be used to integrate MS Access with version control.
|
|
I'm trying to use Microsoft Access as the db for a demo project that I'm thinking of doing in either Code Igniter or CakePHP. Ignoring the possibly folly of using MS Access, I haven't been able to figure out precisely how the connection string corresponds...
Started by sprugman on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Express (free!) engine instead and just import/export your MS Access db? You could thank me laterTry setting up a DSN and changing to the following:
$db['access']['hostname'] = "<dsn name>"; $db['access']['username']....
|
Ask your Facebook Friends
|
We distribute an application that uses an MS Access .mdb file. Somebody has noticed that after opening the file in MS Access the file size shrinks a lot. That suggests that the file is a good candidate for compacting, but we don't supply the means for...
Started by Corey Trager on
, 10 posts
by 10 people.
Answer Snippets (Read the full thread at stackoverflow):
Access (....
Compacting an Access database (also known as a MS JET database) is a bit like defragmenting a hard drive.
Risk though -- a bug in Access 2007 would occasionally delete your database during the process.
|
|
Does anyone have an idea what this error means or how to solve it? I am using Access 2003 and SQL2005. It comes up when trying to add a record on a particular subform.
[Microsoft][SQL Native Client] Invalid character value for cast specification (#0)
...
Started by Dale Halliwell on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
For non supported data types ms sure they match up (just bring up the tables in design mode in ms-access -- you get an error message not have the right....
And you want to check the data type that ms-access assumes here.
|
|
I have an issue occurring in Microsoft Dynamics GP, and am doing research to see if this is the cause,but this could be a Access to SQL Server issue. GP stores data in SQL Server, and MS Access is being used to access the table data. Some data appears...
Started by Kinze on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Is it your intention that Access should be allowed to change or delete data?
If not, have you considered setting up a user ID for use by Access that permits read-only access (no pun intended)?
In any case, a SQL Server best practice....
|
|
I was inserting data into a MS Access database using JDBC-ODBC driver. The blank mdb file was 2KB. After populating this database, the size grew to 155MB. Then I was deleting the data. But I found the size of mdb remains the same as 155MB. I don't get...
Started by Dean on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
You can free the space, use the Compact and Repair utility:
Backup your database, as there is a bug in Access 2007 that may it automatically when ....
MS Access doesn't free up space used by records even after they are deleted.
|
|
Hi,
I have a legacy app I am currently supporting that is having problems when people copy large quantities of data from a datasheet view.
The App is built in MS Access and the amount of rows being copied can get pretty large (sometimes in the thousands...
Started by evilhomer on
, 5 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
I am not sure what the problem is but sometimes you can run into some very quirky bugs with Access the data into Excel and then import into Access using import functionality? Can you import the data from a datasheet view in Access....
|
|
I'm upsizing an existing MS Access backend to SQL Server 2008 and, because we want to use SQL Server Merge replication , I'll have to change all current primary keys (currently standard autoincrement integers) to GUID.
So here are the questions:
Any recommendation...
Started by Renaud Bompuis on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
This way rows with identical IDs will not be generated... .
You can still use your auto-increment integers and allocate different ranges to different database instances .
However, you do not HAVE to use GUIDs to do merge replication .
This may be slightly off-topic.
|
|
We've inherited a rather large Access DB that has some very strange (and unsettling) behaviour: Some updates to the database are lost. What can we do to avoid this? Are there any settings in Access to provide better transactional control?
Here are some...
Started by IronGoofy on
, 5 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
It's probably not worth....
To get the obvious solution over and done)? There is transaction processing that you can do with MS Access, but I've found it to be a pain in the butt.
Inherited MS Access is always the best,isn't it.
|
