No I did not zipped the file. I just copied the *.bak file and tried to restore it. The size of the file is approx 80 Mb

Hi

I checked the application log. below are the description for the error

Event Type: Error

Event Source: MSSQLSERVER

Event Category: (2)

Event ID: ...

Thanks a lot I got rid of the error

and the script worked fine if both the publisher and subscriber are on the same machine, however if the subscriber and...

Thanks for your reply

I was able to merge two table however the final table has no more primary key and also in my database there is a relationship between...

Yes,

Primary keys are autonumber

This is how I have right now

On machine say A I have migrated corrected Access database (ABC.mdb) linked to SQL server on same machine A (ABC_SQL.mdf, ABC_SQL.ldf)

I took the backup...

Hi

I have attached the snapshot of error message with this post

Thanks Gaurav

most of the time client will not be connected to the main server. Therefore we have local SQL server on every machine with Access as its front end. So main...

Every machine will have its own SQL server and an access database as its front end

Now I have a working Access database (front end) linked to the local SQL...