473,802 Members | 2,468 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Replica Access Database - Autocreating new mdb file when Opened

2 New Member
I am working on an replica Access database with VB Coding that is used by multiple computers. On some computers, when one opens the database - a db1.mdb will appear as if it's copying itself. For other computers, this doesn't occur. All are using Windows XP and Windows Access 2003. The more one opens the database from some computer the more the db#.mdb appear -- yet all the data is still being stores and received by the Replica/Design Master. What could be causing this issue?
Oct 31 '08 #1
3 2402
debasisdas
8,127 Recognized Expert Expert
I thik you are refering to .LDB file. That file appears when you open a database exclusively and disppears when you close the mdb file. that shows the loked status of the database file.
Oct 31 '08 #2
MRileyDE
2 New Member
No, it actually is creating a new database. When I stopped the compact on close command, so did the creation of new db1.mb and on...
Oct 31 '08 #3
debasisdas
8,127 Recognized Expert Expert
kindly post you code that you are working on for reference of our exerts and further discussion on the topic.
Oct 31 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

10
6050
by: MHenry | last post by:
Hi, We were going merrily along for 6 years using this database to record all client checks that came into our office, including information about what the checks were for. Suddenly, network computers cannot access the database. The message is...
0
1428
by: manning_news | last post by:
Using A2K. I've researched this newsgroup and can't find the answer to my question. As we all know, when a database is turned into a Design Master, another database is created called "Replica of {database name}". Can that replica then be moved (not copied but moved) to a laptop? A previous database developer set up a replica for a department who uses a laptop. A copy of the replica is on the laptop but then there's a copy of the...
3
7905
by: Russell Read [MSFT] | last post by:
Hi all, I am using VB script in ASP to access a MS Access database. This works fine until I want to access the same db placed on a file share. The code I am using is... 'create connection object Set db = Server.CreateObject("ADODB.Connection") 'specify the database provider
4
1521
by: Shiva | last post by:
Hi, I'm trying to get familiar with the concept of replica's, but it still confuses me a bit. Here's my situation: 1) my database application, *.mdb file, should be distributed from time to time to a friend of mine. His copy of the database is completely detached from my database (no connection through shared networks, internet etc). 2) I'll keep the design master, my friend should only have replica's
1
2256
by: MAILTONRK | last post by:
Hi, I am a Mainframe guy. I am working with MS access(maintaining a application) for the last 2 weeks. I had one master database and four replicas. One of my replica had trouble in synchronization(It said, database is in use..). After searching google, I ran "Compact and repair" utlity against my replica. It looks like, it has changed the attribute of my replica.
34
2621
by: Mathieu Trentesaux | last post by:
Hello I downloaded Office 2007 for this reason : It seems, once again, that it is impossible to save any modification done in a VBA library, from the main project in Access. The save button remains desperatly grayed. It also seems impossible to open the library in another Access instance
12
1764
by: sparks | last post by:
My boss and I both have access 97 and access 2003 installed on our systems. Lately he has been having a lot of problems. Databases that won't close. The database looks like it closes but access will not. And other weird things...I just passed it off as just MS nothing new. Yesterday I asked him to look at a little project...nothing much of anything. I put it up on our server and he opened it and went into design view. Its a form with...
8
4687
by: Shooter4Life8 | last post by:
I am trying to run a macro from my VB.NET program. Here is my code. Dim myAccess As Access.Application Dim allMacro As String = "ALL-Macros" myAccess.DoCmd.RunMacro(allMacro) I get the error. "An unhandled exception of type 'System.NullReferenceException' occurred in
3
7151
by: olseni | last post by:
Hi all I have an Access 2007 database (file format accdb) and I wish to make it a master database, and replicate the database, its design as well as the data to another location, and then syncronize the data daily during nighttime. As far as I can see that should be posible, and I have tried using the standard Access help functions, finding a jro function that should enable the database to become a master, and also a jro function that...
0
9699
marktang
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...
0
9562
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,...
0
10303
jinu1996
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...
1
10282
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,...
0
10061
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 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...
0
5494
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...
0
5622
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3792
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2966
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.