problem in inserting the data in sqldatabase .adp file
hello guys,
I am trying to insert data in .adp dtabase.But i am not able to insert
it,but when i tried it with .mdb file i am able to insert data....can
you help me what should i do to inset data in .adp database.
should i make change in data type in .adp database.
This is my data declaration in database in .adp file which is not
working
column Name Datatype length allownulls
1) ID int 4
2)DateTimeStamp timestamp 8
3) MarketNo smallint 2 yes
4)marketName varchar 50 yes
5)Bid real 4 yes
6)Ask real 4 yes
7)MarketState tinyint 1 yes
Data declaration in .mdb database which is working
column Name Datatype
1) ID Number
2) DateTimeStamp Date/Time
3) MarketNo Number
4) MarketName Text
5) Bid Text
6) Ask Text
7)MarketState Text
Can anybody help me what change should i made database data type so
that it will work.....
i am using mapping also in my table headr file.
Thanks for any response.
.
Relevant Pages
- Re: Access 2003 to SQL Server 2000 over a VPN
... sufficiently fast response times, ADP may be a good enough client, ... Replication can be another solution, ... you're careful about your database design, though, that may be the way to ... As a result of the difficulties I've had, I try to avoid SQL Server ...
(microsoft.public.access.adp.sqlserver) - Re: Question on conversion to ADP
... the money toward developping .NET technologies instead of Access. ... result of passthrough queries read/write instead of read only and also make ... database become corrupted when the users will start making their very own ... of ADP but what they are pushed toward is - how could I say that politely - ...
(microsoft.public.access.adp.sqlserver) - Re: Access 2003 to SQL Server 2000 over a VPN
... you're careful about your database design, though, that may be the way to ... As a result of the difficulties I've had, I try to avoid SQL Server ... Would you consider using an ADP talking across an fast broadbank link to ... A thin client interface has been suggested, ...
(microsoft.public.access.adp.sqlserver) - Re: Recordsource only available to Administrator on clients
... if in the ADP all database items appear ... are you able to double-click and execute the uspPT stored procedure from ... Server instance is readily connected via SSMSE (Server type: Database ... to temporarily set a client user's privileges from, ...
(microsoft.public.access.adp.sqlserver) - Re: How to use extract a data table from from
... Right - have just had a play with an access .adp and your code works. ... If your database is an MDB file, I would recomment doing it the way I ... Dim rst As Recordset ...
(microsoft.public.access.modulesdaovba) |
|
