473,394 Members | 1,554 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,394 software developers and data experts.

.mdb or .accdb?

ARC
I have another question. With Access 2007, as I understand it, you only need
to use the .accdb if you are using features such as memo notes history, or
the multiple selections for a given key id.

Prior to deploying my program in Access 2007, I need to make sure I'm using
the correct formats. I have a handful of misc. databases, one for workspaces
/ temp. tables, local config options and a to-do list. Should I use the .mdb
format for these, instead of the .accdb? I guess I'm wondering about speed,
and if the .mdb is faster / more stable, maybe I shouldn't be using the
..accdb at all?

Anyone have any experience with the pro's and cons for .mdb versus .accdb?

Many Thanks,

Andy
Aug 20 '07 #1
4 7470
>
Anyone have any experience with the pro's and cons for .mdb versus .accdb?

Many Thanks,

Andy
I think the deciding factor would be what version of ms-access the end users
have.

If you using the new free "runtime", or expect all users to have a2007, then
use the new format.

If you going to have different versions (say, a97, a2000, a2003 and a2007)
all working on the same data at the same time (this works), then you have to
use a mdb in the *lowest* common format for the back end file.

So, sure...use the new format.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Aug 20 '07 #2
ARC
Oh yes, a couple more questions. So if I add RE, should I then go through
all my code and remove instances where I do the RE myself? Also, when I
write ugprade code to import user's existing data from A97, what will happen
on the import if there is orphaned data? I would assume it would simply not
import, which would be desired actually.

Thanks again, Albert.

Andy
"Albert D. Kallal" <Pl*******************@msn.comwrote in message
news:VXoyi.74978$rX4.46052@pd7urf2no...

Anyone have any experience with the pro's and cons for .mdb versus
.accdb?

Many Thanks,

Andy

I think the deciding factor would be what version of ms-access the end
users have.

If you using the new free "runtime", or expect all users to have a2007,
then use the new format.

If you going to have different versions (say, a97, a2000, a2003 and a2007)
all working on the same data at the same time (this works), then you have
to use a mdb in the *lowest* common format for the back end file.

So, sure...use the new format.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com

Aug 21 '07 #3
ARC
I'll be distributing the runtime. However, end user's could potentially have
functions to link to the data for other reasons.

The only new things I've tried to use are the RTF on memo fields, and I
tried the option for keeping memo history (which I understand necessitates
the .accdb file). However, I can't get the memo history to work, even with
the new table setting set to yes. So maybe I should resave all db's as
straight .mdb's.
"Albert D. Kallal" <Pl*******************@msn.comwrote in message
news:VXoyi.74978$rX4.46052@pd7urf2no...

Anyone have any experience with the pro's and cons for .mdb versus
.accdb?

Many Thanks,

Andy

I think the deciding factor would be what version of ms-access the end
users have.

If you using the new free "runtime", or expect all users to have a2007,
then use the new format.

If you going to have different versions (say, a97, a2000, a2003 and a2007)
all working on the same data at the same time (this works), then you have
to use a mdb in the *lowest* common format for the back end file.

So, sure...use the new format.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com

Aug 21 '07 #4

"ARC" <an**@andyc.comwrote in message
news:0Z*****************@newssvr19.news.prodigy.ne t...
Oh yes, a couple more questions. So if I add RE, should I then go through
all my code and remove instances where I do the RE myself?
Well, the deleting part, sure..you might want to remove that code. As I
noted in the other post, I consider still a good idea to "test" for child
records when you do NOT want a deletion to occur in those cases.
Also, when I write ugprade code to import user's existing data from A97,
what will happen on the import if there is orphaned data? I would assume
it would simply not import, which would be desired actually.
Yes, if you enforce relationships, then importing orphaned data into a child
table is not permitted, and they will be ignored...
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Aug 21 '07 #5

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

Similar topics

34
by: radink | last post by:
Well, I've got my DB ready to go. Now what? I need to host it on our Win2003 server. How do clients use it? I think im getting more confused as I try to figure this out. We are a small company...
1
by: Chris | last post by:
How do you stop a user from double-clicking on .ACCDB file of 2007 and being able to see the tables' and queries structure ? If the solution is the database password, then database cannot open...
3
by: Robert | last post by:
I understand that new features would not be available but is there any way I could open an accdb database in Access 2003? Robert
9
by: Adamowski | last post by:
Hello, I have a 2007 access database named sales.accdb. If I open it, then immediately close it, my folder will have the following: - sales.accdb - sales1.accdb If I open sales.accdb...
21
by: Cele Balser | last post by:
Can someone tell me the VBA code to use in my module to select the External Data ribbon? I have a module that runs through some queries and at the end of them I want to export the query to Excel. I...
0
by: brendanmcdonagh | last post by:
Hi all, I have been working with java on a database program that connects via jdbc odbc access driver on my xp desktop. It is working fine but I'm installing it on 3 pc's tomorrow so testing it...
11
by: wassimdaccache | last post by:
Dear friends I am working on access 2007 sp2. I do have a database(accdb) i converted it to accde. While I am opening the converted database the VBA code is not working. For example...
4
by: MrDeej | last post by:
Anybody now if i can do this programtically? My challenge is that i have a maybe 10 distributions a week with updates and changes which i now have found the accde format to be of good use. I also...
5
topher23
by: topher23 | last post by:
This may seem odd, but is it possible to connect an mdb to an accdb back-end?
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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...
0
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...
0
tracyyun
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...

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.