you can also make this from Enterprise Manager..

on source DB .. right click on your DB and choose all tasks .. Backup .. and save it to file

and take this file...

do something like this in Access

 dim cnn As ADODB.Connection

 Dim cmd As ADODB.Command

 Dim ErrorOnSQLProc As Long

 Dim DailyInvID_Out As Long

Set cnn = New ADODB.Connection

cnn.Open "DSN=" & DSNNAME

If MsgBox("Do you want to change...

I have some problems with Win XP before .. try to uninstall IIS from ADD/Remove programs .. windows component .. then install IIS again

I think also that you can import data into MS access and then transfer it to Oracle

i think also this permission gives you the ability to write JOIN statement ... which joins the tables faster (by FK and PK)

paste your problem here

I just want to say that there is no problem if you put any antivirus program on your server machine. and of course exclude the sncan of mdf, ndf and...

SQL server is monster in dealing with Memory .. so as you put more momory .. he use it all ..

and it is recommended to:

1- add more momory to your Server .....

you have to make a new table that has (date/time, user, Spname)

and you have to add code to add data of the user executing this procedure into above table ..

then...

so i think you give the user the ability to make relation between tables (by making FK) .. is it right?

why you don't try to store the path of the Image only in your database ... (less store , fast response)

and backup the folder that holds this image frequently

does you run you program on a domain ?

Note:

- you have to install SP3a to your MSDE

- install Mdac 2.7 SP1 on client and Server PCs

I also remeber that there...

I hope that you understand that David.Poole transfered your Access queries to SQL Stored procedures and And Add parametes to it (so you send it) ..

search on how to call a...

hi Antares686, your reply was more specific and it is realy helpful for a lot of us.

 so in Server properties .. you adjust maxmum concurrent user connection to 0 (unlimited)...

if you want to select data .. then write { with (nolock) } in table hint ... so no lock you make when dealing with the tables .. this will...