473,320 Members | 2,003 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.

Incorrect data format after replication

The replication of my database was successful and it works well. I can
modify tables and forms, except for one thing : VBA ! I can’t add code
in VBA, the error message : "incorrect data format".
I worked on the database before the replication, and all was ok. After
replication, on the master-replica I managed to add some code only one
time, just before close and re-open the database. That was the last
time I was able to make change in VBA.
Do you have any idea how I can repair my database ?

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/MS-Access-In...ict216403.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=741885
Nov 13 '05 #1
3 1622
SimonDB <Us************@dbForumz.com> wrote in
news:4_***************************************@dbf orumz.com:
The replication of my database was successful and it works well. I
can modify tables and forms, except for one thing : VBA ! I can’t
add code in VBA, the error message : "incorrect data format".
I worked on the database before the replication, and all was ok.
After replication, on the master-replica I managed to add some
code only one time, just before close and re-open the database.
That was the last time I was able to make change in VBA.
Do you have any idea how I can repair my database ?


Why would you have any code in a replicated database?

Replication is for DATA and ONLY for data.

Yes, Microsoft claims it works for forms and reports and codes,
which are, after all, stored in Jet data tables (actually, in Jet 4,
the whole thing is stored as a binary BLOB in one single record of
one of the system tables). But on a practical basis, experience has
taught us that REPLICATION DOES NOT WORK FOR FRONT END FILES.

And, of course, if you've not split your database into back end data
file and front end application (with forms, reports, queries,
modules), then you're running with the wrong setup in the first
place.

I understand how people think that replication looks like a great
way to distribute front end updates, but it's simply not, as the
result is a quick increase in corruption and eventually (and not
very long, either) complete loss of the project as a whole.

DON'T REPLICATE FRONT ENDS.

Ever.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #2
"David W. Fenton" wrote:
SimonDB <Us************@dbForumz.com> wrote in
news:4_***************************************@dbf orumz.com:
The replication of my database was successful and it works

well. I
can modify tables and forms, except for one thing : VBA ! I

can’t
add code in VBA, the error message : "incorrect data

format".
I worked on the database before the replication, and all was

ok.
After replication, on the master-replica I managed to add

some
code only one time, just before close and re-open the

database.
That was the last time I was able to make change in VBA.
Do you have any idea how I can repair my database ?


Why would you have any code in a replicated database?

Replication is for DATA and ONLY for data.

Yes, Microsoft claims it works for forms and reports and
codes,
which are, after all, stored in Jet data tables (actually, in
Jet 4,
the whole thing is stored as a binary BLOB in one single
record of
one of the system tables). But on a practical basis,
experience has
taught us that REPLICATION DOES NOT WORK FOR FRONT END FILES.

And, of course, if you've not split your database into back
end data
file and front end application (with forms, reports, queries,
modules), then you're running with the wrong setup in the
first
place.

I understand how people think that replication looks like a
great
way to distribute front end updates, but it's simply not, as
the
result is a quick increase in corruption and eventually (and
not
very long, either) complete loss of the project as a whole.

DON'T REPLICATE FRONT ENDS.

Ever.

--
David W. Fenton
http://www.bway.net/~dfenton
dfenton at bway dot net
http://www.bway.net/~dfassoc


Thank you for the answer. That was not what I hoped, but now it’s
clear.
So the idea is to split the database to have the front end and the
back end and replicate only the back end. That’s the idea ?

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/MS-Access-In...ict216403.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=752372
Nov 13 '05 #3
SimonDB <Us************@dbForumz.com> wrote in
news:4_***************************************@dbf orumz.com:
So the idea is to split the database to have the front end and the
back end and replicate only the back end. That's the idea ?


That's definitely the idea, and the only way that Jet replication
really works.

Since I've always split front ends/back ends since my first
multi-user app (my first app ever, in fact), it never occurred to me
to replicate anything but the data.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #4

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

Similar topics

0
by: Jonathan | last post by:
In the organisation where I work we currently have a public sanitised version of our existing HR personnel database. This is very widely used as the main source of employee info by many internal...
0
by: Philip Trim | last post by:
General Brief: 3 SQL Servers as MS SQL Server 2000 Standard Edition with Service Pack 3 All using FTP for snapshots All Servers are both Publishers and Distributors. Server A has the correct...
1
by: Michelle Hillard | last post by:
Hi guys, would appreciate if you can shed some light on this. Sorry to be a pain, can you tell me what is wrong with the following: for /F %%i in ('dir /b /on c:\bcp\pc*.txt') do bcp...
4
by: someguy | last post by:
Hi, We are going to be running two SQL Server 2000's from the same physical server, with Windows Server 2003, and I need to have certain tables between them syncronized. Database A is a backend...
4
by: Hemant Shah | last post by:
Folks, I want to move the databases I have on a HP-UX system running DB2 UDB 7.2 to and AIX box running DB2 UDB 8.1. Because they are on different versions and different OS I cannot backup on HP...
2
by: Ray | last post by:
Hi, I have an Access 97 Database on the server, which gets updated from Desktops thru a LAN. Employees who have to go to offsite locations, carry the latest copy of the MDB. At the end-of-the...
4
by: Jeff Smith | last post by:
Hi Is there a way to do partial replication of data? I'm looking at having a central back end data file which contains all the data from all users. But when each user synchronises the mobile...
11
by: RipperT | last post by:
Don't know if this group covers web apps, but here goes. In VS 2005, I am trying to get variables to hold thier values during postback from the server. I convert a text box's user-keyed value to an...
3
by: Veeru71 | last post by:
We have got 2 DB2-UDB databases (DB1 & DB2) running on separate instances( Inst1 & Inst2). DB1 has got Schema1 and DB2 has got Schema2. We would like to setup some kind of replication to...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
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: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.